how can I delete expired archivelogs using RMAN or Enterprise Manager?

[Former Member]

Hi,

we are using oracle 10g.There are one home folder (F:\oracle\GMT\102) and two instance (GMT and GCT)

we want to full backup for GCT instance using Enterprise Manager.Backup starts and after stops because of below archivelog file not found.I think it is expire archive log.

G:\ORACLE\GCT\ORAARCH\GCTARCHARC00371_0661348375.001

how can I delete all expired archivelogs using RMAN or Enterprise Manager?

Regards,

Suleyman BOZKURT

[Former Member]

Thank you for answer but below errors are coming.How can I do?

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\gmtadm>rman

Recovery Manager: Release 10.2.0.2.0 - Production on Wed Oct 15 12:26:45 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN> connect target sys@GCT

target database Password:

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-12154: TNS:could not resolve the connect identifier specified

Suleyman BOZKURT

[stefan_koehler]

Hello,

please copy the commands that i have posted.

Logon as the database user of GCT (or set the correct environment)

>shell> rman target /

>RMAN> crosscheck archivelog all;

The ORA-12154 error means, that the tnsnames.ora does not contain the identifier GCT. You can add an entry in the tnsnames.ora and then it will work, too.

Regards

Stefan

[stefan_koehler]

Hello Suleyman,

i need to clarify something.

You want to backup your database with RMAN, right?

If you want to backup your archivelogs of your database you get an error message that the archivelog file 'GCTARCHARC00371_0661348375.001' is missing?

RMAN needs to guarantee you a consistent recovery scenario and need all files for that. In your case maybe the archivelog file was deleted on filesystem but not backuped before by RMAN.

RMAN detects this and wants this file. You can tell RMAN, that this file is not available anymore and that RMAN should "ignore" it.

> shell> rman target /

> shell> crosscheck archivelog all;

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta021.htm#sthref382

But keep in mind, if you perform RMAN backups without the BR*Tools you will not get any support from SAP.

Regards

Stefan