模拟增加控制文件

今天分别在自己windows XP上的oracle数据库和虚拟机redhat上的oracle数据库上模拟增加控制文件，同样的方法，windows xp平台有报错，redhat平台没有，很奇怪，具体原因不明！

windows xp下：

SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup nomount
ORACLE 例程已经启动。

Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             255855492 bytes
Database Buffers          348127232 bytes
Redo Buffers                7135232 bytes
SQL> alter system set control_files=' C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONT
ROL01.CTL','C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL','D:\ORCL\CONTRO
L04.CTL' scope=spfile;

系统已更改。

SQL> shutdown immediate
ORA-01507: ??????

ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             255855492 bytes
Database Buffers          348127232 bytes
Redo Buffers                7135232 bytes
ORA-00205: ?????????, ??????, ???????
SQL> startup mount
ORACLE 例程已经启动。

Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             171969412 bytes
Database Buffers          432013312 bytes
Redo Buffers                7135232 bytes
ORA-00205: ?????????, ??????, ???????

 

查看日志：

Wed Jan 26 20:55:55 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=3364
Wed Jan 26 20:55:55 2011
starting up 1 shared server(s) ...
Wed Jan 26 20:55:55 2011
ALTER DATABASE   MOUNT
Wed Jan 26 20:55:56 2011
ORA-00202: control file: 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\ C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL'
ORA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 123) 文件名、目录名或卷标语法不正确。

Wed Jan 26 20:55:56 2011
ORA-205 signalled during: ALTER DATABASE   MOUNT...

redhat平台：

SQL> startup nomount
ORACLE instance started.

Total System Global Area  629145600 bytes
Fixed Size                  1220964 bytes
Variable Size             343936668 bytes
Database Buffers          281018368 bytes
Redo Buffers                2969600 bytes

SQL> alter system set control_files='/u01/oradata/oracle/control01.ctl',
  2  '/u01/oradata/oracle/control02.ctl',
  3  '/u01/oradata/oracle/control03.ctl',
  4  '/u01/oradata/oracle/control04.ctl'
  5  scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@oracle oracle]$ ls
control01.ctl  control03.ctl  redo02_b.log  redo03.log    redo0402.log  redo04.log    system01.dbf  undotbs01.dbf
control02.ctl  redo01.log     redo02.log    redo0401.log  redo0403.log  sysaux01.dbf  temp01.dbf    users01.dbf
[oracle@oracle oracle]$ cp control03.ctl control04.ctl
[oracle@oracle oracle]$ ls
control01.ctl  control03.ctl  redo01.log    redo02.log  redo0401.log  redo0403.log  sysaux01.dbf  temp01.dbf     users01.dbf
control02.ctl  control04.ctl  redo02_b.log  redo03.log  redo0402.log  redo04.log    system01.dbf  undotbs01.dbf
[oracle@oracle oracle]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 26 22:07:35 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  629145600 bytes
Fixed Size                  1220964 bytes
Variable Size             343936668 bytes
Database Buffers          281018368 bytes
Redo Buffers                2969600 bytes
Database mounted.
Database opened.
SQL> show parameter control  

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      /u01/oradata/oracle/control01.
                                                 ctl, /u01/oradata/oracle/contr
                                                 ol02.ctl, /u01/oradata/oracle/
                                                 control03.ctl, /u01/oradata/or
                                                 acle/control04.ctl

 

这种现象很奇怪，原因待续

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

转载于:http://blog.itpub.net/22821701/viewspace-686351/