Re: Recover from cold backup + archive logs question

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?

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/business/20080116-9999-1b16prgn.html