登陆oracle，查看control file
- E:\My Documents\radix\Oracle\常用sql>sqlplus / as sysdba;
- SQL*Plus: Release 11.2.0.1.0 Production on 星期四 12月 13 16:25:39 2012
- Copyright (c) 1982, 2010, Oracle. All rights reserved.
- Connected to:
- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
- SQL> show parameter control_file;
- NAME TYPE VALUE
- ------------------------------------ ----------- ------------------------------
- control_file_record_keep_time integer 7
- control_files string D:\ORACLE\ORADATA\TEST\CONTROL
- 01.CTL, D:\ORACLE\FLASH_RECOVE
- RY_AREA\TEST\CONTROL02.CTL, D:
- \ORACLE\ORADATA\TEST\CONTROL02
- .CTL
- SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down.
删除在windows中D:\ORACLE\FLASH_RECOVERY_AREA\TEST\CONTROL02.CTL物理文件；在此启动数据库；
SQL> conn / as sysdba;
Connected to an idle instance. SQL> startup force; ORACLE instance started. Total System Global Area 1933430784 bytes Fixed Size 1378680 bytes Variable Size 452986504 bytes Database Buffers 1468006400 bytes Redo Buffers 11059200 bytes ORA-00205: error in identifying control file, check alert log for more info 系统报错。控制文件有问题； 检查alert log
- starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCO
- =TCP))'...
- Thu Dec 13 17:11:11 2012
- MMNL started with pid=16, OS id=4268
- starting up 1 shared server(s) ...
- ORACLE_BASE from environment = D:\oracle
- Thu Dec 13 17:11:12 2012
- ALTER DATABASE MOUNT
- ORA-00210: cannot open the specified control file
- ORA-00202: control file: 'D:\ORACLE\ORADATA\TEST\CONTROL02.CTL'
- ORA-27041: unable to open file
- OSD-04002: unable to open file
- O/S-Error: (OS 2) 系统找不到指定的文件。
- ORA-205 signalled during: ALTER DATABASE MOUNT...
可以通过复制D:\ORACLE\ORADATA\TEST\CONTROL01.CTL 为CONTROL02.CTL的方式修复； 或者修改control_file参数；
- SQL> shutdown immediate;
- ORA-01507: database not mounted
- ORACLE instance shut down.
- SQL> startup nomount;
- ORACLE instance started.
- Total System Global Area 1933430784 bytes
- Fixed Size 1378680 bytes
- Variable Size 452986504 bytes
- Database Buffers 1468006400 bytes
- Redo Buffers 11059200 bytes
- SQL> show parameter control_file;
- NAME TYPE
- ------------------------------------ ----------------------
- VALUE
- ------------------------------
- control_file_record_keep_time integer
- 7
- control_files string
- D:\ORACLE\ORADATA\TEST\CONTROL
- 01.CTL, D:\ORACLE\FLASH_RECOVE
- RY_AREA\TEST\CONTROL02.CTL, D:
- \ORACLE\ORADATA\TEST\CONTROL02
- .CTL
- SQL> alter system set control_files="D:\ORACLE\ORADATA\TEST\CONTROL01.CTL","D:\O
- RACLE\FLASH_RECOVERY_AREA\TEST\CONTROL02.CTL" scope=spfile;
- System altered.
- SQL> startup force;
- ORACLE instance started.
- Total System Global Area 1933430784 bytes
- Fixed Size 1378680 bytes
- Variable Size 452986504 bytes
- Database Buffers 1468006400 bytes
- Redo Buffers 11059200 bytes
- Database mounted.
- Database opened.
- SQL>
- SQL> show parameter control_files;
- NAME TYPE VALUE
- ------------------------------------ ----------- ------------------------------
- control_files string D:\ORACLE\ORADATA\TEST\CONTROL
- 01.CTL, D:\ORACLE\FLASH_RECOVE
- RY_AREA\TEST\CONTROL02.CTL
