Re: Recovery possible?

A copy of this was sent to Kevin Cheung <kcheung_at_poboxes.com> (if that email address didn't require changing) On Fri, 02 Jul 1999 22:51:54 +0800, you wrote:

>If I shutdown an instance (running archive log mode) for cold backup,
>all datafiles, control files, redolog files and archive log are saved,
>is it possible to do a recovery in case of instance failure?
>
>Thanks,
>Kevin

If you shutdown normal or shutdown immediate yes.

If you shutdown abort and back it up -- you will not be able to roll this backed up instance forward.

You should *not* backup online redolog files for an archive log mode database (you should definitely NOT restore them).

You technically do not need to save the archived redo log *when you back up the instance* during a cold backup unless you have an older cold backup you might want to apply them to. You do want to back up and save archived redo log generated AFTER the backup to roll forward with.

You might consider getting the backup and recovery handbook (amazon will find it fast for you). backup and recovery is a complex subject and not to be taken lightly (if you value your data that is :)

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jul 02 1999 - 09:54:01 CDT