获取db_id,db_key的方法

(法一)

sql>conn rman/rman

sql>select * from db;

 DB_KEY      DB_ID HIGH_CONF_RECID LAST_KCCDIVTS CURR_DBINC_KEY
---------- ---------- --------------- ------------- --------------
         1  602205554               0     647861618              2
(法二)

sql>conn / as sysdba

sql>select db_id,db_key from rc_database;

 DB_KEY  DBINC_KEY       DBID NAME     RESETLOGS_CHANGE# RESETLOGS
---------- ---------- ---------- -------- ----------------- ---------
         1          2  602205554 RAC2                     1 28-FEB-08
注:v$database只有DB_ID,执行RMAN登陆时也会显示DB_ID

(法三)

RMAN>list incarnation of database;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            CUR Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       2       RAC2     602205554        YES 1          28-FEB-08