Re: Oracle 8i crashed: system ts needs more recovery - how do I recover from this?
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: mark@xxxxxxxxxxxxxxxxxxxxxxxxx
- Date: Thu, 31 Oct 2013 08:11:29 -0500
I have read that the option _ALLOW_RESETLOGS_CORRUPTION will sometimes
allow you to open the database with resetlogs so that you can then export
the data. However, I have tried it a couple of times with no success. Its
my understanding you need to use it after running the create controlfile
command. In this case, it sounds like you need to try it before doing a
recovery.
On Thu, Oct 31, 2013 at 6:27 AM, Mark Burgess <
mark@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> Hi Tony,
> For the recover command use until cancel and then cancel when prompted for
> the first arch log:
>
> recover database until cancel using backup controlfile;
>
> Cancel when prompted. Then open reset logs.
>
> Any idea if these data files were in backup mode since 9-8-2013? It might
> explain why the checkpoint scn has been frozen since then.
>
> Regards,
>
> Mark
>
> > On 31 Oct 2013, at 9:49 pm, De DBA <dedba@xxxxxxxxxx> wrote:<snip
> >> Mark
> >
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
//www.freelists.org/webpage/oracle-l
Other related posts:
