Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle8i (8.1.6) Backup and Recovery Questions
I have questions about restoring an oracle db from a hot backup.
Here is the scenario that I am experimenting with and the recovery actions I'm taking:
All the disks on my server machine are fried and all data is lost. I need to restore the machine and Oracle.
I do a weekly cold backup of Oracle running in ARCHIVELOG mode. In addition I do a daily hot backup of Oracle.
Restoration procedure:
SVRMGRL> connect internal; SVRMGRL> startup mount; SVRMGRL> recover database until cancel using backup control file;
...hitting enter until I get to the prompt for the last redo archive, then I hit cancel.
SVRMGRL> alter database open resetlogs;
6. I do a cold backup of the db.
Q1: I was able to run "recover database until cancel using backup control file;" without actually restoring the backed up version of the control file. Should I have restored the backed up control file into the oradata/<db-name> directory prior to running step 5?
Q2: Why did the recovery work even though I didn't restore the hot backed up version of the control file? Doesn't the control file restored from the cold backup have an old SCN?
Q3: How would Oracle know about the necessity to apply archived redo logs? (Is it from detecting data files that have newer SCNs than that in the control file?)
Thanks,
Alex.
Received on Thu Dec 13 2001 - 10:30:16 CST