Answer:
If you know all your datafiles, you can create your control file.
1. Start DB in nomount.
2. Create control file.
3. Alter database open.
or
Copy another control file into the corrupted one and startup the database.
or
Try this on your test environment first.
Database 10gr1.
NoArchiveLog Mode
OS Windows
SQL> create tablespace test
2 datafile 'c:\test01.dbf' size 1m;
create tablespace test
*
ERROR at line 1:
ORA-00227: corrupt block detected in controlfile: (block
1, # blocks 1)
ORA-00202: controlfile: 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB01\CONTROL01.CTL'
SQL> shutdown abort;
ORACLE instance shut down.
SQL> --First Delete control01.ctl file and create new
copy through control02.ctl
SQL> host del c:\oracle\product\10.1.0\oradata\db01\control01.ctl
ystem32\cmd.exe /c clsSQL> disconn
Disconnected from Oracle Database 10g Enterprise Edition
Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> exit
C:\oracle\product\10.1.0\Db_1\BIN>sqlplus/nolog
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Mar 28 19:21:42 2010
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.
SQL> show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string C:\ORACLE\PRODUCT\10.1.0\ORADA
TA\DB01\CONTROL01.CTL, C:\ORAC
LE\PRODUCT\10.1.0\ORADATA\DB01
\CONTROL02.CTL, C:\ORACLE\PROD
UCT\10.1.0\ORADATA\DB01\CONTRO
L03.CTL
