Re: Strange sequence of error messages during recovery

From: Mark D Powell <>
Date: Fri, 24 Oct 2008 17:27:17 -0700 (PDT)
Message-ID: <>

On Oct 24, 3:23 pm, Raghuram Devarakonda <> wrote:
> > What version of Oracle?
> >  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 --
Received on Fri Oct 24 2008 - 19:27:17 CDT

Original text of this message