Re: Apply new redo logs from original db to restored db

From: Mark Bole <makbo_at_pacbell.net>
Date: Mon, 11 Apr 2005 15:31:59 GMT
Message-ID: <PLw6e.945$t85.58@newssvr21.news.prodigy.com>

hosea.basis_at_gmail.com wrote:

> Hi.
>
> I have a full offline backup of the databaseA. After a restore of this
> to another new, clean databaseB. Can i have the new redo logs from
> databaseA to be applied to databaseB?
>
> I could see that the key differnce will be the difference in the SCN of
> control files and the datafiles. And even a copy of the control files
> from databaseA to databaseB wont be able to help.
>
> In other words, there is no way for this to happen?
>
> Please advise
>

Not enough information. Did you OPEN RESETLOGS the new database? Did you create a backup controlfile? Are you using RMAN?

The following doc makes a good read as well:

"Recovering a Backup Created Before a RESETLOGS"

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96572/performingreco.htm#14918

-Mark Bole Received on Mon Apr 11 2005 - 10:31:59 CDT