cancel
Showing results for 
Search instead for 
Did you mean: 

SAP SWPM system copy - Oracle error.

former_member312761
Participant
0 Kudos

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

View Entire Topic
former_member312761
Participant
0 Kudos

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

Former Member
0 Kudos

Hello Tomasz,

What is the version for DB in source?

Thanks.

Best Regards,

Anita

former_member312761
Participant
0 Kudos

hi Anita,

The same on the source and target system - ORACLE 11.2.0.3.0 based on the Linux SUSE x86_64

Regards,

Tomasz

Former Member
0 Kudos

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