Code Listing 5: Restoring a Database Using RMAN


RMAN> restore database;

Starting restore at 14-JAN-03

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\ORADATA\PROD\SYSTEM01.DBF
restoring datafile 00002 to D:\ORACLE\ORADATA\PROD\UNDOTBS01.DBF
restoring datafile 00003 to D:\ORACLE\ORADATA\PROD\APPL_IDX01.DBF

restoring datafile 00004 to D:\ORACLE\ORADATA\PROD\APPL_TAB01.DBF
restoring datafile 00005 to D:\ORACLE\ORADATA\PROD\TOOLS01.DBF
channel ORA_DISK_1: restored backup piece 1
piece handle=D:\ORACLE\RDBMS\920\DATABASE\04E4GI2K_1_1 tag=TAG20021005T211916 pa
rams=NULL
channel ORA_DISK_1: restore complete
channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00006 to D:\ORACLE\ORADATA\PROD\USERS01.DBF
channel ORA_DISK_1: restored backup piece 1
piece handle=D:\ORACLE\RDBMS\920\DATABASE\05E4HPE9_1_1 tag=TAG20021006T083105 pa
rams=NULL
channel ORA_DISK_1: restore complete
Finished restore at 14-JAN-03


E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy