一则controlfile丢失，或损坏的恢…

alert.log 中的报错信息

Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilemynewdb.ora
System parameters with non-default values:
<wbr> processes<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = 150<br><wbr> sga_target<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = 200M<br><wbr> control_files<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = "/u01/app/oracle/oradata/MYNEWDB/controlfile/o1_mf_814joods_.ctl"<br><wbr> db_block_size<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = 8192<br><wbr> compatible<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = "11.2.0.0.0"<br><wbr> db_create_file_dest<wbr><wbr><wbr><wbr><wbr> = "/u01/app/oracle/oradata"<br><wbr> db_recovery_file_dest_size= 6442450<br><wbr> undo_tablespace<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = "UNDOTBS1"<br><wbr> recyclebin<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = "OFF"<br><wbr> remote_login_passwordfile= "EXCLUSIVE"<br><wbr> db_domain<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = ""<br><wbr> dispatchers<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = "(PROTOCOL=TCP) (SERVICE=mynewdbXDB)"<br><wbr> audit_file_dest<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = "/u01/app/oracle/admin/mynewdb/adump"<br><wbr> audit_trail<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = "DB"<br><wbr> db_name<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = "mynewdb"<br><wbr> open_cursors<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = 300<br><wbr> pga_aggregate_target<wbr><wbr><wbr><wbr> = 74M<br><wbr> diagnostic_dest<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> = "/u01/app/oracle"<br> Sat Sep 29 03:59:18 2012<br> PMON started with pid=2, OS id=20446<br> Sat Sep 29 03:59:18 2012<br> VKTM started with pid=3, OS id=20448<br> VKTM running at (100ms) precision<br> Sat Sep 29 03:59:18 2012<br> GEN0 started with pid=4, OS id=20452<br> Sat Sep 29 03:59:18 2012<br> DIAG started with pid=5, OS id=20454<br> Sat Sep 29 03:59:18 2012<br> DBRM started with pid=6, OS id=20456<br> Sat Sep 29 03:59:18 2012<br> PSP0 started with pid=7, OS id=20458<br> Sat Sep 29 03:59:18 2012<br> DIA0 started with pid=8, OS id=20460<br> Sat Sep 29 03:59:18 2012<br> MMAN started with pid=9, OS id=20462<br> Sat Sep 29 03:59:18 2012<br> DBW0 started with pid=10, OS id=20464<br> Sat Sep 29 03:59:18 2012<br> LGWR started with pid=11, OS id=20466<br> Sat Sep 29 03:59:18 2012<br> CKPT started with pid=12, OS id=20468<br> Sat Sep 29 03:59:18 2012<br> SMON started with pid=13, OS id=20470<br> Sat Sep 29 03:59:18 2012<br> RECO started with pid=14, OS id=20472<br> Sat Sep 29 03:59:18 2012<br> MMON started with pid=15, OS id=20474<br> starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...<br> Sat Sep 29 03:59:18 2012<br> MMNL started with pid=16, OS id=20476<br> starting up 1 shared server(s) ...<br> ORACLE_BASE from environment = /u01/app/oracle<br> Sat Sep 29 03:59:18 2012<br> ALTER DATABASE<wbr><wbr> MOUNT<br> ORA-00210: cannot open the specified control file<br> ORA-00202: control file: '/u01/app/oracle/oradata/MYNEWDB/controlfile/o1_mf_814joods_.ctl'<br> ORA-27037: unable to obtain file status<br> Linux Error: 2: No such file or directory<br> Additional information: 3<br> ORA-205 signalled during: ALTER DATABASE<wbr><wbr> MOUNT...<br> Sat Sep 29 04:00:23 2012<br> Starting ORACLE instance (normal)<br><br><br><br> 查看原来controlfile的位置<br> SQL&gt; show parameter control_file<br><br> NAME<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> TYPE<wbr><wbr><wbr><wbr><wbr><wbr><wbr> VALUE<br> ------------------------------------ ----------- ------------------------------<br> control_file_record_keep_time<wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>