DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 16

Thread: Corrupted Redolog file and no backup

Threaded View

  1. #9
    Join Date
    Nov 1999
    Location
    Kuwait
    Posts
    122
    Additional information:
    Because log group 2 is the current log group, it will not have been archived. Using the CLEAR LOGFILE command is of no use because:

    SQL> alter database clear unarchived logfile group 2;
    ORA-01624: log 2 needed for crash recovery of thread 1
    ORA-00312: online log 2 thread 1: 'disk1/archive/log2a.rdo'

    Try Performing Incomplete recovery therefore, First you must note the current log sequence number by issuing this statement

    SQL> select * from v$log;

    Use the ALTER DATABASE DROP LOG GROUP and ALTER DATABASE ADD LOG GROUP commands to create the log files manually. Because you performed incomplete recovery, the database should now be backed up.
    Last edited by nabeel; 02-06-2003 at 01:54 AM.
    NK
    ====================================================
    Stand up for your principles even if you stand alone!
    ====================================================

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