Skip to Content
author's profile photo Former Member
Former Member

ORA-

I all,

We have installed SAP R/3 4.7 on windows 2000 Oracle 9.2.0.1, now we have created an Dev system with SAP R/3 4.7 SR2 on Windows 2000 Oracle 9.2.0.8 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?

Thanks,

Best Regards,

Pedro Rodrigues

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2007 at 12:54 PM

    Hi Pedro,

    This means one or more files needs recovery.

    Please run following command

    Recover database using backup controlfile until cancel;

    And see what all files need media recovery.

    Regards,

    Payal Patel

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Eric Brunelle

      HI Eric,

      I used it like you've said, problem still occurs! I've been used it like this.

      now we search and found this in Source database

      select * from v$log

      GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS----


      -


      -


      -


      -


      - -


      FIRST_CHANGE# FIRST_TIM--


      -


      11 1 72340 20971520 2 NO CURRENT

      695668730 07-SEP-07

      12 1 72338 20971520 2 YES INACTIVE

      695662389 07-SEP-07

      13 1 72339 20971520 2 YES ACTIVE

      695665275 07-SEP-07

      GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

      -


      -


      -


      -


      -


      --- -


      FIRST_CHANGE# FIRST_TIM

      -


      -


      14 1 72337 20971520 2 YES INACTIVE

      695659689 07-SEP-07

      has you can see, it has thread #1 in results, do you think this is relevant?

      Thanks

      Pedro

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2007 at 11:43 AM

    We could solve it, the problem is that we have been to ambisious, we just restore an database with the same SID as the productive and then execute the steps to change the System ID as we were trying. What we did wrong is to change the SID just after the restore in spite of restore the original system and only after this change his SID.

    Thanks all for your precious help.

    Best regards,

    Pedro

    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.