alter system set control_files=..............

改control_files这个参数的时候，需要注意格式，稍有不慎就会改错。
正确格式如下：

SQL> alter system set control_files='E:\app\oracle\controlfile\control01.ctl','E:\app\oracle\controlfile\control02.ctl','E:\app\oracle\controlfile\control03.ctl' scope=spfile;
等号后面没有引号，每个路径用单引号扩住。

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             159386500 bytes
Database Buffers          444596224 bytes
Redo Buffers                7135232 bytes
Database mounted.
SQL> show parameter control

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
control_file_record_keep_time        integer                           7
control_files                       string                      E:\APP\ORACLE\CONTROLFILE\CONTROL01.CTL,E:\APP\ORACLE\CONTROLFILE\CONTROL02.CTL,E:\APP\ORACLE\CONTROLFILE\CONTROL03.CTL
SQL>

 

############################################################################################
如下是错误格式：
不能使用双引号。

SQL> alter system set control_files="E:\app\oracle\controlfile\control01.ctl,E:\app\oracle\controlfile\control02.ctl,E:\app\oracle\controlfile\control03.ctl" scope=spfile;

System altered.

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-1804547/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1804547/