ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN--How to register 10gR2 target db into 9iR2 catalog db on HP-UX(原)

RMAN--How to register 10gR2 target db into 9iR2 catalog db on HP-UX(原)

原创 Linux操作系统 作者:vongates 时间:2019-01-21 15:18:06 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-09-11

  • 博文量
    449
  • 访问量
    319547