Describe and Tune Instance RecoveryPerform Complete and Incomplete RecoveryUsing the RMAN RESTORE and RECOVER CommandsPerforming Complete Recovery of a Noncritical DatafileExercise 5-1: Restore and Recover the USERS TablespacePerforming Complete Recovery of a Critical DatafilePerforming Incomplete Recovery Using RMANExercise 5-2: Perform Incomplete Recovery to Restore the USERS TablespaceRecovering Using Incrementally Updated BackupsSwitching to Image Copies for Fast RecoveryExercise 5-3: Use the SWITCH Command to Recover a Datafile QuicklyExercise 5-4: Use the SWITCH Command after Creating the USERS Tablespace’s Datafile in the Original LocationPerform Recovery for SPFILEs, Password Files, Control Files, and Redo Log FilesRestoring the SPFILE from the AutobackupRestoring the Control File from the AutobackupExercise 5-5: Restore the Control File from an AutobackupRecovering from a Lost Redo Log GroupUnderstanding Log Group StatusRecovering from Log Group Member FailuresRecovering from Loss of an Entire Log GroupRecover from the Loss of the Password FileExercise 5-6: Re-create the Password File after Accidental DeletionRecovering the Control FileExercise 5-7: Recover from the Loss of All Control FilesPerform Recovery of Index and Read-Only Tablespaces and TempfilesRecovering from a Lost TempfileExercise 5-8: Create a Replacement Tempfile for the TEMP TablespaceRestore a Database to a New HostUnderstanding Restoration to a New HostPreparing the New HostRestoring and Recovering on the New HostTwo-Minute DrillQ&A Self TestSelf Test Answers