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: [Q] Lost redo log files - can I start DB?

Re: [Q] Lost redo log files - can I start DB?

From: Anton Dischner <dischner_at__NO_SPAM_med.uni-muenchen.de>
Date: 1997/12/12
Message-ID: <dischner-1212971338510001@klchmc3.klch.med.uni-muenchen.de>#1/1

Hi David,

there is an undocumented init>SID>.ora parameter. I was able to restore my log-files with the help ORACLE-support. If it is still of interest for you mail me and i'll look up the commands used.

allow_resetlogs_corruption = true.

Kind regards,

Toni
In article <01bd04df$a516e0c0$ab4195c1_at_thor>, "David Russell" <user_at_msn.com> wrote:

> You need to perform the following :
>
> recover database using backup controlfile until cancel
> ...... auto .....
> at the last archive log type cancel
> then open database resetlogs.
>
> Regards
> David Russell
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  | Please remove            
Marchioninistr.15 81366 Muenchen 49-89-70953202 | _NO_SPAM for email.
Received on Fri Dec 12 1997 - 00:00:00 CST

Original text of this message

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