dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: DATABASE IS NOT OPENING

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    HI

    FRIENDS I WANT YOUR HELP VERY URGENTLY

    I M GETTING THIS ERROR
    ORA-01588: must use RESETLOGS option for database open

    I HAVE TRIED TO OPEN DATABASE FROM THIS COMMAND ALSO

    ALTER DATABASE OPEN RESETLOGS;

    BUT IT IS GIVING AN ERROR
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'D:\ORACLE\ORADATA\HUNGAMA\SYSTEM01.DBF'

    WELL I WANTED TO KNOW WHAT HAPPEND IF I WRITE RESERLOG OR NORESETLOG AT THE LAST OF THE ABOVE STATEMENT.

    ALSO HOW TO START THE DATABSE?

    THANKS

    [Edited by shailendra on 07-30-2002 at 05:20 AM]

  2. #2
    Join Date
    Jul 2002
    Posts
    132
    Can u let me know when u r trying to open the database? Was there any problem or any failure that u had to shutdown ur database?
    U need a recovery of ur system datafile. Do u have backups and archivelogs of ur database?

  3. #3
    Join Date
    Sep 2000
    Posts
    305
    BY MISTAKE I REMOVED THE ARCHIVE FILES

    NOW IS THERE ANY WAY TO RECOVER IT BACK?

    SHAILENDRA

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Hi Shailendra,

    1. RESETLOGS will reset the log sequence and the old Archvied Logs can not be used for recovery. NORESETLOGS will open the database as normal and existing log sequnce will continue.

    2. Your system tablespace file is not consistent yet and more logs need to be applied.

    HTH
    Sanjay

    PS: Why all CAPS message?




  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Have you tried

    RECOVER DATABASE UNTIL CANCEL;

    ??

    Sanjay

  6. #6
    Join Date
    Sep 2000
    Posts
    305
    YA SANJAY FIRST OF ALL VERY VERY THANKS
    SANJAY I HAVE TRIED THAT ALSO BUT I M GETTING THIS MESSAGE

    ORA-00283: recovery session canceled due to errors
    ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


  7. #7
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    Have you recovered your database using a backup taken after the database was not shutdown cleanly

    ie Did you take a backup after a system crash or a shutdown abort and are you using this backup to recover the database?

    The problem is that the file system01.dbf requires further recovery.

    Have you got a clean backup? do you backup your archive logs as well?
    I think your best option is to go back to the last clean backup and apply the available archive logs.

    If you don't have the Archive logs you can only recover to the last backup....NEVER delete archive logs until you have either backed them up or have just taken a successfull backup (Then only delete those prior to the backup starting)

    Regards
    Moff.

  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What kind of backup you have with you?
    What are the operations have you performed after db crash?

    Sanjay

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