step1: 查看当前控制文件的参数
SQL> select status,name,block_size,FILE_SIZE_BLKS,IS_RECOVERY_DEST_FILE from v$controlfile;
STATUS NAME BLOCK_SIZE FILE_SIZE_BLKS IS_
-------- -------------------------------------------------- ---------- -------------- ---
/u01/app/oracle/oradata/ANDREA/control01.ctl 16384 594 NO
/u01/app/oracle/fast_recovery_area/ANDREA/control02.ctl 16384 594 NO
step2: 修改parameter control_files
alter system set control_files=(/u01/app/oracle/oradata/ANDREA/control01.ctl,
/u01/app/oracle/oradata/ANDREA/control03.ctl,
/u01/app/oracle/fast_recovery_area/ANDREA/control02.ctl)
scope=spfile;
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
---注意参数格式
alter system set control_files='/u01/app/oracle/oradata/ANDREA/control01.ctl',
'/u01/app/oracle/oradata/ANDREA/control03.ctl',
'/u01/app/oracle/fast_recovery_area/ANDREA/control02.ctl'
scope=spfile;
step3: shutdown instance
step4: cp '/u01/app/oracle/oradata/ANDREA/control03.ctl '/u01/app/oracle/oradata/ANDREA/control01.ctl
step5: startup instance
然后 查看alert_*.log日志内容。
Using parameter settings in server-side spfile /u01/app/oracle/11gR2/dbhome/dbs/spfileANDREA.ora
System parameters with non-default values:
processes = 150
sga_max_size = 452M
memory_target = 528M
memory_max_target = 540M
control_files = "/u01/app/oracle/oradata/ANDREA/control01.ctl"
control_files = "/u01/app/oracle/oradata/ANDREA/control03.ctl"
control_files = "/u01/app/oracle/fast_recovery_area/ANDREA/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.4.0"
log_archive_format = "%t_%s_%r.dbf"
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21754115/viewspace-776670/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21754115/viewspace-776670/