DBAII_R1_1_Les13_E

Views:
 
Category: Education
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

RMAN Complete Recovery : 

RMAN Complete Recovery

Objectives : 

Objectives After completing this lesson, you should be able to do the following: Describe the use of RMAN for restoration and recovery Perform complete recovery in ARCHIVELOG mode Restore datafiles to different locations Relocate and recover a tablespace by using archived redo log files

Restoration and Datafile Media Recovery Using RMAN : 

Restoration and Datafile Media Recovery Using RMAN Restore files from backup sets or image copies by using the RMAN RESTORE command Recover files by using the RMAN RECOVER command

Using RMAN to Recover a Database in ARCHIVELOG Mode : 

Using RMAN to Recover a Database in ARCHIVELOG Mode rman target / RMAN> STARTUP MOUNT RMAN> RESTORE DATABASE; RMAN> RECOVER DATABASE; RMAN> ALTER DATABASE OPEN;

Using the Recovery Wizard : 

Using the Recovery Wizard

Using RMAN to Restore Datafiles to a New Location : 

Using RMAN to Restore Datafiles to a New Location Use the SET NEWNAME command to restore the datafile to the new location. Use the SWITCH command to record the change in the control file. SET NEWNAME FOR DATAFILE 1 to ‘/<newdir>/system01.dbf’; SWITCH DATAFILE ALL;

Restoring to a New Location : 

Restoring to a New Location

Using RMAN to Recover a Tablespace : 

Using RMAN to Recover a Tablespace Use the following RMAN commands to restore and recover a tablespace: RESTORE TABLESPACE RECOVER TABLESPACE run{ sql “alter tablespace users offline immediate”; restore tablespace users; recover tablespace users; sql “alter tablespace users online”; }

Tablespace Recovery : 

Tablespace Recovery

Using RMAN to Relocate a Tablespace : 

Using RMAN to Relocate a Tablespace Use the SET NEWNAME command to restore the files. Use the SWITCH command to record the new names in the control file. Use the RECOVER TABLESPACE command to recover the datafiles of the tablespace.

Summary : 

Summary In this lesson, you should have learned how to: Recover a database in ARCHIVELOG mode Restore datafiles to different locations if the original location is unavailable

Practices 13-1 and 13-2 Overview : 

Practices 13-1 and 13-2 Overview These practices cover the following topics: Using RMAN to recover a tablespace Using RMAN to recover relocated datafiles

authorStream Live Help