resetlogs 打开数据库时新生成日志位置问题(二)

2014-11-24 17:47:44 · 作者: · 浏览: 1
6 16:33:49 2013


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


Connected to an idle instance.


SQL> @/oracle/control1.sql
ORACLE instance started.


Total System Global Area 1152450560 bytes
Fixed Size 2225832 bytes
Variable Size 704645464 bytes
Database Buffers 436207616 bytes
Redo Buffers 9371648 bytes


Control file created.


SQL> alter database open resetlogs;


Database altered.


SQL> col member for a60
SQL> /


GROUP# MEMBER
---------- ------------------------------------------------------------
2 /oracle/CRM/ZBCRM/ZBCRM/onlinelog/o1_mf_2_8z4f4kon_.log
1 /oracle/CRM/ZBCRM/ZBCRM/onlinelog/o1_mf_1_8z4f4gcl_.log
结果:当重建控制文件语句中为指定日志条目,仅指定omf参数db_create_file_dest时,resetlogs打开数据库后,日志位于db_create_file_dest指定的目录。