薛之谦2015综艺大全:catalog模式登陆rman报：RMAN-20003错误

catalog模式登陆rman报：RMAN-20003错误

· 作者 小荷||【转载时请务必以超链接形式标明文章原始出处和作者信息】
· 永久链接: http://www.oracleblog.org/backup-recover/rman-catalog-backup-error/

---

今天用catalog模式登陆rman的时候报错：
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog；
最后通过reset database解决，先记录一下，至于为什么会产生这样的报错，代以后慢慢研究。

　
C:Documents and SettingsAdministrator>rman catalog rman/rman1981
 
 
恢复管理器: 版本9.2.0.1.0 - Production
 
 
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
 
 
连接到恢复目录数据库
 
 
RMAN> show all;
 
 
RMAN 配置参数为:
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-03002: failure of show command at 10/27/2006 11:43:39
 
RMAN-06171: not connected to target database
 
 
RMAN> connect target /
 
 
连接到目标数据库: ORALOCAL (DBID=3826047702)
 
 
RMAN> show all;
 
 
RMAN 配置参数为:
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-03002: failure of show command at 10/27/2006 11:44:00
 
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog
 
 
RMAN> resyn database;
 
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-00558: error encountered while parsing input commands
 
RMAN-01005: syntax error: found "identifier": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, startup, shutdown, send, show, test, upgrade, validate"
 
RMAN-01008: the bad identifier was: resyn
 
RMAN-01007: at line 1 column 1 file: standard input
 
 
RMAN> resync database;
 
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-00558: error encountered while parsing input commands
 
RMAN-01005: syntax error: found "database": expecting one of: "catalog"
 
RMAN-01007: at line 1 column 8 file: standard input
 
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-00558: error encountered while parsing input commands
 
RMAN-01005: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, startup, shutdown, send, show, test, upgrade, validate"
 
RMAN-01007: at line 1 column 16 file: standard input
 
 
RMAN> resync catalog;
 
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-03009: failure of resync command on default channel at 10/27/2006 11:50:19
 
RMAN-20003: target database incarnation not found in recovery catalog
 
 
RMAN> create catalog
 
 
恢复目录已经存在
 
 
RMAN> exit
 
 
 
恢复管理器完成。
 
 
C:Documents and SettingsAdministrator>rman catalog rman/rman1981 target /
 
 
恢复管理器: 版本9.2.0.1.0 - Production
 
 
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
 
 
连接到目标数据库: ORALOCAL (DBID=3826047702)
 
连接到恢复目录数据库
 
 
RMAN> show all;
 
 
RMAN 配置参数为:
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-03002: failure of show command at 10/27/2006 11:54:56
 
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog
 
 
RMAN> register database;
 
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-03009: failure of register command on default channel at 10/27/2006 11:59:24
 
RMAN-20002: target database already registered in recovery catalog
 
 
RMAN> target database incarnation not found
 
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-00558: error encountered while parsing input commands
 
RMAN-01005: syntax error: found "target": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, startup, shutdown, send, show, test, upgrade, validate"
 
RMAN-01007: at line 1 column 1 file: standard input
 
 
RMAN>
 
 
RMAN>
 
 
RMAN>
 
 
RMAN> list incarnation of database;
 
 
 
数据库 Incarnations 列表
 
DB 关键字 Inc 关键字 DB 名 DB ID CUR 重置 SCN 重置时间
 
------- ------- -------- ---------------- --- ---------- ----------
 
1 2 ORALOCAL 3826047702 YES 190578 16-8月 -06
 
 
RMAN> exit
 
 
 
恢复管理器完成。
 
 
C:Documents and SettingsAdministrator>rman catalog rman/rman11911 target /
 
 
恢复管理器: 版本9.2.0.1.0 - Production
 
 
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
 
 
连接到目标数据库: ORALOCAL (DBID=3826047702)
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-00554: initialization of internal recovery manager package failed
 
RMAN-04004: error from recovery catalog database: ORA-01017: invalid username/password; logon denied
 
 
C:Documents and SettingsAdministrator>reset database;
 
无效参数
 
RESET { SESSION }
 
 
C:Documents and SettingsAdministrator>rman catalog rman/rman1981
 
 
恢复管理器: 版本9.2.0.1.0 - Production
 
 
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
 
 
连接到恢复目录数据库
 
 
RMAN> connect target /
 
 
连接到目标数据库: ORALOCAL (DBID=3826047702)
 
 
RMAN> show all
 
2> ;
 
 
RMAN 配置参数为:
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-03002: failure of show command at 10/27/2006 12:10:14
 
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog
 
 
RMAN> reset database;
 
 
在恢复目录中注册的数据库的新实体化
 
正在启动全部恢复目录的 resync
 
完成全部 resync
 
 
RMAN> show all;
 
 
RMAN 配置参数为:
 
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
 
CONFIGURE BACKUP OPTIMIZATION OFF; # default
 
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
 
CONFIGURE CONTROLFILE AUTOBACKUP ON;
 
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:Back Updb bakRMAN_BKCTL_BAK_%F.RMN';
 
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
 
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
 
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
 
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
 
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:ORACLEORA92DATABASESNCFORALOCAL.ORA'; # default