Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Subject: RE: rman duplicate to previous version after upgrade
Date: Mon, 2 Feb 2009 10:01:35 +0100
Message-ID: <CC62ED7D8059D0438D84127EFBC4B6BC04BF4B2B@BUDMLVEM02.e2k.ad.ge.com>
In-Reply-To: <bf46380901311708h4585e04m1b86b097df315dec@mail.gmail.com>
Thread-Topic: rman duplicate to previous version after upgrade
References: <CC62ED7D8059D0438D84127EFBC4B6BC04BF4363@BUDMLVEM02.e2k.ad.ge.com> <bf46380901301018v31d8e8eew74632453c7c98f9d@mail.gmail.com> <CC62ED7D8059D0438D84127EFBC4B6BC02E9A2CD@BUDMLVEM02.e2k.ad.ge.com> <bf46380901311708h4585e04m1b86b097df315dec@mail.gmail.com>
From: "Toth, Istvan 5 (GE Money)" <istvan5.toth@ge.com>
To: "Jared Still" <jkstill@gmail.com>, <Oracle-L@freelists.org>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: istvan5.toth@ge.com

Hello Jared,

Thank you for the answer.
With your help I managed to restore the database to the new server.
Just for the list archive the steps were:

Startup nomount
Connect old catalog and the instance
Restore controlfile to <new location>
Mount
Set newname for all datafile
Restore database
Switch all datafile
Recover until time

Thanks again,
Istvan

-----Original Message-----
From: Jared Still [mailto:jkstill@gmail.com] 
Sent: 2009. február 1. 2:09
To: Toth, Istvan 5 (GE Money); Oracle-L@freelists.org
Subject: Re: rman duplicate to previous version after upgrade

I think all you need to do is a restore of the old database to the new server.

In a nutshell:

Startup nomount new instance
Connec to instance and rman catalog
From RMAN "set dbid ..."
You can get the dbid from the 9i catalog via rc_database

Do a restore

This is from memory ( on my blackberry) so you may want to consult the manual

Jared


On 1/31/09, Toth, Istvan 5 (GE Money) <istvan5.toth@ge.com> wrote:
> Hello Jared,
>
>
>
> I registered the upgraded database to the 10g catalog. So the backup
> information is available in the old 9i catalog (we have three separate
> RMAN catalog databases, one for 8i databases, one for 9i databases, one
> for 10g databases, not just different shema in a catalog database)
>
> I tried to start duplicate with the old oracle home (92040) RMAN command
> and with the old catalog, but I can't connect to target because it's
> running now from a different OH (102030) and duplicate doesn't work
> without "connect target"  as far as I Know.
>
>
>
>
>
>
>
> From: Jared Still [mailto:jkstill@gmail.com]
> Sent: Friday, January 30, 2009 7:18 PM
> To: Toth, Istvan 5 (GE Money)
> Cc: Oracle-L@freelists.org
> Subject: Re: rman duplicate to previous version after upgrade
>
>
>
> On Fri, Jan 30, 2009 at 4:42 AM, Toth, Istvan 5 (GE Money)
> <istvan5.toth@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?
>
>
> How did you handle the upgrade at the RMAN catalog?
>
> Did you register the newly upgraded database into a 10g catalog schema?
>
> Or did you upgrade the catalog that the database was already registered
> in?
>
> If the former, all you need to do is use the older catalog and duplicate
> the database.
>
> If the latter, well, I don't know how to do that.
>
> It will take some testing.
>
> The problem would be that you will be trying to restore a 9i database
> using
> a catalog that has been upgraded to 10g.
>
> My suggestion would be to open an SR with Oracle Support and ask how to
> proceed.
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>

-- 
Sent from Gmail for mobile | mobile.google.com

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
 

__________ Information from ESET NOD32 Antivirus, version of virus signature database 3816 (20090201) __________

The message was checked by ESET NOD32 Antivirus.

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