1 2 3 Previous Next 39 Replies Latest reply on Sep 10, 2008 3:25 PM by 26741

    How to recover the database when some of the archive log file get deleted.

    534533
      I am facing a problem with Oracle database, which is related to archivelogs.
      Our development database is running in archivelog mode, but we don't have backups scheduled and have no recovery catalog.
      When the database was in running condition, disk got full, so some archivelogs were deleted manually.
      After this they restarted the DB, and now DB is not coming up. Errors are as follows:

      -------------------------------------------------------------------------------------------------------------


      SQL> startup
      ORACLE instance started.

      Total System Global Area 1444383504 bytes
      Fixed Size 731920 bytes
      Variable Size 486539264 bytes
      Database Buffers 956301312 bytes
      Redo Buffers 811008 bytes
      Database mounted.
      ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


      SQL> alter database open resetlogs;
      alter database open resetlogs
      *
      ERROR at line 1:
      ORA-01113: file 1 needs media recovery
      ORA-01110: data file 1: '/export/home/oracle/dev/ADVFRW/ADVFRW.system'


      SQL> recover datafile '/export/home/oracle/dev/ADVFRW/ADVFRW.system'
      ORA-00283: recovery session canceled due to errors
      ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


      SQL> recover database using backup controlfile;
      ORA-00279: change 215548705 generated at 09/02/2008 17:06:10 needed for thread
      1
      ORA-00289: suggestion :
      /export/home/oracle/dev/ADVFRW/ADVFRW.archivelog1/LOG_ADVFRW_1107_1.ARC
      ORA-00280: change 215548705 for thread 1 is in sequence #1107


      Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
      /export/home/oracle/dev/ADVFRW/ADVFRW.archivelog1/LOG_ADVFRW_1107_1.ARC
      ORA-00308: cannot open archived log
      '/export/home/oracle/dev/ADVFRW/ADVFRW.archivelog1/LOG_ADVFRW_1107_1.ARC'
      ORA-27037: unable to obtain file status
      SVR4 Error: 2: No such file or directory
      Additional information: 3


      Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
      CANCEL
      Media recovery cancelled.
      SQL>

      -------------------------------------------------------------------------------------------------------------


      1. How to recover the database and bring it online

      Any help will be highly appreciated.

      With Regards
      Hemant Joshi

      Edited by: hem_Kec on Sep 7, 2008 9:07 AM
        1 2 3 Previous Next