Re: Help! Redo logs destroyed

I guess you should read the trace files and determine when that damaged occurs. Then try to do an incomplete recovery on the database like RECOVER DATABASE UNTIL '<TIME>';
But it only works if you are running archive log mode. Then try to open your database with reset log mode. But remember not to restore your controlfiles, only restore your datafiles to their original location.

Good luck

Winnie Liu

David Greensmith wrote in message <359ab069.15755192_at_news.demon.co.uk>...
>Dan Lipofsky <danlip_at_cyc.com> wrote:
>
>>We are running Oracle 7.1.3 on a DEC Alpha with OSF1 v3.0,
>>and are in a very bad situation.
>>
>>We lost a disk which contained our redo logs. None
>>of the data file were damanged, only the .rdo files.
>>HOWEVER, oracle refuses to start up without these files.
>>
>>Any ideas would be appreciated. The basic problem is that
>>until it can open those files and get the info, it wont
>>let me drop them, reset them, or anything else.
>>
>>Here is a bit from the startup.log file:
>>
>>SQLDBA> Connected.
>>SQLDBA> ORACLE instance started.
>>Database mounted.
>>ORA-00313: open failed for members of log group 1 of thread 1
>>ORA-00312: online log 1 thread 1: '/u03/ORACLE/TST8A/usoft8_01b.rdo'
>>ORA-07360: sfifi: stat error, unable to obtain information about file.
>>DEC OSF/1 (AXP) Error: 2: No such file or directory
>>Attempting to dismount database........Database dismounted.
>>Attempting to shutdown instance........ORACLE instance shut down.
>>
>>Here are a few of the commands I have tried which didnt help any:
>>
>>alter database drop logfile group 1;
>>alter database drop logfile member '/u03/ORACLE/TST8A/usoft8_01b.rdo';
>>alter database open resetlogs;
>>alter system checkpoint;
>>(Oracle 7.3 has "alter database clear unarchived logfile", but that
>>doesnt work under Oracle 7.1.3. Too bad, its probably what I want).
>>
>>We have old backups with redo logs on them, but it doesnt
>>help because the sequence numbers do not match.
>>
>>Several DBAs I talked to were unable to help.
>>There must be a way out of this!!
>>
>>- Dan
>>
>>
>Nightmare!
>
>Do you have archive logging enabled? If so, your best bet may be to
>cut your losses and restore/recover to the last log switch.
>
>If not, it is possible to start the database with an undocumented
>INIT.ORA parameter if your redo logs are lost. Be warned that this
>can lead to inconsistent data in the database and a whole host of
>problems later on. Drop me a line if you are interested.
>
>David
>
>David Greensmith :-)
>(david_at_green1.demon.co.uk)
Received on Tue Jul 07 1998 - 00:00:00 CEST