Re: Recover from cold backup + archive logs question
Date: Sun, 17 Feb 2008 23:10:35 -0800 (PST)
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-
> > 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