首页 » ORACLE 9i-23c » oracle controlfile Multipath 控制文件多路径标点符号

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 parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      D:\ORACLE\PRODUCT\10.1.0\ORADATA\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)' scope=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\CONTROL03.CTL SCOPE=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=SPFILE*
ERROR at line 1:
ORA-00972: identifier is too long

格式为control_files=”a”,”b”,”c”

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
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>

打赏

目前这篇文章有1条评论(Rss)评论关闭。

  1. Refugio Pirillo | #1
    2011-12-21 at 05:46

    family lawyers paramatta: