Manual apply archive log

Suppose online backup a database on tim1, then continue to backup the archive log on time 2,  time 3, ……time n (last archive log backup)

When database crash want to recover the database base on the full online backup on time1 plus archive log on time 2, time 3 to time n.

 

Key point:

 

when do full online backup, must backup the database control file:

alter database backup controlfile to ‘d:\control.bak’;

 

then when do recover:

startup mount;

recover database using backup control file until cancel;

through select max(sequence#) from v$log_history; to verify it.

 

but when open database must use alter database open resetlogs;