Re: rman duplicate to previous version after upgrade

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: istvan5.toth@xxxxxx
  • Date: Fri, 30 Jan 2009 10:18:21 -0800

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

Other related posts: