Skip to Content

SAP SWPM system copy - Oracle error.

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Nov 18, 2015 at 08:10 AM

    Hi,

    Rights to the directory have been changed (777) and still the same error. Regarding to the CONTROL file, as I mentioned before, this kind of file hasn’t been generated on the source server and currently I don’t have access to this server.

    I have access only to the new server and backup directory, for example into the /oracle/SID/sapbackup/backup_name I found file cntrlOLD_SID.dbf, maybe I can use this file in this case ? But how and what additionally should be done ?

    Regards,

    Tomasz

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 17, 2015 at 12:31 PM

    Hello Tomasz,

    Kindly check alert log file for error details. You can find it in below location:

    <SAPDATA_HOME>/saptrace/diag/rdbms/<dbname>/<DBSID>/trace/alert_<DBSID>.log

    Thanks.

    Best Regards,

    Anita

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 17, 2015 at 12:48 PM

    Hi,

    Thanks, I found below info :

    <txt>ORA-00210: cannot open the specified control file

    ORA-00202: control file: &apos;/oracle/SID/112_64/dbs/cntrlSID.dbf&apos;

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 18, 2015 at 06:31 AM

    Hi,

    ORA-00202: control file: &apos;/oracle/SID/112_64/dbs/cntrlSID.dbf&apos;

    Could you check permissions on the directory ? Try to assign it with 777 & check again .

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.