redo log file help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: redo log file help

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    38
    one of our java guys was running out of space, so he deleted his redolog files. Now his db wont start up. I get an error message ora - 01033. What is the best way to get him up and running again. I looked at his trc files and it's looking for his redo01.log file. Thanks for the hlep.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    could try this, dont know if it will work though :-)

    open database in mount state, backup control file to trace
    edit the trace file to make sure redo logs are current and ok (making sure you still have one in each group) and recreate the control file

    then

    alter database open resetlogs

  3. #3
    Join Date
    Jan 2002
    Posts
    38
    The problem with that is I can't connect to the database. I still get this error ORA-01033: ORACLE initialization or shutdown in progress. Even after rebooting. Thanks for the suggestion.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    errr try

    sqlplus /nolog

    connect internal

    shutdown abort that should get it down for you

    has someone issues a shutdown normal command with processes still connected?

  5. #5
    Join Date
    Jan 2002
    Posts
    38
    He went to services and hit the stop command. So Oracle was shutdown, then he deleted all of the redo log files.

  6. #6
    Join Date
    Nov 2000
    Posts
    224
    Go for imcomplete recovery. Since DBA has deleted all the redologs, means the active redolog also the only solution is recover till the user deleted the database.

    Check Alert.log file to see when was the last archive generated.

    Incomplete recovery is the option
    1. Note the current log sequence number
    SQL> select * from V$LOG;

    2. Restore all the datafile from previous backup


    3. Recover the database until cancel to stop before the lost redo log is applied
    SQL> recover database until cancel;

    4. Open the database using RESETLOGS
    SQL> alter database open resetlogs;

    5. Recreate the missing logfiles. If logfiles need to be recreated on another disk
    SQL> alter database drop log group
    SQL> alter database add log group

    6. Since incomplete recovery is performed, the database should now be backed up

  7. #7
    Join Date
    Sep 2002
    Posts
    5

    Wink

    ORA-01033 ORACLE initialization or shutdown in progress
    Cause: An attempt was made to log on while Oracle is being started or shut down.
    Action: Wait a few minutes. Then retry the operation.
    Ajmal Chishti

  8. #8
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by Sharma
    Go for imcomplete recovery. Since DBA has deleted all the redologs, means the active redolog also the only solution is recover till the user deleted the database.

    Check Alert.log file to see when was the last archive generated.

    Incomplete recovery is the option
    1. Note the current log sequence number
    SQL> select * from V$LOG;

    2. Restore all the datafile from previous backup


    3. Recover the database until cancel to stop before the lost redo log is applied
    SQL> recover database until cancel;

    4. Open the database using RESETLOGS
    SQL> alter database open resetlogs;

    5. Recreate the missing logfiles. If logfiles need to be recreated on another disk
    SQL> alter database drop log group
    SQL> alter database add log group

    6. Since incomplete recovery is performed, the database should now be backed up
    Yep.. this is the one and only solution... We have to restore all the datafiles from previously taken backups...
    -nagarjuna

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