-
How to apply archive log files to cold backup?
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
-
1 - restore backup
2 - recover database
-
May you give me more deatails checklist to do it, please?
Thanks,
-
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
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
HTML Code:
^^^
2.10 Send a Thank you note to Dave
Small things like this makes this forum lively :-).
Rgds
Parag
-
And a bigger thank you note to PAVB to have been so elaborate.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|