Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN Backup of Archived Log Files
On 28 Dec 2003 19:59:00 -0800, kumar_929_at_yahoo.co.uk (AMIT) wrote:
>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
The problems you are having arise *because* you don't use RMAN to
delete the archived redo logs. As you don't include a version it is
difficult to provide you with the exact commands, but you should
lookup the delete expired command in your RMAN manual.
You should also lookup the skip unavailable clause of the backup
command.
However, if RMAN still attempts to backup archive logs of several
weeks old, there is likely more wrong with your script.
If you use RMAN to backup your database, you must dump any other tools
you are using, otherwiese you will be in trouble.
-- Sybrand Bakker, Senior Oracle DBAReceived on Mon Dec 29 2003 - 00:47:24 CST