Re: With regards to BACKUP Archive log using RMAN, I am using VERSION 8i

"AMIT" <kumar_929_at_yahoo.co.uk> a écrit dans le message de news:6f94b59f.0312291955.126e7468_at_posting.google.com...
> Dear friends,
>
> Thanks for your useful information. But I would like to inform that I
> am using Oracle 8i. That's why this command don't run on 8i:
> backup achivelog all skip inaccessible;
>
> Can you give an alternate solution/an automated routine that skip all
> unavailable archive file during backup via RMAN.
>
> With Regards
>
> Amit
>
>
> "Michel Cadot" <micadot{at}altern{dot}org> wrote in message
news:<3fefcf17$0$19281$626a54ce_at_news.free.fr>...
> > "AMIT" <kumar_929_at_yahoo.co.uk> a écrit dans le message de
> > news:6f94b59f.0312281959.22657a06_at_posting.google.com...
> > > I have a query related to backup archive logfiles.
> > >
> > > With regards to RMAN, I am taking a backup of
> > > archived log files but if one of them was deleted
> > > ,the RMAN gave the following error.
> > >
> > > For Example:
> > >
> > > RMAN-06089: archived log
> > > D:\ORACLE9I\ORA92\RDBMS\ARC00028.001 not found
> > >
> > > However we tell RMAN not to read the unavailable
> > > ArchivedLog Files by using the following command, therefore
> > > this error not comes.
> > >
> > > RMAN> change archivelog 'c:\oracle9i\ora92\rdbms\arc00028.001'
> > > uncatalog;
> > >
> > > But I want that this operation will perform automatically with out
> > > getting error.
> > >
> > > Actually we backup the ArchiveLogs but they never get deleted.
> > > Once we have more than 4 Weeks of ArchiveLogs on our Server we delete
> > > the ArchiveLogs that are older than 4 weeks.
> > >
> > > Our automated Backup Program uses RMAN and stops with an Error.
> > >
> > > We would like to adjust the RMAN Script used by the Backup Program so
> > > no more errors are generated, because old ArchiveLogs were deleted.
> > >
> > > The ArchiveLogs already got backed up on Tape. However the deletion is
> > > not automated and we would like to keep it that way. Could you please
> > > send a script that give a solution.
> > >
> > > Thanks
> > >
> > > AMIT
> >
> > backup achivelog all skip inaccessible;
> >
> > Hope this helps
> > Michel Cadot

Have a look at "change archivelog" RMAN command and other related commands: crosscheck, deleteExpired...

You can also ajust the control_file_record_keep_time parameter in your init.ora.

Hope this helps
Michel Cadot Received on Tue Dec 30 2003 - 03:21:28 CST