alter system set control_files=…………..

  • Post author:
  • Post category:其他


改control_files这个参数的时候,需要注意格式,稍有不慎就会改错。

正确格式如下:

SQL>

alter system set control_files=’E:\app\oracle\controlfile\control01.ctl’,’E:\app\oracle\controlfile\control02.ctl’,’E:\app\oracle\contr


olfile\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/