知识点参考 盖国强《深入浅出oracle-入门,进阶与诊断案例》
1. 启动nomount 状态以后,oracle可以从参数文件中获得控制文件的位置信息,数据库中一般缺省为3个控制文件,控制文件的内容是一样的;
SQL> startup nomount
ORACLE instancestarted.
Total SystemGlobal Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 83888372 bytes
DatabaseBuffers 79691776 bytes
Redo Buffers 2973696 bytes
SQL> show parameter control_files
NAME TYPE
----------------------------------------------------------
VALUE
------------------------------
control_files string
/oradata/law/law/control01.ctl
,/oradata/law/law/control02.c
tl,/oradata/law/law/control03
.ctl
SQL> alter database mount;
Database altered.
SQL> selectname from v$controlfi