Re: lost redo logs, but have consitent offline backup

Hi.

> in a offline backup you must include also all Online-Redologs, so that
> you do not have a backup now. You can now only recreate the database and
> an export file import in it.

Actually, you do *not* have to backup the redo logs during an offline (cold) backup. In fact, Oracle recommends that you do not back them up as you may accidentially restore them during a recovery and lose your current redo log entries.

> > I've lost my redo logs but have an offline consitent backup.
> > I've restored the control and datafiles to the appropriate locations.
> > How do I get oracle to start the instance w/o compliaining about the
> > redo logs? I've tried startup force but this doesn't work.
> > Error:
> > ORA-00313: open failed for members of log group 1 of thread 1
> > ORA-00312: online log 1 thread 1: '/usr/data/log1foo.dbf'
> > ORA-00312: online log 1 thread 1: '/usr/local/data/log1afoo.dbf'

To fix this problem you can try issuing a:

ALTER DATABASE CLEAR LOGFILE GROUP 1; This will dynamiclly re-create the logs according to the specs in the controlfile.

Then issue:

ALTER SYSTEM SWITCH LOGFILE; as many times as you need to to cycle through your logs.

It is important to take another backup soon after issuing this command as you are now missing a "piece" of your recovery mechanism (the data in the redo log you cleared).

Hope this helps

Joe

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 13 1998 - 10:09:39 CST