RE: rman duplicate to previous version after upgrade
Date: Fri, 30 Jan 2009 09:22:15 -0600
Message-ID: <565F609E6D736D439837F1A1A797F34101C6F2E8_at_ADMINMAIL1.ui.uillinois.edu>
What about setting the DBID, startup nomount, then attempting to restore the controlfile for the 9i instance from autobackup? Then run nid (http://www.psoug.org/reference/utilities.html#utni) to change the DBID so you don't conflict with your production DB, restore the old db, then do the duplication?
Just make sure your paths are different than your 10g instance, ie, controlfiles, datafiles, etc etc. You can run a set newname in the RMAN block or pfile to avoid this.
Throwing some stuff out that I would try, your mileage may vary.
Best of luck and let us know how it goes!
Thanks- Chris
-----Original Message-----
From: Toth, Istvan 5 (GE Money) [mailto:istvan5.toth_at_ge.com]
Sent: Friday, January 30, 2009 9:15 AM
To: Newman, Christopher
Subject: RE: rman duplicate to previous version after upgrade
Hi Christopher,
Unfortunately I cannot list incarnation. The situation is that we have separate RMAN catalog for the main oracle versions (one for 8i, one for 9i, one for 10g). If I connect to the 9i catalog with the 9i oracle owner, I can't connect to target, because now is 10.2.0.3.0 version with different oracle owner. I get this:
RMAN> list incarnation;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================RMAN-03002: failure of list command at 01/30/2009 16:10:12 RMAN-06171: not connected to target database
RMAN> connect target
connected to target database (not started)
RMAN> list incarnation;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================RMAN-03002: failure of list command at 01/30/2009 16:15:11 RMAN-06403: could not obtain a fully authorized session ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory
But the database is up, running from a different Oracle Home.
-----Original Message-----
From: Newman, Christopher [mailto:cjnewman_at_uillinois.edu]
Sent: 2009. janu�r 30. 15:51
To: Toth, Istvan 5 (GE Money)
Subject: RE: rman duplicate to previous version after upgrade
Hi Istvan,
This is an interesting problem, and I'm anxious to see what the listers say. Here's some thoughts:
Can you 'list incarnation' in rman, and have the older version show up properly? If so, I'd venture to say you could throw a 'SET INCARNATION' in your duplication script along with the point in time and be good to go.
Thoughts?
-----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 8: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-lReceived on Fri Jan 30 2009 - 09:22:15 CST