Re: Strange sequence of error messages during recovery

On Oct 24, 3:23 pm, Raghuram Devarakonda <draghu..._at_gmail.com> wrote:
> > What version of Oracle?
>
> 11.1.0.6.0
>
> >  RAC or non-RAC?
>
> non-RAC. Platform is Windows.
>
> > Which tool is being used to perform recovery?
>
> sqlplus.
>
> > What was done prior to issuing the recovery command?
>
> data files and archive logs are restored from backup. Please note that
> backup and restore are user managed and not using RMAN.
>
> > Where did you get the SCN number you are using?  Are you sure it is
> > older than the SCN recorded in all database data files in use?
>
> I get the SCN number from the lone archive log
> ARC00080_0668630851.001. Yes, it is definitely later than all the data
> in data files. Even the above error messages seem to suggest that data
> in ARC00079_0668630851.001 is not needed for recovery. It is then
> puzzling why oracle should attempt to access the file.
>
> Thanks,
> Raghu

Did you also restore the control file? Is the current control file available?

I think I would use a point in time instead on an SCN if at all possible in my recovery command.

• Mark D Powell --