1.1. Lost all data files
Big premise, control files and log files are not damaged.
1.1.1. Simulation Lost All Data Files
RMAN> Shutdown Abort;
Oracle routines have been closed
Rman> Host;
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C: /> DEL D: / ORACLE92 / TEST1 / *. DBF
C: /> EXIT
Host command is completed
Rman>
1.1.2. Mount database
Rman> Startup Mount;
Target database (not started)
Oracle routines have been started
Database has been loaded
System Global Region Total 101784276 bytes
Fixed size 453332 bytes
Variable size 75497472 bytes
Database buffers 25165824 bytes
Redo buffers 667648 bytes
Rman>
1.1.3. Restore Database (Restore)
RMAN> Restore Database;
Start Restore in 2007- October -04
Assigned channel: ORA_DISK_1
Channel ORA_DISK_1: SID = 13 DevType = Disk
Channel ORA_DISK_1: Restore Data File Backup Set
Channel ORA_DISK_1: Data file that is specified from backup set recovery
It is recovering data file 00002 to D: /oracle92/oradata/test1/undotbs01.dbf
Positive data file 00003 is restored to D: /oracle92/oradata/test1/indx01.dbf
Restore data file 00004 to d: /oracle92/oradata/test1/users01.dbf
Channel ORA_DISK_1: Restored Backup Segment 1
Segment Handle = D: / RMANTEST / FULL
01g
1V3R8_1_1 tag = hot_db_bk_level0 params = NULL
Channel ORA_DISK_1: Restore completion
Channel ORA_DISK_1: Restore Data File Backup Set
Channel ORA_DISK_1: Data file that is specified from backup set recovery
Restore data file 00001 to D: /oracle92/oradata/test1/system01.dbf
Channel ORA_DISK_1: Restored Backup Segment 1
Segment Handle = D: / RMANTEST / FULL
02g
1V3RO_2_1 tag = hot_db_bk_level0 params = null
Channel ORA_DISK_1: Restore completion
Complete Restore in 2007- October -04
Rman>
1.1.4. Recovery Database (Recovery)
RMAN> Recover Database;
Start Recover in 2007- October -04
Use channel ORA_DISK_1
Recovery of the media
Completion of media recovery
Complete Recover in 2007- October -04
Rman>
1.1.5. Open the database
Rman> ALTER DATABASE OPEN
Database has been opened
Rman>
1.2. Lost all data files, control files and online log files
1.2.1. Simulation Lost All Data Files, Control Files, Online Log Files
RMAN> Shutdown Abort;
Oracle routines have been closed
Manually delete all data files, control files, online log files.
1.2.2. Nomount Database RMAN> Startup Nomount;
Target database (not started)
Oracle routines have been started
System Global Region Total 101784276 bytes
Fixed size 453332 bytes
Variable size 75497472 bytes
Database buffers 25165824 bytes
Redo buffers 667648 bytes
Rman>
1.2.3. Restore Control File
RMAN> Restore ControlFile;
Start Restore in 2007- October -04
Assigned channel: ORA_DISK_1
Channel ORA_DISK_1: SID = 13 DevType = Disk
Channel ORA_DISK_1: Restore Data File Backup Set
Channel ORA_DISK_1: Restore Control File
Output file name = d: /oracle92/oradata/test1/control01.ctl
Channel ORA_DISK_1: Restored Backup Segment 1
Section Handle = D: /RMANTEST/CTL538939298_S4_P1.CTL TAG = Tag20041007T172138 params = null
Channel ORA_DISK_1: Restore completion
Copy the control file
Output file name = d: /oracle92/oradata/test1/control01.ctl
Output file name = d: /oracle92/oradata/test1/control02.ctl
Output file name = d: /oracle92/oradata/test1/control03.ctl
Complete Restore in 2007- October -04
Rman>
1.2.4. Restore all data files
RMAN> Restore Database;
Start Restore in 2007- October -04
Use channel ORA_DISK_1
Channel ORA_DISK_1: Restore Data File Backup Set
Channel ORA_DISK_1: Data file that is specified from backup set recovery
It is recovering data file 00002 to D: /oracle92/oradata/test1/undotbs01.dbf
Positive data file 00003 is restored to D: /oracle92/oradata/test1/indx01.dbf
Restore data file 00004 to d: /oracle92/oradata/test1/users01.dbf
Channel ORA_DISK_1: Restored Backup Segment 1
Segment Handle = D: / RMANTEST / FULL
01g
1V3R8_1_1 tag = hot_db_bk_level0 params = NULL
Channel ORA_DISK_1: Restore completion
Channel ORA_DISK_1: Restore Data File Backup Set
Channel ORA_DISK_1: Data file that is specified from backup set recovery
Restore data file 00001 to D: /oracle92/oradata/test1/system01.dbf
Channel ORA_DISK_1: Restored Backup Segment 1
Segment Handle = D: / RMANTEST / FULL
02g
1V3RO_2_1 tag = hot_db_bk_level0 params = null
Channel ORA_DISK_1: Restore completion
Complete Restore in 2007- October -04
Rman>
1.2.5. Mount database
Rman> Alter Database Mount;
Database has been loaded
Rman>
1.2.6. Recovery database (based on SCN recovery)
RMAN> Recover Database Until SCN 71028;
Start Recover in 2007- October -04 Use channel ORA_DISK_1
Recovery of the media
Archive Log Tail 1 Sequence 3 has been used as a file D: /oracle92/admin/test1/ArCH /ARC00003.Arch exists on disk
Archive Log Tail 1 Sequence 4 has been used as a file D: /oracle92/admin/test1/ArCH /ARC00004.Arch exists on disk
Archive log file name = d: /oracle92/admin/test1/ArCH /ARC00003.Arch thread = 1 sequence = 3
Archive log file name = d: /oracle92/admin/test1/ArCH /ARC00004.Arch thread = 1 sequence = 4
Completion of media recovery
Complete Recover in 2007- October -04
Rman>
1.2.7. Recover the database using the ResetLogs option
Rman> ALTER DATABASE OPEN RESETLOGS;
Database has been opened
New physicalization of the database registered in the recovery directory
Rosync that is starting all restored directories
Complete all RESYNC
Rman>
