Want to restore the contents of a tablespace from a backup.
|Who would benefit from this IDEA?||DBA when recovering from either a user mistake or system failure|
How should it work?
Today to restore a tablespace the entire image file must be read.
for us the image files are stored on Random access devices it will good if the entire backup doesn't have to be read. for use this is very large.
During backup each image file has N tablespaces that are concurrently written (N =Degree of parallelism of backup). Therefore it is possible to record the start and end location of each tablespace within an image file. Therefore it should be possible to restore a tablespace without having to read the entire image file.
Thus reducing the read requirements and duration of restore.
|Priority Justification||Our Database are very large. it is essential we bound the recovery time.|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions