Skip to Content
Former Member
Sep 03, 2007 at 12:03 PM



I all,

We have installed SAP R/3 4.7 on windows 2000 Oracle, now we have created an Dev system with SAP R/3 4.7 SR2 on Windows 2000 Oracle and now we wish to "attach" the Production database to the Development system.

We have tried this steps:

1. copy datafiles form PRD to DEV

2. execute on PRD "alter database backup controlfile to trace";

3 adapt the trace file to run it on DEV system "@path_to_script\trace.sql"

4. new control files were created

5. while executing "alter database open resetlogs" it gave us 2 errors :

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'D:\ORACLE\SID\system_01\SYSTEM01.DBF'

could the facto of the diferent oracle patchs installed affect this ? this datafiles is working fine in PRD system.

Witch other processes could we have to have two identical databases?


Best Regards,

Pedro Rodrigues