查看oracle 資料庫的DBID

標籤：taf   min   檔案的   test   rod   select   over   users   target   

 
（1）使用rman查看
$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jun 12 03:20:19 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: DBTEST (DBID=1275017193)
RMAN>

（2）使用sqlplus查看
SQL> select dbid from v$database;

      DBID
----------
1275017193

（3）dump檔案查看

#dump記錄檔
SQL> alter system dump logfile ‘/u01/app/oracle/oradata/dbtest/redo01.log‘;

 

#dump資料檔案

SQL> alter system dump datafile ‘/u01/app/oracle/oradata/dbtest/users01.dbf‘ block min 1 block max 4;

 

#dump歸檔日誌
SQL> alter system dump  logfile ‘/home/oracle/arch/1_11_882154347.dbf‘; 

然後查看dump檔案的內容

查看oracle 資料庫的DBID