RE: rman duplicate to previous version after upgrade

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.

Julio

-----Original Message-----
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.

Regards,
Istvan

-----Original Message-----
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 9.2.0.4.
> 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 | mobile.google.com

Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l