Current position:  Home > Default > Error While Control File Creation

Error While Control File Creation

Time:October 11
Advertisement
Hi Experts,
i'm trying to create control file but i'm getting following error.
SQL> CREATE CONTROLFILE
  2     SET DATABASE venk
  3     LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\venk\redo01_01.log',
  4                      'C:\oracle\product\10.2.0\oradata\venk\redo01_02.log'),
  5             GROUP 2 ('C:\oracle\product\10.2.0\oradata\venk\redo02_01.log',
  6                      'C:\oracle\product\10.2.0\oradata\venk\redo02_02.log'),
  7             GROUP 3 ('C:\oracle\product\10.2.0\oradata\venk\redo03_01.log',
  8                      'C:\oracle\product\10.2.0\oradata\venk\redo03_02.log')
  9     RESETLOGS
10     DATAFILE 'C:\oracle\product\10.2.0\oradata\venk\system01.dbf' SIZE 3M,
11              'C:\oracle\product\10.2.0\oradata\venk\rbs01.dbs' SIZE 5M,
12              'C:\oracle\product\10.2.0\oradata\venk\users01.dbs' SIZE 5M,
13              'C:\oracle\product\10.2.0\oradata\venkemp01.dbs' SIZE 5M
14     MAXLOGFILES 50
15     MAXLOGMEMBERS 3
16     MAXLOGHISTORY 400
17     MAXDATAFILES 200
18     MAXINSTANCES 6
19     ARCHIVELOG;
CREATE CONTROLFILE
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 384 (blocks), but should match header 60160
ORA-01110: data file 1: 'C:\oracle\product\10.2.0\oradata\venk\system01.dbf'
SQL>I'm search in google.
ORA-01163:
SIZE clause indicates string (blocks), but should match header string
Cause:      The size specified in bytes in the SIZE clause of the CREATE CONTROLFILE statement does not equate to the number of blocks recorded in the header.
Action:      Specify the correct filename and size ( in bytes ).But i don't know how to check the SIZE of header .. Pls Help
Advertisement
Thanks for your help.
@phaeus .. i really don't know enough or not ..i'm just learning in my own system.
@mseberg Now getting below error.
SQL> CREATE CONTROLFILE
  2     SET DATABASE venk
  3     LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\venk\redo01_01.log',
  4                      'C:\oracle\product\10.2.0\oradata\venk\redo01_02.log'),
  5             GROUP 2 ('C:\oracle\product\10.2.0\oradata\venk\redo02_01.log',
  6                      'C:\oracle\product\10.2.0\oradata\venk\redo02_02.log'),
  7             GROUP 3 ('C:\oracle\product\10.2.0\oradata\venk\redo03_01.log',
  8                      'C:\oracle\product\10.2.0\oradata\venk\redo03_02.log')
  9     RESETLOGS
10     DATAFILE 'C:\oracle\product\10.2.0\oradata\venk\system01.dbf',
11              'C:\oracle\product\10.2.0\oradata\venk\rbs01.dbs',
12              'C:\oracle\product\10.2.0\oradata\venk\users01.dbs',
13              'C:\oracle\product\10.2.0\oradata\venkemp01.dbs'
14     MAXLOGFILES 50
15     MAXLOGMEMBERS 3
16     MAXLOGHISTORY 400
17     MAXDATAFILES 200
18     MAXINSTANCES 6
19     ARCHIVELOG;
CREATE CONTROLFILE
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'C:\oracle\product\10.2.0\oradata\venk\rbs01.dbs'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL>@orafad     Thanks for your link :) .i'm referring this link
http://docs.oracle.com/cd/E11882_01/server.112/e25494/control003.htm
any way pls help to resolve this issue . So that in future if this kind of issue came i can solve my self.