RMAN Catalog Upgrade to Oracle 12.1.0.2

It sounds so simple - but in this specific case a bit of doc reading is required as upgrading the RMAN catalog to handle Oracle 12.1.0.2 databases is not as trivial as in the past. 

Thanks to a German customer and a friendly colleague from Sales Consulting in Stuttgart I have learned my RMAN lesson for Oracle Database 12.1.0.2 this week. A simple "upgrade catalog" is not the correct step once you'd like to handle backups of Oracle 12.1.0.2 databases in your current catalog schema. 

Even though you may not have ever heard before about Virtual Private Catalogs you need to follow this guideline:

http://docs.oracle.com/database/121/BRADV/rcmcatdb.htm#BRADV848

The doc tells you to run this step first:

SQL> @$ORACLE_HOME/rdbms/admin/dbmsrmansys.sql

  • Please ignore the "-all" option printed in the doc - this is a known docu bug
  • If you miss this step the upgrade of the catalog will fail with a warning that your user lacks privileges 

$ rman CATALOG my_catalog_owner@catdb
recovery catalog database Password: 
RMAN> UPGRADE CATALOG; 
RMAN> EXIT; 

It should work now :-)

-Mike 

Comments:

It also now appears that the RMAN catalog must reside in a Enterprise Edition Database. I hit the issue above, however the subsequent "Upgrade Catalog" resulted in

RMAN> upgrade catalog;

error creating create_deleted_object_seq
RMAN-00571: ===========================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===========================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-00439: feature not enabled: Partitioning

Posted by guest on August 13, 2014 at 06:04 AM CEST #

I'm not aware of this - would you please mind to open an SR for this as it sounds a bit strange to myself?

If you don't mind to mail me directly (firstname.lastname@oracle.com) I will get back to you directly.

Cheers,
Mike

Posted by Mike on August 14, 2014 at 03:48 AM CEST #

The scenario given in the linked Doc is applicable to "Upgrading Virtual Private Catalogs (VPC)". Otherwise the process is the same as pre-12c. I was able to upgrade mine without these issues. VPC is still an option in 12c, not mandatory. It allows you to use single RMAN catalog for all databases, yet restrict access to data for individual databases. This is practical when different DBAs/DBOs DON'T have access to all databases, but only to specific databases.

Posted by guest on November 12, 2014 at 11:49 PM CET #

Thanks but I disagree!

Regardless if you'll ever use Virtual Private Catalogs you will have to execute the dbrmansys.sql script - otherwise your UPGRADE CATALOG will fail.

The doc is pretty misleading here as it sounds as if you would need that script ONLY IF ... but in fact everybody will need to run it to ensure the privs set correctly before the catalog can be upgraded.

Give it a try without if you don't believe it ;-)

Cheers
Mike

Posted by Mike on November 19, 2014 at 12:25 PM CET #

I had performed multiple successful RMAN catalog upgrades from "11.02.00.03" to "12.01.00.01" before posting my last comment. No errors during the upgrade and database Syncs to RMAN catalog are occurring just fine.

Posted by Abdul M Gill on November 19, 2014 at 11:08 PM CET #

Abdul,

thanks for your update - but please read my post carefully.

I've said "ORACLE 12.1.0.2".
That change got introduced with Oracle 12.1.0.2 - if you had done RMAN Catalog Upgrades in 12.1.0.1 you won't see this.

Please see the headline of my blog post.

Cheers
Mike

Posted by Mike on November 21, 2014 at 09:45 AM CET #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Mike Dietrich - Oracle Mike Dietrich
Senior Principal Technologist - Database Upgrade Development Group - Oracle Corporation

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite with reference customers. Acting as interlink between customers and the Upgrade Development.

Contact me either via XING or LinkedIn

Search

Archives
« March 2015
SunMonTueWedThuFriSat
1
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today
Oracle related Tech Blogs
Slides Download Center
Visitors since 17-OCT-2011
White Paper and Docs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers