Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shutdown abort and then I Lost Redo log files
Mark D Powell wrote:
> Steve Howard wrote:
> > Jumbo wrote:
> > > "peter" <hhh.database_at_gmail.com> wrote in message
> > > news:1149169618.949001.189470_at_i39g2000cwa.googlegroups.com...
> > > > Thank You for Your Answer. Actually I just finished my OCP. I know this
> > > > command but didn't know when to use it so I was unable to solve this
> > > > problem but now I unstand so thank you very much.. and I will also
> > > > keep this site in mind. From Next time first I try to solve my problem
> > > > from this site and then ask here
> > >
> > >
> > > If you cannot open your database after a shutdown abort your probably have
> > > 'checkpoint not complet' messages in your alert.log.
> > > Increase the size of your redo logs or add more groups.
> >
> > ???
> >
> > Take a look at the subject line of the post to which you responded...
>
>
>
...also (and I wouldn't recommend it), but if you don't have a backup, in an *absolute worst case scenario*, you can issue the infamous _allow_resetlogs_corruption=true, bounce it, open resetlogs, and then get an immediate export. You almost certainly will have corrupt data. It is probably not even feasible time wise (let alone process-wise) given the size of todays' databases (I know we couldn't), but for understanding recovery concepts in a single test system, it can be useful.
Let the flames begin :)
Regards,
Steve Received on Thu Jun 01 2006 - 11:16:21 CDT