problems while crash recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: problems while crash recovery

  1. #1
    Join Date
    Jan 2002
    Posts
    94

    Angry

    Good morning!

    I try to recover a oracle8i database which has a corrupted redo log file(current).

    The steps I have done are:
    1) shutdown abort
    2) startup mount
    3) recover database until cancel

    step 3) stops with error messages ora-00279 and ora-00280

    After this step I can not stop this procedure and I have to start with step 1)

    Has any body an idea? Please help!

    chris


  2. #2
    Join Date
    Jan 2002
    Posts
    26
    Hi,
    In my opinion You have to restore the whole database from last backup and then recover DB until last archived log.

  3. #3
    Join Date
    Jan 2002
    Posts
    94
    O, oh,

    the database is in NOARCHIVE LOG MODE and the last backup is to old.

    Is it possible to start the database without crash recovery?

    chris

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Your recover procedure is asking for a archived log file which i guess u dont have.In this case make a note of the archive log file its asking and check ur archive destination wether u have this file.If this file is not there, then at the point of applying this archive log file say 'Cancel'.Then ur recovery will stop.Then issue 'alter database open command;'
    This will open ur database and performing incomplete recovery.

    Regards
    anandkl
    anandkl

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