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
Request clarification before answering.
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.
You should not move any files manually because control file has location of all files. If you move it manually then control file will not recognize it. This process is not supported.
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.