Skip to Content
0
Former Member
Aug 24, 2011 at 12:29 PM

R3trans finished 0012 / cannot recover data file 1 file is in use or recove

400 Views

Hi

After a system Cloning from PRD to SandBox, SAP doesn't start any more :

/usr/sap/SID/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

On the other hand, I can start the database manually, but SAP still doesn't connect to the DB.

The R3trans -d returns the following :

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SID/SYS/exe/run') or dbms_type ('ORA')"

R3trans finished (0012).

DIR_LIBRARY is correctly set.

I tought may be the databse is inconsistent, so I tried to recover the it.

The recover command doesn't work too :

ORA-00283: recovery session canceled due to errors

ORA-01124: cannot recover data file 1 - file is in use or recovery

ORA-01110: data file 1: '/oracle/SID/sapdata1/system_1/system.data1'

I shall be very grateful to you for any help !

Regards