Re: rman duplicate to previous version after upgrade

From: Jared Still <>
Date: Fri, 30 Jan 2009 10:18:21 -0800
Message-ID: <>

On Fri, Jan 30, 2009 at 4:42 AM, Toth, Istvan 5 (GE Money) <> 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?

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

Received on Fri Jan 30 2009 - 12:18:21 CST

Original text of this message