Re: Recovery on a New Machine

Hi Nancy,

What you can recover is related directly to which redo logs you have access to (and that might depend on how crashed you database server is). Providing you still have access to the disk system, everything should potentially be hunky dory, no ?

Can you access any portion of the previous database ? The key portion here I guess are the online redo logs, or specifically those that were not archived. The current controlfile might prove useful too. Hey, if you can access all the datafiles we can really be in business.

If the answer is no, then an incomplete recovery using your cold backup datafiles and controlfile is your best option. Startup mount followed by a RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL. Hit cancel when you've applied your last available redo log and open database with resetlogs.

Losing all your data and corresponding redo log is not a nice situation to be in.

However if you do have access to all the unarchived redo logs, no worries, they can be applied and bingo, the database is back (although if you're using the backed up controlfile you still need to open the database with resetlogs).

So a lot depends on what is still accessible in your original database.

Good Luck

Richard
"Nancy Wells" <nancy_b_wells_at_hotmail.com> wrote in message news:1f14c0b1.0209170142.37a9e10e_at_posting.google.com...
> I have a database running in archive log mode and i have taken a cold
> backup on sunday night.
>
> Mon/Tue/Wednesday, database is used. Lot of archive files are
> generated...
>
> Wedneday afternoon , database machine is crashed.
>
> Only option is to set up a new machine and restore the datbase from
> the sunday cold backup:
>
> What is the procedure to restore on a new machine? Just resotore all
> the cold backup data files, control files and init.ora (including Redo
> logs?) and start the instance?
>
> How do i recover the Mon-Wed data from the archive logs? My guess is:
> Since i've restored from a cold backup (Sundays), my control file will
> also be sundays. Do i need to replace it with a latest copy
> (preferably Wednessday before crash). From that point can i recover as
> usual...
>
> Thank you very much for your answers.
>
> N Wells
Received on Tue Sep 17 2002 - 07:22:11 CDT