本文共 2722 字,大约阅读时间需要 9 分钟。
某数据库使用open resetlogs开启后,rman命令总是失败并报告如下信息
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 12/28/2012 03:43:21
RMAN-20003: target database incarnation not found in recovery catalog
这是由于catalog没有加载最新的incarnation信息所致
一般说来,当数据库resetlogs开启后,需要在rman命令行中调用命令reset database以通知其新的incarnation已经产生了;
另外,如果数据库想恢复到resetlogs之前的某个状态,也需要先调用此命令;
Syntax Element | Description |
TO INCARNATION primary_key | Changes the current incarnation to an older incarnation. Specify the primary key of the DBINC record for the database incarnation. Run INCARNATION OF DATABASE to obtain possible key values. After you issue RESET DATABASE TO INCARNATION, then you can run RMAN commands such as RESTORE and RECOVER. |
采用nocatalog登陆查看rman 中数据库incarnation信息
db@localhost> $ORACLE_HOME/bin/rman target /
Recovery Manager: Release 9.2.0.8.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: DB (DBID=579131802)
RMAN> list incarnation of database db;
using target database controlfile instead of recovery catalog
List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 DB 579131802 NO 1 12-FEB-05
2 2 DB 579131802 NO 8809796368498 09-JUL-11
3 3 DB 579131802 YES 9049127486070 23-DEC-12
RMAN> reset database;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of reset command at 12/28/2012 04:03:34
RMAN-06002: command not allowed when not connected to a recovery catalog
采用catalog登陆
RMAN> connect catalog rman_sys/*****@rman;
connected to recovery catalog database
RMAN> list incarnation of database db;
List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
423298 423299 DB 579131802 NO 1 12-FEB-05
423298 52409251 DB 579131802 YES 8809796368498 09-JUL-11
--当前incarnation不是最新的,调用reset database注册最新的incarnation
RMAN> reset database;
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete
更多信息查看
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15480802/viewspace-751803/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15480802/viewspace-751803/