RMAN-06495: must explicitly specify DBID with SET DBID command,如何获得Oracle DBID?
SQL> show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string +DATA/purple/controlfile/curre
nt01, +DATA/purple/controlfile
/current02, +DATA/purple/contr
olfile/current03
方法一:通过查看trace文件
QL> conn /as sysdba
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2213896 bytes
Variable Size 1090521080 bytes
Database Buffers 553648128 bytes
Redo Buffers 7135232 bytes
SQL> select distinct tracefile from v$process p,v$session s ,v$mystat m where p.addr=s.paddr and s.sid=m.sid;
TRACEFILE
--------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/purple/purple1/trace/purple1_ora_12708.trc --获取当前trace文件
dump of an archived redo log file or online redo log file
SQL> alter system dump logfile '+data/purple/archivelog/2013_01_22/thread_1_seq_26.292.805368455';
System altered.
DUMP OF REDO FROM FILE '+data/purple/archivelog/2013_01_22/thread_1_seq_26.292.805368455'
Opcodes *.*
RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Compatibility Vsn = 186646528=0xb200000
Db ID=2860395360=0xaa7e2b60, Db Name='PURPLE'
OR
SQL> alter system dump logfile '+DATA/purple/onlinelog/group_2.258.805043623';
System altered.
获得当前数据库DBID=2860395360
方法二:通过RMAN 自动备份的控制文件(%F C-DBID-YYYYMMDD-QQ)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PURPLE are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/rman/%F';
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
86 Full 18.14M DISK 00:00:04 21-JAN-2013 15:05:20
BP Key: 86 Status: AVAILABLE Compressed: NO Tag: TAG20130121T150516
Piece Name: /rman/c-2860395360-20130121-08
Control File Included: Ckp SCN: 1384583 Ckp time: 21-JAN-2013 15:05:16
RMAN>
获得当前DBID=2860395360
方法三:使用DBMS_SYSTEM package.
方法四:查询v$database