Oracle 入门之控制文件multiplex - 数据库编程

[oracle@jsb-ylw-5024 ~]$ sqlplus /nolog //启动Oracle数据库，并查看当前控制文件的个数和储存位置

SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 8 10:48:02 2010

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1620115456 bytes
Fixed Size 2213816 bytes
Variable Size 939526216 bytes
Database Buffers 671088640 bytes
Redo Buffers 7286784 bytes
Database mounted.
Database opened.
SQL> show parameter control; //可以看到当前存在两个控制文件

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /u01/oradata/yang/control01.ct
l, /u01/flash_recovery_area/ya
ng/control02.ctl
control_management_pack_access string DIAGNOSTIC+TUNING

SQL> shutdown immediate; //关闭数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create pfile from spfile; //根据spfile生成pfile，若使用不同的参数文件，则需要加路径

File created.
SQL> !
[oracle@jsb-ylw-5024 ~]$ cp /u01/oradata/yang/control01.ctl /u01/oracle/control03.ctl //使用cp命令复制控制文件
[oracle@jsb-ylw-5024 ~]$ grep -i 'control' /u01/oracle/dbs/inityang.ora //修改pfile的control_files值如下
*.control_files='/u01/oradata/yang/control01.ctl','/u01/flash_recovery_area/yang/control02.ctl','/u01/oracle/control03.ctl'
[oracle@jsb-ylw-5024 ~]$ exit
exit

SQL> startup pfile=$ORACLE_HOME/dbs/inityang.ora //使用pfile启动oracle数据库
ORACLE instance started.

Total System Global Area 1620115456 bytes
Fixed Size 2213816 bytes
Variable Size 939526216 bytes
Database Buffers 671088640 bytes
Redo Buffers 7286784 bytes
Database mounted.
Database opened.

SQL> show parameter control; //查看已经修改成功

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /u01/oradata/yang/control01.ct
l, /u01/flash_recovery_area/ya
ng/control02.ctl, /u01/oracle/
control03.ctl
control_management_pack_access string DIAGNOSTIC+TUNING

SQL> shutdown immediate; //关闭数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create spfile from pfile; //根据pfile生成spfile

File created.

SQL> startup //使用spfile启动Oracle
ORACLE instance started.

Total System Global Area 1620115456 bytes
Fixed Size 2213816 bytes
Variable Size 939526216 bytes
Database Buffers 671088640 bytes
Redo Buffers 7286784 bytes
Database mounted.
Database opened.
SQL> !
[oracle@jsb-ylw-5024 ~]$ mv /u01/oracle/control03.ctl /tmp/
[oracle@jsb-ylw-5024 ~]$ exit
exit

SQL> shutdown immediate;
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/oracle/contr

Oracle 入门之控制文件multiplex(一)