ORA-00205: error in identifying control file while startup database

[#1]

Dear Experts,

we are using Oracle 10g on RHEL5.4 64Bit ecc 6.0 with eph 4 i have moved all my sap data files along with Temp file.

when i startup my database getting error.

SQL> startup mount

ORACLE instance started.

Total System Global Area 535662592 bytes

Fixed Size 1334380 bytes

Variable Size 306185108 bytes

Database Buffers 222298112 bytes

Redo Buffers 5844992 bytes

ORA-00205: error in identifying control file, check alert log for more info

when i checked initSID.ora then found old location of control file.

1)/oracle/SID/sapdata1/cntrl

2)/oracle/SID/origlogA/cntrl

3)/oracle/SID/origlogB/cntrl

i have manually changed location of control file.

1)/oracle/SID/sapdata10/cntrl

2)/oracle/SID/origlogA/cntrl

3)/oracle/SID/origlogB/cntrl

SQL> Create Pfile from Spfile;

File Created.

i would like to mount my database from Pfile plese help me i execute scripts below.

SQL> STARTUP MOUNT=/oracle/SID/ORACLE_HOME/dbs/initSID.ora

invalid startup option.

or suggest me some other way so that i can startup my Database.

with Regards

[Former Member]

Thanks,LOG of alert_SID.log control_files = /oracle/PRD/origlogA/cntrl/cntrlPRD.dbf, /oracle/PRD/origlogB/cntrl/cntrlPRD.dbf, /oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf, control_file_record_keep_time= 30, Mon Nov 14 08:24:52 2011

CREATE DATABASE PRD CONTROLFILE REUSE MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 254 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE '/oracle/PRD/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE '/oracle/PRD/sapdata1/temp_1/temp.data1' SIZE 570M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PRD/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M SYSAUX DATAFILE '/oracle/PRD/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

LOGFILE GROUP 1 ('/oracle/PRD/origlogA/log_g11m1.dbf',

'/oracle/PRD/mirrlogA/log_g11m2.dbf') SIZE 50M REUSE ,GROUP 2 ('/oracle/PRD/origlogB/log_g12m1.dbf',

'/oracle/PRD/mirrlogB/log_g12m2.dbf') SIZE 50M REUSE ,GROUP 3 ('/oracle/PRD/origlogA/log_g13m1.dbf',

'/oracle/PRD/mirrlogA/log_g13m2.dbf') SIZE 50M REUSE ,GROUP 4 ('/oracle/PRD/origlogB/log_g14m1.dbf',

'/oracle/PRD/mirrlogB/log_g14m2.dbf') SIZE 50M REUSEMon Nov 14 08:24:53 2011Database mounted in Exclusive Mode

Mon Nov 14 08:25:06 2011Successful mount of redo thread 1, with mount id 1830841300

Assigning activation ID 1830841300 (0x6d206bd4) Thread 1 opened at log sequence 1

Current log# 1 seq# 1 mem# 0: /oracle/PRD/origlogA/log_g11m1.dbf

Current log# 1 seq# 1 mem# 1: /oracle/PRD/mirrlogA/log_g11m2.dbf,m Successful open of redo thread 1

Mon Nov 14 08:25:06 2011 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Mon Nov 14 08:25:06 2011 SMON: enabling cache recovery

Mon Nov 14 08:25:06 2011

create tablespace SYSTEM datafile '/oracle/PRD/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

EXTENT MANAGEMENT LOCAL online

Mon Nov 14 08:25:09 2011

Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.3.0]

Mon Nov 14 08:25:15 2011

Completed: create tablespace SYSTEM datafile '/oracle/PRD/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

EXTENT MANAGEMENT LOCAL online

Mon Nov 14 08:25:15 2011

create rollback segment SYSTEM tablespace SYSTEM

storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM

storage (initial 50K next 50K)

Mon Nov 14 08:25:19 2011

CREATE UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PRD/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

Mon Nov 14 08:25:36 2011

Successfully onlined Undo Tablespace 1.

Completed: CREATE UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PRD/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

Mon Nov 14 08:25:36 2011

create tablespace SYSAUX datafile '/oracle/PRD/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online

Completed: create tablespace SYSAUX datafile '/oracle/PRD/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online