Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> With regards to BACKUP Archive log using RMAN, I am using VERSION 8i

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

From: AMIT <kumar_929_at_yahoo.co.uk>
Date: 29 Dec 2003 19:55:44 -0800
Message-ID: <6f94b59f.0312291955.126e7468@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
Received on Mon Dec 29 2003 - 21:55:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US