Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: online redo log groups lost

Re: online redo log groups lost

From: koert54 <nospam_at_nospam.com>
Date: Sat, 11 Jan 2003 13:27:54 GMT
Message-ID: <uZUT9.6342$ym5.776@afrodite.telenet-ops.be> 





    
  
  1.   take a backup of what you have
  
  2.   in init.ora add :
_allow_reset_logs_corruption=true
  
  3.   recreate control file
  
  4.   recover database until cancel using backup controlfile
  
  5.   alter database open resetlogs
  
  6.   export DB
  
  7.   recreate DB


  
      
    
    •   the use of this hidden parameter is not supported by Oracle
    
    •   if this doesn't work your only option is DUL

  
    



Received on Sat Jan 11 2003 - 07:27:54 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US