Re: Backup Recovery - Cold Backup in Archive log mode

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 9 Jun 2004 09:37:01 +1000
Message-ID: <40c64d87$0$3037$afc38c87@news.optusnet.com.au>

"raj" <rajesh_choprauk_at_yahoo.co.uk> wrote in message news:80c4d335.0406081512.49502aa8_at_posting.google.com...
> I want to implement the following approach to backuping our oracle
> database server.
>
> The aim is to allow for point in time recovery of transactions.
>
> Weekly Cold Backup
> Archive Log Mode
>
> I'm a little confused with regards to the recovery of control files
> and redo logs prior to Point in time Recovery. Can someone help
> clarify?
>
> Raj

What's your source of confusion?

You *never* restore control files or online redo logs to perform any sort of recovery whatsoever, unless you've actually lost your control files or online redo logs.

That's rule 1.

Rule 2 is that you never, ever back up your online redo logs. So even if you've lost your online redo logs, you won't actually restore them (instead you'll re-create them with an open resetlogs).

Rule 3 is: to perform a point in time recovery, you restore all data files, and 'recover database until...'. That's it. No restoring or recovering of control files or online logs necessary.

If you could elaborate on what your confusion is, we could go through some scenarios with you to help eliminate it.

Regards
HJR Received on Tue Jun 08 2004 - 18:37:01 CDT