Re: Recover from cold backup + archive logs question

On Feb 17, 9:26 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> "mpokr..._at_gmail.com" <mpokr..._at_gmail.com> wrote in news:4915ffe3-bb10-4602-
> 87a2-41946a301..._at_k2g2000hse.googlegroups.com:
>
>
>
> > I have a new 10.2 DB setup on Linux.  I had an issue on 2/16 that
> > requires a recovery.  RMAN is not set up and working properly (yet).
> > That is job one once I get this sorted out.
>
> > I have a cold backup from 2/9 + a weeks worth of archive log files.  I
> > have copied the data files and control files from the cold backup into
> > the proper location.  I have left the archive log files in place,
> > assuming that the DB will look for them in the correct location.
>
> > In sqlplus I do
>
> > startup mount
>
> > recover database
>
> > ORA-00283: recovery session canceled due to errors
> > ORA-00264: no recovery required
>
> > How do I get my cold backup to process all the archive logs?  They are
> > in the default location under the flash_recovery_area/
>
> Open the database using a backup STANDBY controlfile.
>
> There is a NOTE in MetaLink which describes the process.

I would buy you a drink if you lived nearby. Thanks for the help.

Matt Received on Mon Feb 18 2008 - 01:10:35 CST