Big talk RAC Media recovery---Only backup file recovery

Scenario : Oracle 10g RAC; Data files, control files, online logs, and parameter files are archived to ASM using ASM. After a full backup, delete all control files, online logs, data files, and finally take advantage of the backup for incomplete recovery.

1. Simulating a disaster scenario (slightly)

2. Recovery steps

1. Boot the database to the Nomount state Sql>startup Nomount2. Use Rman to recover a control file from an automated backup, and execute a backup set of the Rman>restore controfile from ' storage files ' in an instance; 3. Mount database rman>sql ' ALTER DATABASE Mount '; 4. Recover data files Rman>restore database; Note: Using OMF to maintain files is that files are renamed, and synchronizes to the control file 5. Archive log records in control files Sql>select name from V$archived_log; 6. Archive Log on disk export Oracle_sid=+asm1asmcmd-pasmcmd[+arch1/wxxrtest/]>ls ..... 7. Re-enlist the archive log not recorded in the control file to the control file see Rman>catalog archivelog ' +arch1/wxxrtest/1_69_660747390.dbf '; 8. Review the archive log records in the control file Sql>select thread#,sequence#,name,next_change# from v$archived_log;9. Perform incomplete recovery sql>recover Database using Backup Controfile until cancal;10. To open the databases in resetlogs mode rman>sql ' ALTER DATABASE open resetlogs '; 11. Open another instance $srvctl Start database-d wxxrtest

Organized from "Big talk RAC" Zhang Xiaoming p301-p306

Big talk RAC Media recovery---Only backup file recovery