Re: An unusual case of recovery asking for an archived log from long time a go.

From: Paresh Yadav <yparesh_at_gmail.com>
Date: Wed, 15 Feb 2012 13:22:47 -0500
Message-ID: <CAPXEL0JQ5=oxEO38YNADN2xefO8AcyPybbyUj6GJ8P5z3u_aFw_at_mail.gmail.com>

Hi Ian,
Thanks for the suggestion. I haven't got any such error in the backup log. Only (unrelated) error I ever got was when I took the first backup on Feb 9, due to small setting for MAXSETSIZE which I fixed and took subsequent successful backups (.... datafile or datafile copy larger than MAXSETSIZE: file# 2 /u01/oradata/AIS/undotbs01.dbf...).

I am also using the controlfile and not rman catalog.

Even though I am not seeing exactly same symptoms as your case, your suggestion sounds promising so I will try it and report back.

Thanks,
Paresh

On Wed, Feb 15, 2012 at 11:44 AM, MacGregor, Ian A. <ian_at_slac.stanford.edu>wrote:

> Does the log of the level 0 backup identify the problem redo log as being
> needed but missing/ If so you should of run
>
> Change Archivelog All Crosscheck;
>
> and then redone the backup. I think that would of fixed the problem. I
> had a database which is not normally backed up, burt I wanted to do so
> before upgrading to 11.2.0.3. The first incremental level 0 I ran gave an
> error saying it needed archived log number 15XX. The archived log created
> just before the backup was 109XXX. It complained about a log from
> months/years ago. Running the crosscheck fixed the problem, and I was able
> to get the backup done. The control file and not an Rman catalog was in
> use.
>
> I wonder if you run crosscheck after the fact, will it let you recover????
>
> Ian MacGregor
> SLAC National Accelerator Center
>
> Hi Howard,
> Thanks for your suggestion. Backup optimization is off. BTW - What was the
> solution in your case? Just turning off backup optimization or you figured
> out a workaround, solution?
>
>

-- 
Thanks
Paresh
416-688-1003


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 15 2012 - 12:22:47 CST