oracle数据库的dbid,查看oracle 数据库的DBID

(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文件的内容

原文：http://www.cnblogs.com/wangchaoyuana/p/7532017.html