List Incarnation 语法含义

发布时间：2020-08-14 06:08:04 作者：Davis_itpub
来源：ITPUB博客阅读：329


RMAN> connect target /
connected to target database: HUIYI (DBID=2592573446)

RMAN> list incarnation;
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       HUIYI    2592573446       YES 486740452  16-Mar-07 10:16:11


RMAN> connect catalog rman92/rman@huiyi2;

connected to recovery catalog database

RMAN> connect target /

connected to target database: HUIYI (DBID=2592573446)

RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            CUR Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       2       HUIYI    2592573446       YES 486740452  16-Mar-07 10:16:11

内容	说明
DB_NAME	数据库名称(v$database.name)
DB ID	DB ID(v$database.dbid)
CUR	是否为当前，如果数据库有被多次用RESETLOGS打开的话，这里会有多条记录
RESET SCN	RESETLOGS的SCN
RESET TIME	RESETLOGS的TIME

注：用目标数据库的控制文件和目录数据库二种的INC KEY会不同！

[@more@]

List Incarnation 语法含义

相关阅读