Re: Help! Redo logs destroyed

From: Ivan Boesing <boesing_at_nospam.geocities.com>
Date: 1998/07/03
Message-ID: <01bda5f0$1f8e5e80$0cce040a@ivan.tre-rs.gov.br>#1/1

Hi Dan,

      You can try put the parameter "_allow_resetlogs_corruption = true" in your init.ora file.

        Caution is advised when using it as you might end-up with lost or inconsistent data!!!

         
        Please contact me if it works.

--------------------------------------------------------------------

Ivan Boesing
Oracle DBA
boesing_at_nospam.geocities.com
Please remove the "nospam." to contact me.

---

Dan Lipofsky <danlip_at_cyc.com> escreveu no artigo <3591724D.9F35A3B_at_cyc.com>...
> 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
>
>
>
  Received on Fri Jul 03 1998 - 00:00:00 CDT