RE: upgrade RMAN catalog problem
- From: Joe Smith <joe_dba@xxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>
- Date: Wed, 10 Dec 2008 19:22:51 -0600
Yes. There were two databases both 11.1.0.6.0 and both were upgraded with the
pathset to 11.1.0.7.0 at the same time.
That is what I was thinking, just build a new catalog.
thanks.
Date: Wed, 10 Dec 2008 16:44:15 -0800From: jkstill@xxxxxxxxxxx:
joe_dba@xxxxxxxxxxxxxxxxxx: Re: upgrade RMAN catalog problemCC:
oracle-l@xxxxxxxxxxxxx
On Mon, Dec 8, 2008 at 6:37 AM, Joe Smith <joe_dba@xxxxxxxxxxx> wrote:
I have run into a problem with the patchset going from 11.1.0.6.0 to 11.1.0.7.0
on Red Hat 32bit x86 Linux. The two databases I upgraded worked fine. I can't
upgrade my recovery catalog without getting the below error: connected to
recovery catalog databasePL/SQL package RMAN.DBMS_RCVCAT version 11.01.00.06 in
RCVCAT database is not currentDBGSQL: RCVCAT> begin :upgrade_completed
:= dbms_rcvcat.UPGRADE_COMPLETED;end; [11:02:40.057]DBGSQL: sqlcode =
6550 [11:02:40.057]Q: Are the only databases in that particular catalog the
same databases that you upgraded from 11.1.0.6 to 11.1.0.7?If that is the case,
why not just create a new catalog schema for the upgraded databases?You can't
really use the old backups to restore to 11.1.0.6 databases to 11.1.0.7.Well,
maybe you could, but it might be problematic.Something to consider anyway.
Leave the old catalog as is, create a new one, register the upgradeddatabases
in the new catalog.Should you need to restore from the old backups, you will
need to use 11.1.0.6Jared StillCertifiable Oracle DBA and Part Time Perl
Evangelist
_________________________________________________________________
Send e-mail anywhere. No map, no compass.
http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_anywhere_122008
Other related posts:
