RE: rman duplicate to previous version after upgrade
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 wish.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Toth, Istvan 5 (GE Money) Sent: Friday, January 30, 2009 9:13 AM
To: Niall Litchfield; Oracle-L_at_freelists.org 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.
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: 2009. január 30. 14:26
To: Toth, Istvan 5 (GE Money); Oracle-L_at_freelists.org 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_at_ge.com> wrote:
> Hello list,
> A target database has been upgraded to 10.2.0.3 from 188.8.131.52.
> 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,
-- Sent from Google Mail for mobile | mobile.google.com Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 30 2009 - 09:13:34 CST