Re: DATABASE RECOVERY !!!! HELP!!! DBA s
Date: 1996/06/11
Message-ID: <31bd997f.13617720_at_news2.ios.com>#1/1
Shankar Ramanathan <srnathan_at_amoco.com> wrote:
>Hi,
>
>Thank you for all of you who responded very quickly. However looks
>like i did not state my situation right.
>
>I did recover the database. ;-)))
>
>Situation.
>
>I have a cold backup of , control file, datafile and all other files
>except the redo log files (after the database is shutdown).
>I did have a redo log file copy, an hour earlier.
>Also i had the redo logs intact when one of the disk crashed.
>
>Now after several attempts of recovery , i figured if i some how
>tell oracle to create a new control file and forget about the
>redo i will be OK.
>
>That is exactly what i did.
>
>1. Startup mount.
>2. alter database backup controlfile trace.
>3. Edit the latest trace (this is a create controlfile script).
>4. _at_trace_file.
>5. Shutdown normal.
>6. startup.
>7. I am back in business!!!
>
>Refer the bulletin board article 1012929.6:
>
>However i was lucky because this is a cold backup and not much
>activity bettween the backup and the crash.
>
>I would recomend copying the redo log files also, strongly otherwise
>the backup is useless.
>
>Thanks again for every one who responded...
If nobody else has suggested it, I'd recommend two things.
- Mirror your online redo logs on separate disks
- If your database is changed at all between cold backups, run it in archive log mode. -- Chuck Hamilton chuckh_at_dvol.com
Never share a foxhole with anyone braver than yourself! Received on Tue Jun 11 1996 - 00:00:00 CEST