数据库从9i升级到11g的时候,一个控制文件路径放错了,需要开个change纠正过来,在虚拟机上进行相关测试:
step1: 查看当前控制文件的参数
SQL> select
status,name,block_size,FILE_SIZE_BLKS,IS_RECOVERY_DEST_FILE fromv$controlfile;
STATUSNAMEBLOCK_SIZE FILE_SIZE_BLKS IS_
-------- -------------------------------------------------- ----------
-------------- ---
/u01/app/oracle/oradata/ANDREA/control01.ctl16384594 NO
/u01/app/oracle/fast_recovery_area/ANDREA/control02.ctl16384594 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"