Re: how do we restore in this scenerio?

you can try putting this parameter in your init file: _allow_resetlogs_corruption=true
This should allow the database to open but in an unsupported and, most likely, unusable state.

In article <91cnau$mv3$1_at_soap.pipex.net>,   "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:
> I think I'd just go for the export file, recreating the db. Howard
 may be
> able to point you to some fancier techniques, but it does sound to me
 with
> inconsistent files and insufficient logs that the db is probably NOT
> recoverable. Kind of proves the point of testing backup/restore to
> management though doesn't it.
>
> regards
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "sp" <sdpant_at_yahoo.com> wrote in message
> news:n89_5.1481$1%2.67207_at_sjc-read.news.verio.net...
> > Thanks Alex and Niall. I've tried to open at earlier time/until
 cancel
 but
> > it didn't work. Seems like while restoring the files some files got
 messed
> > up and they all are inconsistent now. We don't have cold backup
 also.
> >
> > This is a test database that is expected to go into production next
 month
> > and currently we're testing backup/recovery. The data in it is not
 crucial
> > (still I still have export file) and I just want to open the db.
 In this
> > situation how can I can I do that?
> > SP
> > "sp" <sdpant_at_yahoo.com> wrote in message
> > news:rbWZ5.1381$1%2.61363_at_sjc-read.news.verio.net...
> > > Ours is Oracle 8.1.5 db in Solaris environment. Our db got
 corrupted up
 on
> > > 12/13.
> > > We have a back of all the data files and control files from
 12/12. Our
> > > archivelogs
> > > somehow got deleted even though we are in archivelog mode. We
 tried to
> > > restore point
> > > in time with the backup from 12/12 and got the following error:
> > >
> > > recover database until time '2000-12-13:11:05:00' using backup
 controlfile;
> > > ORA-00279: change 859942 generated at 12/12/00 18:23:53 needed for
 thread
 1
> > > Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> > >
> > > ORA-00266: name of archived log file needed
> > > ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would
 get error
> > > below
> > > ORA-01194: file 1 needs more recovery to be consistent
> > > ORA-01110: data file 1: '/U04/oradata/gl/gamelink/system01.dbf'
> > >
> > > So my question is how do we restore to the point we have full
 backup
 i.e.
> > > 12/12 ?(we don't any archivelog of 12/12) .
> > >
> > > Thanx in advance.
> > >
> > > SP
> > >
> > >
> > >
> > >
> >
> >
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 15 2000 - 10:48:54 CST