How to register 10gR2 target db into 9iR2 catalog db on HP-ux
操作系统: HP-UX 11iv2
备份软件:Legato 7.3
目录数据库:oracle 9iR2 EE
目标数据库:oracle 10gR2 EE
目标数据库从9i升级到10g后,暂时还没有空来升级catalog数据库,先这样用着吧,列个简单的作业步骤
0.Create backup library on target DB
0.0 $cd $ORACLE_HOME/lib
0.1 $ln -s /usr/lib/libnwora.so libobk.so
1.create backup account on catalog DB
1.0 sqlplus "/ as sysdba"
1.1 create user rman21 identified by rman;
1.2 alter user rman21 default tablespace rmanprod;
1.3 GRANT RECOVERY_CATALOG_OWNER TO rman21;
1.4 GRANT CONNECT, RESOURCE TO rman21;
2.install recovery catalog and register target db to catalog db.
2.0 rman
2.1 connect target
2.2 connect catalog
2.3 create catalog;
2.4 register database;
2.5 list incarnation;
3.solution for some error of create process
3.1
Q: identifier 'DBMS_RCVMAN.SETDATABASE' must be declared
A: 先连接到目标库,再连接到目录数据库,如果顺序反掉就报这个错
3.2
Q: RECOVERY_CATALOG_OWNER role must be granted to user RMAN21
A: 在目录库中要把用户加到RECOVERY_CATALOG_OWNER角色中
szv021 [oracle] $ rman
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Jul 9 12:38:43 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect catalog
connected to recovery catalog database
RMAN> connect target
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_RCVMAN.SETDATABASE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06550: line 1, column 120:
PLS-00201: identifier 'DBMS_RCVMAN.SETCANAPPLYANYREDO' must be declared
ORA-06550: line 1, column 120:
PL/SQL: Statement ignored
RMAN> exit
Recovery Manager complete.
szv021 [oracle] $ rman
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Jul 9 12:39:41 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target
connected to target database: FPLSUZP (DBID=3514999954)
RMAN> connect catalog
connected to recovery catalog database
RMAN> create catalog;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user RMAN21
RMAN> create catalog;
recovery catalog created
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN>
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 2 FPLSUZP 3514999954 CURRENT 8038360048420 08-JAN-07
RMAN>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29987/viewspace-52015/,如需转载,请注明出处,否则将追究法律责任。