Re: RMAN catalog upgrade to 12c fails with ORA-00439: feature not enabled: Partitioning

From: Stefan Koehler <contact_at_soocs.de>
Date: Fri, 24 Oct 2014 15:13:44 +0200 (CEST)
Message-ID: <1409176666.96559.1414156424188.open-xchange_at_app10.ox.hosteurope.de>

Hi Marian,
well it is documented, but a little bit hidden in the official Oracle doc. Starting with 12.1.0.2, VPD is also a required feature for RMAN catalog databases (for virtual private catalogs). VPD is an enterprise edition option - so it is documented in some kind of way.

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

The "-all" option is not needed anyway.

Best Regards
Stefan Koehler

Oracle performance consultant and researcher http://www.soocs.de

> Marian Bednar <bednar_at_nbs.sk> hat am 24. Oktober 2014 um 14:38 geschrieben:
>
> Only FYI:
>
> After creating new 12.1.0.2 db I want to add it to RMAN backup. I've run UPGRADE CATALOG and here is output
>
> RMAN> upgrade catalog;
>
> recovery catalog owner is RMAN
> enter UPGRADE CATALOG command again to confirm catalog upgrade
>
> 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
>
> I am surprised to find that for RMAN catalog I need enterprise edition with partitioning...
>
> in Doc ID 1927265.1 is only statement "This is an undocumented requirement"
>
> Marian

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

Received on Fri Oct 24 2014 - 15:13:44 CEST