Oracle数据库添加和移动控制文件

1. SQL> set lines 200;
   
2. SQL> col name for a50;
   
3. SQL> select * from v$controlfile;
   
4. 
   
5. STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
   
6. ------- ------------------------------ --- ---------- --------------
   
7. /data/cams/control01.ctl NO 16384 692
   
8. /data/cams/control02.ctl NO 16384 692

此处发现两个控制文件在一个路径下，显然不安全，现在对控制文件做冗余

查看spfile信息：

1. SQL> show parameter pfile;
   
2. 
   
3. NAME TYPE VALUE
   
4. ------------------------------------ ----------- ------------------------------
   
5. spfile string /oradata/oracle/product/11.2.0
   
6. /db_1/dbs/spfilecams.ora

关闭数据库，创建pfile文件

1. SQL> create pfile from spfile;
   
2. SQL> !ls /oradata/oracle/product/11.2.0/db_1/dbs
   
3. hc_cams.dat initcams.ora init.ora lkCAMS orapwcams snapcf_cams.f spfilecams.ora
   
4. SQL> !vi /oradata/oracle/product/11.2.0/db_1/dbs/initcams.ora
   
5. 
   
6. 修改*.control_files='/data/cams/control01.ctl','/data/cams/control02.ctl'内容为
   
7. *.control_files='/data/cams/control01.ctl','/file/cams/controlfile/control02.ctl','/backup/cams/controlfile/control03.ctl'

创建路径

1. mkdir -p /file/cams/controlfile
   
2. mkdir -p /backup/cams/controlfile

拷贝现有控制文件至存储路径中

1. SQL> !ls /file/cams/controlfile
   
2. control02.ctl
   
3. 
   
4. SQL> !ls /backup/cams/controlfile
   
5. control03.ctl

通过pfile启动oracle,并新创建spfile

1. SQL> startup pfile='/oradata/oracle/product/11.2.0/db_1/dbs/initcams.ora';
   
2. SQL> create spfile from pfile;
   
3. SQL> shutdown immediate;
   
4. SQL> startup;