DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 26

Thread: needs more recovery to be consistent

  1. #1
    Join Date
    Apr 2001
    Posts
    126

    Post needs more recovery to be consistent

    when i start the db is does not open and asks me to issue 'alter database open resetlog', and i get the following error..

    what is the solution?


    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DB\SYSTEM01.DBF'

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    'D:\ORACLE\ORADATA\DB\SYSTEM01.DBF' is probably older than the rest of the files in your database. It must be brought current with a RECOVER DATABASE command.
    Jeff Hunter

  3. #3
    Join Date
    Apr 2001
    Posts
    126
    could u pls explain me clearly.. my DB is not in archieve log and not having log backup. how do i solve this problem.

  4. #4
    Join Date
    Apr 2001
    Posts
    126

    Unhappy

    when i try to open the database it give me diff DATAFILE name.

    how do i open the database.

  5. #5
    Join Date
    Sep 2002
    Posts
    12
    How did you close the database last time.
    On which OS are you?

    Corrado
    Corrado Mascioli

  6. #6
    Join Date
    Apr 2001
    Posts
    126
    win2k.. i closed using shutdown abort.

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    If you have closed this using shutdown abort the just mount the database and give recover database command why are you trying to open with resetlogs option.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    As Jeff suggest use:

    recover database;

    Cheers

  9. #9
    Join Date
    Apr 2001
    Posts
    126
    SVRMGR> connect internal
    Password:
    Connected.
    SVRMGR> startup
    ORACLE instance started.
    Total System Global Area 705525004 bytes
    Fixed Size 70924 bytes
    Variable Size 186044416 bytes
    Database Buffers 519331840 bytes
    Redo Buffers 77824 bytes
    Database mounted.
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
    SVRMGR> alter database open;
    alter database open
    *
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
    SVRMGR> alter database open resetlogs;
    alter database open resetlogs
    *
    ORA-01248: file 7 was created in the future of incomplete recovery
    ORA-01110: data file 7: 'D:\ORACLE\ORADATA\DB\DATA01.DBF'

  10. #10
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    What is the message when you give recover database command.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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