Monday 28 June 2010

RMAN effective use



Restore Preview

The PREVIEW option of the RESTORE command allows you to identify the backups required to complete a specific restore operation. The output generated by the command is in the same format as the LIST command. In addition the PREVIEW SUMMARYcommand can be used to produce a summary report with the same format as the LIST SUMMARY command. The following examples show how these commands are used:
# Preview 
RESTORE DATABASE PREVIEW; 
RESTORE TABLESPACE users PREVIEW;
# Preview Summary 
RESTORE DATABASE PREVIEW SUMMARY;

RESTORE DATABASE UNTIL TIME 'sysdate-2' PREVIEW SUMMARY; 
          RESTORE ARCHIVELOG UNTIL TIME 'sysdate-3' PREVIEW SUMMARY; 
     
          RESTORE TABLESPACE users PREVIEW SUMMARY;

##################################Boon Statement ###################################
 RESTORE DATABASE UNTIL TIME "to_date('26-01-2012 18:00:00','dd-mm-yyyy hh24:mi:ss')" PREVIEW SUMMARY;
#################################################################################


No comments: