ORA-01194 File 1 needs more recovery to be consistent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-01194 File 1 needs more recovery to be consistent

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    ORA-01194 File 1 needs more recovery to be consistent

    I'm getting ORA-01194 File 1 needs more revovery to be consistent error message when I try to open database with resetlogs.

    I copied all the PROD servers' *.dbf files to TEST server. I recreated the control file using CREATE CONTROLFILE REUSE SET DATABASE 'TEST' RESETLOGS NOARCHIVELOG and recreating controlfiles were sucessful..but cannot open the database when I issue ALTER DATABASE OPEN RESETLOGS; ...getting ORA-01194 error. ANy ideas?

    Thank you for your help

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Question1: did you copy your dbf after you shutdown the database?

    1.Put test in archive log mode and dont forget about the arch log destination:

    2. copy your redo logs from PROD server to your test databse's arch log mountpoint

    3.then at svrmgr"
    "recover database using backup controlfile until cancel:

    when it prompts you for the arch give the current redo.
    then type "cancel"

    that should fix the problem
    then alter database open resetlogs

    if you get same error apply more redos.
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Your datafiles are in an inconsistant state. You need to apply sufficient archived redo before you can open with resetlogs.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width