如何获取Oracle DBID

来源：互联网发布：2016省市区数据库json 编辑：程序博客网时间：2024/05/29 10:40

RMAN-06495: must explicitly specify DBID with SET DBID command,如何获得Ｏｒａｃｌｅ　ＤＢＩＤ？

SQL> show parameter control_filesNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------control_files                        string      +DATA/purple/controlfile/curre                                                 nt01, +DATA/purple/controlfile                                                 /current02, +DATA/purple/contr                                                 olfile/current03

方法一：通过查看ｔｒａｃｅ文件

QL> conn /as sysdbaConnected to an idle instance.SQL> startup nomount;ORACLE instance started.Total System Global Area 1653518336 bytesFixed Size                  2213896 bytesVariable Size            1090521080 bytesDatabase Buffers          553648128 bytesRedo Buffers                7135232 bytesSQL> 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　--获取当前ｔｒａｃｅ文件dump of an archived redo log file or online redo log fileSQL> 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'ＯＲSQL> alter system dump logfile '+DATA/purple/onlinelog/group_2.258.805043623';System altered.获得当前数据库ＤＢＩＤ＝2860395360

方法二：通过ＲＭＡＮ　自动备份的控制文件（％Ｆ　Ｃ－ＤＢＩＤ－ＹＹＹＹＭＭＤＤ－ＱＱ）

RMAN> show all;using target database control file instead of recovery catalogRMAN 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:16RMAN>获得当前ＤＢＩＤ＝2860395360

方法三：使用DBMS_SYSTEM package.

方法四：查询v$database