on 11-17-2015 12:13 PM
Dear Collegues,
I try to prepare SAP system copy by SWPM (ERP 6.06, Oracle 11.2.0.3, Linux SuSE) and I have a problem. Oracle backup on the source system has been prepared and restored on the target system via BRTOOLS (brrestore -m full -b beridydy.afd). New directories also was done SAPDATA.. SAPTRACE etc . with proper rights :
chmod 775 sapdata…
chown oraSID:dba sapdata…
And after restore if I try to continue SWPM task I see the error during the task – Oracle Backup/Restore database – finished
DIAGNOSTIC: Error message:ORA-00205 error in identifying control file, check alert log for more info.
If I open ora_sql_results.log I see:
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 1386356736 bytes
Fixed Size 2228224 bytes
Variable Size 704643072 bytes
Database Buffers 671088640 bytes
Redo Buffers 8396800 bytes
ORA-00205: error in identifying control file, check alert log for more info
I didn’t do anything from Oracle side except restore DB via BRTOOLS and creating directories. Shall I do something else before this step on the Oracle side ? What else should be done ?
Thank you.
Regards,
Tomasz
Hi,
Thanks, I found below info :
<txt>ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oracle/SID/112_64/dbs/cntrlSID.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
</txt>
In fact into this directory I see only the following files- Init.ora, initSID.1.ora, initSID.ora, initSID.sap, lkSID
I didn’t create CONTROL file into the target server and additionally currently I don’t have an access to the source system, only access to the target server. Some ideas?
Regards,
Tomasz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Tomasz,
You need to generate the control file structure for the target database.
Please check following guide for Oracle specific steps (Pg 49, 52).
https://websmp209.sap-ag.de/~sapidb/011000358700001323962012E
Thanks.
Best Regards,
Anita
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.