RE: rman duplicate to previous version after upgrade

  • From: "QuijadaReina, Julio C" <QuijadJC@xxxxxxxxxxxxxxx>
  • To: "istvan5.toth@xxxxxx" <istvan5.toth@xxxxxx>, Niall Litchfield <niall.litchfield@xxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
  • Date: Fri, 30 Jan 2009 10:13:34 -0500


Within a run RMAN script, you could use 'set until time' right before the 
duplicate command. That will cause RMAN to recover up to the date and time you 


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Toth, Istvan 5 (GE Money)
Sent: Friday, January 30, 2009 9:13 AM
To: Niall Litchfield; Oracle-L@xxxxxxxxxxxxx
Subject: RE: rman duplicate to previous version after upgrade

Yes I have cold backup just before the upgrade. The problem is: the upgrade was 
in 8th January 2009, and the restore time need to be 31 December 2008 23:59:00.
The database is/was in archivelog mode, and the catalog is still holding (for a 
few days - because of the 37 days retention policy) the online backup 
information for the previous version.


-----Original Message-----
From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx] 
Sent: 2009. január 30. 14:26
To: Toth, Istvan 5 (GE Money); Oracle-L@xxxxxxxxxxxxx
Subject: Re: rman duplicate to previous version after upgrade

Hi ivan, you'd want to restore from an old backup and recover in that
situation. That's one of the reasons the upgrade process asks if
you've taken a backup first.

On 1/30/09, Toth, Istvan 5 (GE Money) <istvan5.toth@xxxxxx> wrote:
> Hello list,
> A target database has been upgraded to from
> It is now necessary to restore the database to another host taking it
> back to a point in time BEFORE the upgrade. I'm using an RMAN catalog
> database to store the backup information.
> Is it possible to do this with RMAN duplicate, or how can I do this?
> Please help,
> Regards,
> Istvan

Sent from Google Mail for mobile |

Niall Litchfield
Oracle DBA


Other related posts: