在数据库无法nomount的时候什么日志可以查询到DBID？

jieyancai

还可以用这个方法：
http://www.itpub.net/viewthread. ... ghlight=&page=1

yudingchu

。。。。
学习

lozity

原帖由 kdkd 于 2008-4-19 23:23 发表
o1_mf_s_652448295_40lt98wr_.bkp中的652448295可能就是dbid了，lz确认一下此文件名的格式

652448295不是DBID，我的DBID是：

[oracle@pejoy ~]$ rman target/

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Apr 20 00:08:36 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: FOX (DBID=833886678, not open)

RMAN>

kdkd

哈哈，sorry，我错了，差点害了lz。

[ 本帖最后由 kdkd 于 2008-4-20 12:01 编辑 ]

kdkd

lz，我的版本是9204，结果与你有点差别，必须在mount状态下才显示DBID，看来方法与版本有点关系：）请大家指教

---启动例程之前
[oracle@hh ~]$ rman target/

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database (not started)

RMAN> exit

Recovery Manager complete.

-----启动例程，即nomount状态，rman target/并没有列出dbid
[oracle@hh ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Sun Apr 20 02:22:30 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  126948772 bytes
Fixed Size                   452004 bytes
Variable Size              58720256 bytes
Database Buffers           67108864 bytes
Redo Buffers                 667648 bytes
SQL> select status from v$instance;

STATUS
------------
STARTED

SQL> host
[oracle@hh ~]$ rman target /

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: orcl (not mounted)

RMAN> exit  

Recovery Manager complete.

[oracle@hh ~]$ exit
exit

----DB启动至mount状态，rman target/就显示dbid了。
SQL> alter database mount
  2  ;

Database altered.

SQL> host
[oracle@hh ~]$ rman target /

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: ORCL (DBID=1153803032)

RMAN> exit


Recovery Manager complete.
[oracle@hh ~]$ exit
exit

SQL> alter database open;

Database altered.

SQL> host
[oracle@sgk ~]$ rman target /

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: ORCL (DBID=1153803032)

RMAN> exit


Recovery Manager complete.

[ 本帖最后由 kdkd 于 2008-4-20 12:28 编辑 ]

lozity

原帖由 lozity 于 2008-4-19 22:22 发表
eygle的文章中说到：“如果数据库配置了自动控制文件备份(Oracle9i),并且名称是缺省的,那么我们可以从自动备份文件获得DBID. ”

为什么我开启了自动备份控制文件的功能，在$ORACLE_HOME/dbs下还是没有看到 c 打头的文件？郁闷……

为什么我看不到C打头的文件呢？？？我是10g的库