Re: Recover from cold backup + archive logs question
Date: Wed, 20 Feb 2008 11:11:00 -0800 (PST)
On Feb 18, 12:33 pm, "mpokr..._at_gmail.com" <mpokr..._at_gmail.com> wrote:
> On Feb 18, 9:21 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> > On Feb 18, 7:41 am, GD <goran99_rem..._at_yahoo.com> wrote:
> > > mpokr..._at_gmail.com wrote:
> > > > 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/
> > > The database (cold backup) is consistent and requires no recovery to be
> > > opened.
> > > To make it apply the archived logs, you should:
> > > recover database until cancel using backup controlfile;
> > > Regards- Hide quoted text -
> > > - Show quoted text -
> > GD, that is how I would have done the recovery also. I do believe
> > that if the current control file had been available that Oracle on
> > startup would have recognized that recovery was necessary and
> > assumming all archiveded redo logs were available been able to perform
> > automatic recovery.
> > HTH -- Mark D Powell --
> You know, I did not try that approach (old backup datafiles + current
> control files). Our restore process on 8i has been to take old
> control files + old datafiles and then apply the archive logs. Each
> transaction will update the SCN in the control files. My
> understanding is that Oracle will not open the DB if the SCN of the
> control files differ from that of the data files, but I have no ever
> researched the specifics.
> What I did discover as I applied the archive logs was that the final
> log was corrupt. It is possible that, had I removed that, a more
> conventional restore process would have worked.
> Has anyone ever seen a situation where two archive logs, in sequence
> (60 and 61, for example) were created at exactly the same time? In my
> case, 61 was the bad one and the last one. So I applied up through 60.
Was 61 only a partially copied redo log? What was current when you crashed? See metalink Note:91469.1
What does the alert log say about those two logs?
-- @home.com is bogus. http://www.signonsandiego.com/news/business/20080116-9999-1b16prgn.htmlReceived on Wed Feb 20 2008 - 13:11:00 CST