Oracle控制文件多路复用

来源：互联网发布：淘宝群优惠群怎么做的编辑：程序博客网时间：2024/06/15 08:32

查询控制文件路径

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 immediateDATABASE closed.DATABASE dismounted.ORACLE instance shut down.SYS@zwcdb:~>exitDisconnected FROM Oracle DATABASE 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWITH 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 sysdbaSQL*Plus: Release 10.2.0.1.0 - Production ON Fri Jan 6 10:35:05 2012Copyright (c) 1982, 2005, Oracle.  ALL rights reserved.Connected TO an idle instance.SYS@zwcdb:~>startupORACLE instance started.Total System Global Area  285212672 bytesFixed SIZE                  1218992 bytesVariable SIZE              92276304 bytesDATABASE Buffers          188743680 bytesRedo Buffers                2973696 bytesDATABASE 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