数据库从nomount启动到mount状态后,查看日志:Wed Dec 17 13:23:19 2014
alter database mount
Wed Dec 17 13:23:23 2014
Successful mount of redo thread 1, with mount id 1394303559
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Wed Dec 17 13:36:20 2014
db_recovery_file_dest_size of 3882 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
日志中提示成功加载redo线程。并输出mount id 1394303559 这里在经过多次重启后观察变化,还可以转储控制文件来观察变化。
查看参数中的配置(11g默认产生两个控制文件,一个放在数据目录下,另一个放在闪回区目录下):SQL> show parameters control_files;
NAME TYPE VALUE
------------------ -----