Re: Startup without redo logs?

The one time I used it, about 2 and a half years ago, Data Unloader cost $5k for every 8 hours you had the field rep onsite, with a minimum of 16 hours.

Data Unloader is the LAST desperate step. And yes, I used it because we had lost the online redo logs. You need FIELD support, not Tech Support and it will create either export dump files (one for each table) or files to be fed into sqlldr. We used export files as we had LONG columns.

Data Unloader reads the system tablespace data file(s) and creates its own mappings to find the table data. It can work if the system tablespace is corrupted but you'll probably lose more data.

Rachel

Paul Drake wrote:

> ouch.
> that was the last option.
> what is it, $10K for someone to arrive with the data unloader tool?
 

> be sure that you have exhausted all options before running this drill.
 

> I hope that this works out for you,
 

> Paul

> koert54 wrote:
 

> > did you do a startup mount & then alter database open resetlogs using this
> > parameter ?
> >
> > if that won't work then you'll have to contact Oracle support and ask for a
> > data recovery
> > using DUL.
> > this tool will create an export dmp of your DB even when it's down and
> > corrupted
> >
> > "Knut Talman" <knut.talman_at_mytoys.de> wrote in message
> > news:3B4AEF8B.E61DB1F2_at_mytoys.de...
> > > > if an alter database open resetlogs won't work try setting the
 following
> > > > parameter in
> > > > your init.ora :
> > > > _allow_resetlogs_corruption=TRUE
> > >
> > > Even with setting the above parameter to TRUE I get:
> > >
> > >
> > > ORA-00313: open failed for members of log group 2 of thread 1
> > > ORA-00312: online log 2 thread 1: '/opt/oracle/redo/redo22.log'
> > > ORA-27037: unable to obtain file status
> > > SVR4 Error: 2: No such file or directory
> > > Additional information: 3
> > > ORA-00312: online log 2 thread 1: '/opt/oracle/redo/redo21.log'
> > > ORA-27037: unable to obtain file status
> > > SVR4 Error: 2: No such file or directory
> > > Additional information: 3
> > >
> > >
> > > Any ideas?
> > >
> > > Regards,
> > >
> > > Knut

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Wed Jul 11 2001 - 14:33:10 CDT