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;

#################################################################################

http://www.fadalti.com/oracle/database/rman_effective_use.htm

http://www.oracle-base.com/articles/10g/RMANEnhancements10g.php