Database 10.1.0.2.0
OS Windows
Archive log : Disable.
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
ORA-00205: error in identifying controlfile, check alert log for more info
alert_db01.log file contents
Wed Mar 28 20:01:02 2007
ORA-00202: controlfile: 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB01\CONTROL01.CTL'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
My all control files deleted.
SQL> ED
Wrote file afiedt.buf
1 CREATE CONTROLFILE REUSE DATABASE "db01" NORESETLOGS NOARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 7271
7 LOGFILE
8 GROUP 1 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\REDO01.LOG' SIZE 10M,
9 GROUP 2 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\REDO02.LOG' SIZE 10M,
10 GROUP 3 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\REDO03.LOG' SIZE 10M
11 -- STANDBY LOGFILE
12 DATAFILE
13 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\SYSTEM01.DBF' SIZE 600M,
14 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\UNDOTBS01.DBF' SIZE 65M,
15 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\SYSAUX01.DBF' SIZE 330M,
16 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\USERS01.DBF' SIZE 185600K,
17 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\db01\EXAMPLE01.DBF' SIZE 150M
18* CHARACTER SET WE8MSWIN1252
SQL> /
Control file created.
SQL> alter database open;
Database altered.
Note : You must use SIZE clause with DATAFILE size specification.
No comments:
Post a Comment