-
full db recovery
Hi Friends,
OS - aix 4.3.2
db - oracle 8.1.5
We encountered a disk failure/crash in our database. We can't salvage
the data on the disk anymore, and eventually the entire disk where
the oracle_home and dbf reside was replaced. This happened on friday
evening. The db was in archive log mode, we do cold backup on
Sundays, and take daily backup of the archive logs (mon. thru sat.)
as what the backup/recovery docs suggest.
Following the recovery procedure, we reinstall the rdbms following
the same filesystem name and directories. Then we restore the cold
backup from 4mm tape to the target directories. We can now startup
the database from the previous Sunday backup. My problem is how to apply the backed-up archived logs from monday - friday? I've tried reading the recovery docs but it does not clearly explain the steps
or I was just a little dumb to understand it.
Please Help.
Thanks you
-
Last edited by jovery; 06-23-2003 at 08:30 AM.
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Thanks my friend. ....
You know, before posting here, I tried issueing the
command:
svrmgrl> recover database until cancel;
it returns an error and tells me to use backup controlfile;
and I am wondering if it is referring to the control file that
is backed up using "alter system backup controlfile to trace or
" or the control file that is backed-up using os copy.
BTW, is the control file that is an output to
"alter system backup controlfile to " can be used also?
Thanks again....:}
-
The controlfile is the one that was backed up during your normal cold backup.
HTH
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Kris,
I believe you backed up your controlfile (binary copy) when you cold backuped your datafiles on sundays. For doing this the command is ALTER DATABASE BACKUP CONTROLFILE TO 'file';
When you restored the db, you should have placed the backuped datafiles in original place and the backuped controlfile as well. Then, startup mount and do RECOVER DATABASE USING BACKUP CONTROLFILE;
F.
-
Thanks Mnem....:}
Actually I made two (2) types of control file backup.
One, user "os copy" command and the other using
"ALTER DATABASE BACKUP CONTROLFILE TO 'file';"
What's the difference between the two?
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
|