|
-
Originally posted by jmodic
In fact, the only case when you need to copy online redo log files with cold backup is when your databas was shut down in ABORT mode prior to backup.
Well, what happens if you lose everything (including redo logs) and have to recover from a cold backup?
The only option you have is, restore datafiles, cotrolfile and open the database with RESETLOGS and you may also have to issue a fake recover command in order to avaoid ORA-01139
And when you open db with RESETLOGS all your previous hot backups will be invalidated.
I would still backup redo logs with cold backup to avoid going through all these hassles.
Sanjay
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
|