SQL> show parameter control_files
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
control_files string
/u01/oracle/oradata/orcl/contr
ol01.ctl, /u01/oracle/oradata/
orcl/control02.ctl
SQL> alter system set control_files = '/u01/oracle/oradata/orcl/control01.ctl','/u01/oracle/oradata/orcl/control02.ctl','/u01/oracle/oradata/orcl/control03.ctl'scope = spfile;
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 956304728 bytes
Database Buffers 687865856 bytes
Redo Buffers 7118848 bytes
ORA-00214: control file '/u01/oracle/oradata/orcl/control01.ctl' version 1314
inconsistent with file '/u01/oracle/oradata/orcl/control03.ctl' version 1294
SQL> show parameter control_files
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
control_files string
/u01/oracle/oradata/orcl/contr
ol01.ctl, /u01/oracle/oradata/
orcl/control02.ctl, /u01/oracl
e/oradata/orcl/control03.ctl
阅读(823) | 评论(0) | 转发(0) |
