Oracle Study之案例--在RAW上controlfile多元化
SQL> show parameter spfile;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/oradata/prod/s
pfile01
SQL> alter system set control_files=
2'/u01/app/oracle/oradata/prod/control01.ctl','/u01/app/oracle/oradata/prod/control02.ctl','/u01/app/oracle/oradata/prod/control03.ctl' scope=spfile;
System altered.
SQL> startup force nomount;
ORACLE instance started.
Total System Global Area977272832 bytes
Fixed Size 2025592 bytes
Variable Size 255854472 bytes
Database Buffers 713031680 bytes
Redo Buffers 6361088 bytes
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /u01/app/oracle/oradata/prod/c
ontrol01.ctl, /u01/app/oracle/
oradata/prod/control02.ctl, /u
01/app/oracle/oradata/prod/con
trol03.ctl
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
查看告警日志，无法识别control03.ctl文件！
页:
[1]