Method 1:Through SQL command prompt. SQL> select dbid from v$database; DBID ---------- 3764293269 Method 2:Through RMAN [oracle@canada ~]$ rman target =/ Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 14 16:41:00 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: DELL (DBID=3764293269) RMAN> Method 3: By Generating Trace Files SQL> startup nomount SQL> alter session set tracefile_identifier = myoradump; SQL> alter system dump datafile '/u01/app/oracle/oradata/dell/system01.dbf' block min 1 block max 10; In user_dump_test find trace file "myoradump" in that search "Db ID" Start dump data block from file /u01/app/oracle/oradata/dell/system01.dbf minblk 1 maxblk 10 V10 STYLE FILE HEADER: Compatibility Vsn = 186646528=0xb200000 Db ID=3764293269=0xe05e8e95, Db Name='DELL' Activation ID=0=0x0 Control Seq=659=0x293, File size=85760=0x14f00 File Number=1, Blksiz=8192, File Type=3 DATA Same command can be used for log and archived log files SQL> alter system dump logfile" "
Search This Blog
Thursday, December 27, 2012
Different ways to get the DBID of Database.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment