任务：增加控制文件至三个

[oracle@enmo ~]$ export ORACLE_SID=ENMOEDU
[oracle@enmo ~]$
[oracle@enmo ~]$ echo $ORACLE_SID
ENMOEDU
[oracle@enmo ~]$
[oracle@enmo ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu May 26 10:20:49 2016

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS@ENMOEDU>
SYS@ENMOEDU>show parameter control

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /u01/app/oracle/oradata/ENMOED
U/ora_control1.ctl, /u01/app/o
racle/oradata/ENMOEDU/ora_cont
rol2.ctl
control_management_pack_access string DIAGNOSTIC+TUNING
SYS@ENMOEDU>
SYS@ENMOEDU>select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ENMOEDU/ora_control1.ctl
/u01/app/oracle/oradata/ENMOEDU/ora_control2.ctl

SYS@ENMOEDU>
SYS@ENMOEDU>alter system set control_files='/u01/app/oracle/oradata/ENMOEDU/ora_control1.ctl','/u01/app/oracle/oradata/ENMOEDU/ora_control2.ctl','/u01/app/oracle/oradata/ENMOEDU/ora_control3.ctl' scope=spfile;

System altered.

SYS@ENMOEDU>
SYS@ENMOEDU>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@ENMOEDU>
SYS@ENMOEDU>
SYS@ENMOEDU>!cp /u01/app/oracle/oradata/ENMOEDU/ora_control1.ctl /u01/app/oracle/oradata/ENMOEDU/ora_control3.ctl

SYS@ENMOEDU>
SYS@ENMOEDU>startup
ORACLE instance started.

Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 541068368 bytes
Database Buffers 289406976 bytes
Redo Buffers 2371584 bytes
Database mounted.
Database opened.
SYS@ENMOEDU>
SYS@ENMOEDU>show parameter control

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /u01/app/oracle/oradata/ENMOED
U/ora_control1.ctl, /u01/app/o
racle/oradata/ENMOEDU/ora_cont
rol2.ctl, /u01/app/oracle/orad
ata/ENMOEDU/ora_control3.ctl
control_management_pack_access string DIAGNOSTIC+TUNING
SYS@ENMOEDU>
SYS@ENMOEDU>
SYS@ENMOEDU>select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ENMOEDU/ora_control1.ctl
/u01/app/oracle/oradata/ENMOEDU/ora_control2.ctl
/u01/app/oracle/oradata/ENMOEDU/ora_control3.ctl

SYS@ENMOEDU>

ITPub博客

控制文件多元化

最新文章