Cold Backup Recovery

Clean Shutdown Database

Copy all Datafile,controlfile,redo

When a database problem occurs, the recovery needs to copy all the backups to the specified location

The file name cannot carry a string of numbers, which can be. dbf. ctl. Log

Startup Nomount

Alter system set control_files= Scope=spfile;

Shutdown immediate

Startup Mount

Alter DATABASE rename file ' to ';

Recover database using Backup controlfile until cancel;

ALTER DATABASE open resetlogs;

--------------------------------------------------------------------------

T1 T2

T1 time Cold, t2 time problem, cold standby can only restore to T1 time, T1 to T2 between the operation of all lost

Cold Backup Recovery