How to apply archive log files to cold backup?

[danghongsinh]

Hi All,

My database operates in ARCHIVELOG mode. I took Cold backup (datafiles, control files and redo log files) at Monday night. On Tuesday, My system had media failure, I lost all files but all archive log files from last cold backup still remain.
How can I recover database until time of failure from Cold backup and archive log files?
How to apply archive log files to cold backup?

Thanks in advance,
Sinh

[davey23uk]

1 - restore backup
2 - recover database

[danghongsinh]

May you give me more deatails checklist to do it, please?

Thanks,

[PAVB]

Please let me elaborate Dave's process which is just fine.

1.0 Restore Cold Backup

2.0 Recover Database
2.1 sqlplus /nolog
2.2 conn sys as sysdba
2.3 startup mount
2.4 recover database using backup controlfile until cancel;
2.5 Apply your logs
2.6 CANCEL
2.7 alter database open resetlogs;
2.8 shutdown
2.9 startup
2.10 Send a Thank you note to Dave

[paragp1981]

^^^
2.10 Send a Thank you note to Dave

Small things like this makes this forum lively :-).

[gtcol]

And a bigger thank you note to PAVB to have been so elaborate.