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

今天用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


RMAN>
 

相关文章

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据