oracle控制文件设置多个,oracle controlfile Multipath 控制文件多路径标点符号

今天 在配置多controlfile 多路径时，出了点小问题，结果发现是标点符号引起的

–by anbob.com

操作如下

SQL> show parameter spfile

NAME                                 TYPE        VALUE

———————————— ———– ——————————

spfile                               string      D:\ORACLE\PRODUCT\10.1.0\DB_1\

DATABASE\SPFILEORCL.ORA

SQL> show controlfile

SP2-0735: unknown SHOW option beginning “controlfil…”

SQL> show parameter control

NAME                                 TYPE        VALUE

———————————— ———– ——————————

control_file_record_keep_time        integer     7

control_files                        string      D:\ORACLE\PRODUCT\10.1.0\ORADA

TA\ORCL\CONTROL01.CTL

SQL> alter system set control_files=’D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL’ scope=

spfile;

System altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

C:\>copy D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL

已复制         1 个文件。

C:\>copy D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL

已复制         1 个文件。

C:\>

SQL> startup

ORACLE instance started.

Total System Global Area  201326592 bytes

Fixed Size                   788128 bytes

Variable Size             145488224 bytes

Database Buffers           54525952 bytes

Redo Buffers                 524288 bytes

ORA-00205: error in identifying controlfile, check alert log for more info

SQL> alter system set control_files=(‘D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL’) scop

e=spfile;

alter system set control_files=(‘D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL’) scope=spf

ile

*

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set control_files='(D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL)’ scop

e=spfile;

System altered.

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  201326592 bytes

Fixed Size                   788128 bytes

Variable Size             145488224 bytes

Database Buffers           54525952 bytes

Redo Buffers                 524288 bytes

ORA-00205: error in identifying controlfile, check alert log for more info

SQL> alter system set control_files=”D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL

spfile;

alter system set control_files=”D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CT

e

*

ERROR at line 1:

ORA-00972: identifier is too long

SQL> alter system set control_files=”D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL”,”D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL”,”D:\oracle\product\10.1.0\oradata\orcl\CON

ope=spfile;

System altered.

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  201326592 bytes

Fixed Size                   788128 bytes

Variable Size             145488224 bytes

Database Buffers           54525952 bytes

Redo Buffers                 524288 bytes

Database mounted.

Database opened.

SQL>

打赏

微信扫一扫，打赏作者吧～