User-controlled remote recovery of oracle Hot Standby files

Objective: To detect the recovery availability of oracle Hot Standby files (including spfiles, control files, data files, archived logs, and non-rman files) in windows from different machines and non-original paths. Test environment: windows2003R2, O

Objective: To detect the recovery availability of oracle Hot Standby files (including spfiles, control files, data files, archived logs, and non-rman files) in windows from different machines and non-original paths. Test environment: windows2003R2, O

Objective: To detect oracle Hot Standby files (4 (, 6 (, AL32UTF8) in windows

7. Shut down the database, start to nomount mode, delete or rename the control file used before, and execute the above code to create the control file:

8. Start the database to mount mode.

Alter database mount;

9. Restore the database by archiving logs. Specify the path of the archive file during recovery.

Recover database using backup controlfile until cancel

10. After the restoration is complete, start the database in resetlogs mode:

Alter database open resetlogs;

My blog: