catalog BBDD “cat”, release 11.1.0.7
owner catalog : “cat”
rman executable release 11.1.0.7
target database: “ws11g”, dbid: “3462601361″, release 11.1.0.7
Catalog and Target database share ORACLE_HOME
Trying to create a virtual private catalog in catalog “cat” bbdd “cat” for user “cat_vpc” who have to manage only bbdd “ws11g”:
virtual private catalog owner (vpc owner): “cat_vpc”.
User “cat_vpc” has been created in bbdd “cat” with steps:
In “cat” database:
SQL> create user cat_vpc identified by cat_vpc default tablespace USERS quota unlimited on USERS;
SQL> grant recovery_catalog_owner to cat_vpc;
In “cat” database with “rman” executable:
==========================================
export ORACLE_SID=ws11g
Recovery Manager complete.
-bash-3.00$ rman catalog cat/cat@cat target /
Recovery Manager: Release 11.1.0.7.0 – Production on Tue Apr 21 10:41:41 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: WS11G (DBID=3462601361)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> grant catalog for database 3462601361 to cat_vpc;
Grant succeeded.
In “cat” database with “rman” executable and user “cat_vpc”:
=============================================================
-bash-3.00$ rman catalog cat_vpc/cat@cat
Recovery Manager: Release 11.1.0.7.0 – Production on Tue Apr 21 10:43:43 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog;
found eligible base catalog owned by CAT
DBGSQL: RCVCAT> begin CAT.dbms_rcvcat.create_virtual_catalog;end; [10:43:52.225]
DBGSQL: sqlcode = 6550 [10:43:52.226]
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00600: internal error, arguments [9302] [6550] [begin CAT.dbms_rcvcat.create_virtual_catalog;end;] [] []
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1, column 11:
PLS-00302: component ‘DBMS_RCVCAT’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ISSUE CLARIFICATION
===================
– Problem Statement:
Error at:
o RDBMS: 11.1.0.7
RMAN> create virtual catalog;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00600: internal error, arguments [9302] [6550] [begin
CAT.dbms_rcvcat.create_virtual_catalog;end;] [] []
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1, column 11:
PLS-00302: component ‘DBMS_RCVCAT’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ISSUE ANALYSIS
—————————
Research: looks related..
———
Bug:7215146 (80) RMAN-00600 INTERNAL ERROR, ARGUMENTS [9302] [6550] ERRORS:
Fixed In Ver: 11.2
Note:741913.1 Ext/Rev ERROR UPGRADING RMAN CATALOG SCHEMA TO 11.1.0.7:
I searched for known issues, and found Bug:7215146 which looks very close related.
Even your erro did not happen at upgrade catalog, but with create virtual catalog
I suspect the RMAn Catalog 11.1.0.7 had some issue when upgraded.
Please see follwoing Note and try if the Workaround helped to get around this issue
=> Note:741913.1 Ext/Rev ERROR UPGRADING RMAN CATALOG SCHEMA TO 11.1.0.7:
Addtl Info ( if not knwon already)
Note.416509.1 Ext/Pub RMAN 11G Virtual Catalog:
Catalog was created directly in database release 11.1.0.7.
We have applied workaround from bug 7215146, but the result is the same:
-bash-3.00$ export ORACLE_SID=cat
-bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 – Production on Thu Apr 23 00:59:59 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select owner from dba_objects where object_name=’DBMS_RCVCAT’;
OWNER
——————————
CAT
CAT
SQL> connect cat/cat
Connected.
SQL> create or replace package dbms_rcvcat authid current_user is
2 function getPackageVersion return varchar2;
3 function getCatalogVersion return varchar2;
4 — Used to identify if the upgrade of catalog schema was not complete
5 UPGRADE_COMPLETED CONSTANT number := 0;
6 end;
7 /
Package created.
SQL> create or replace package body dbms_rcvcat is
function getPackageVersion return varchar2 is
begin
return ’11.01.00.07′;
end;
function getCatalogVersion return varchar2 is
begin
return ’11.01.00.07′;
end;
end; 2 3 4 5 6 7 8 9 10
11 /
Package body created.
-bash-3.00$ rman catalog cat/cat
Recovery Manager: Release 11.1.0.7.0 – Production on Thu Apr 23 01:02:20 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to recovery catalog database
recovery catalog is partially upgraded to 11.01.00.07; UPGRADE CATALOG again
RMAN> upgrade catalog;
recovery catalog owner is CAT
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> upgrade catalog;
recovery catalog upgraded to version 11.01.00.07
DBMS_RCVMAN package upgraded to version 11.01.00.07
DBMS_RCVCAT package upgraded to version 11.01.00.07
RMAN>
-bash-3.00$ rman catalog cat_vpc/cat
Recovery Manager: Release 11.1.0.7.0 – Production on Thu Apr 23 01:04:06 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog;
found eligible base catalog owned by CAT
DBGSQL: RCVCAT> begin CAT.dbms_rcvcat.create_virtual_catalog;end; [01:04:34.929]
DBGSQL: sqlcode = 6550 [01:04:34.929]
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00600: internal error, arguments [9302] [6550] [begin CAT.dbms_rcvcat.create_virtual_catalog;end;] [] []
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1, column 11:
PLS-00302: component ‘DBMS_RCVCAT’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Bug:8479222 CREATE VIRTUAL PRIVAT CATALOG FAILED RMAN-00600: ARGUMENTS [9302] [6550]
BUG 8479222 : CREATE VIRTUAL PRIVATE CATALOG FAILED RMAN-600 [9302] [6550] IF OWNER IS ‘CAT’
SOLUTION / ACTION PLAN
======================
– To implement the solution, please execute the following steps::
Hello Maria,
I checked for the Bug entered for this issue / status/update
( may be you have seen already )
Bug:8479222 CREATE VIRTUAL PRIVAT CATALOG FAILED RMAN-00600: ARGUMENTS [9302] [6550]
the Problem is the name used for the Catalog owner -> ‘CAT’ !!
o If the owner of the catalog is not named ‘CAT’ the problem does not happen.
Workaround:
———–
=> Do not use ‘CAT’ as the name for the owner of the recovery catalog.
© 2010 – 2012, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.
相关文章 | Related posts:
- RMAN 11G : Data Recovery Advisor – RMAN command line example
- RMAN Performance Tuning Using Buffer Memory Parameters
- Oracle恢复目录的管理使用简要
- How to Minimise the impact of an Online RMAN Backup on an OLTP system
- How to Extract Controlfiles, Datafiles, and Archived Logs from RMAN Backupsets
- 特殊情况下如何找出数据库的DBID
- A Complete Understanding of RMAN Compression
- Rman 备份检验功能
- How to resolve ORA-00600 [13013], [5001] [ID 816784.1]
- ORA-00600 [kddummy_blkchk]错误一例
最新评论