Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help recovering archives when all files in sync

Re: help recovering archives when all files in sync

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sat, 21 Oct 2000 01:32:28 +1000
Message-ID: <39f057ef$1@news.iprimus.com.au>

Yes, don't restore the Control Files or online Redo Logs.

If you restore everything from a cold backup, you have a perfectly synchronised database as at the time of the cold backup.

What prompts the application of Archives is when SMON spots that the timestamps on the Control Files don't agree with the timestamps on everything else. So make sure you leave the Control Files at the point in time in the future, and bring back only the 'old' datafiles. The same goes for the Redo Logs (since you'll need their content to bring the database bang up to date -overwrite them with last night's backup, and you've just lost data).

The rules of backup and recovery are really very simple -and the simplest of them all is, if you have archives, you only ever restore the files which are causing the problem, not the whole lot.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"Joe Gulla" <jgulla_at_erols.com> wrote in message
news:8siobp$nb7$1_at_bob.news.rcn.net...

> I was trying to recover data from point of a full cold backup to a time
in
> future. I have all archives
> but since I replace all of database files from time of backup when I do a
> recover all instance is in ssync.
> Is there a way around this?
> Joe G
>
>
Received on Fri Oct 20 2000 - 10:32:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US