oracle 多路复用,Oracle控制文件多路复用

查询控制文件路径

SYS@zwcdb:~>SELECT name FROM v$controlfile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/primarydb/control01.ctl

/u01/app/oracle/oradata/primarydb/control02.ctl

/u01/app/oracle/oradata/primarydb/control03.ctl

修改spfile

SYS@zwcdb:~>ALTER system SET control_files=

2 '/u01/app/oracle/oradata/primarydb/control01.ctl',

3 '/u01/app/oracle/oradata/primarydb/control02.ctl',

4 '/u01/app/oracle/oradata/primarydb/control03.ctl',

5 '/u01/app/control04.ctl' scope=spfile;

System altered.

关闭数据库,复制控制文件至/u01/app下

SYS@zwcdb:~>shutdown immediate

DATABASE closed.

DATABASE dismounted.

ORACLE instance shut down.

SYS@zwcdb:~>exit

Disconnected FROM Oracle DATABASE 10g Enterprise Edition Release 10.2.0.1.0 - Production

WITH the Partitioning, OLAP AND DATA Mining options

[oracle@zwc ~]$ cp /u01/app/oracle/oradata/primarydb/control01.ctl /u01/app/control04.ctl

重新启动数据库并验证

[oracle@zwc ~]$ sqlplus / AS sysdba

SQL*Plus: Release 10.2.0.1.0 - Production ON Fri Jan 6 10:35:05 2012

Copyright (c) 1982, 2005, Oracle. ALL rights reserved.

Connected TO an idle instance.

SYS@zwcdb:~>startup

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed SIZE 1218992 bytes

Variable SIZE 92276304 bytes

DATABASE Buffers 188743680 bytes

Redo Buffers 2973696 bytes

DATABASE mounted.

DATABASE opened.

SYS@zwcdb:~>

SYS@zwcdb:~>SELECT name FROM v$controlfile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/primarydb/control01.ctl

/u01/app/oracle/oradata/primarydb/control02.ctl

/u01/app/oracle/oradata/primarydb/control03.ctl

/u01/app/control04.ctl

SYS@zwcdb:~>SELECT VALUE FROM v$spparameter WHERE name='control_files';

VALUE

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/primarydb/control01.ctl

/u01/app/oracle/oradata/primarydb/control02.ctl

/u01/app/oracle/oradata/primarydb/control03.ctl

/u01/app/control04.ctl