Use the below command to delete archive logs from ASM Disk Group or other file systems.
Method 1: Delete archive logs using RMAN with Recovery Catalog
RMAN> connect catalog userid/password@connection_string
RMAN> connect target
RMAN> delete force archivelog like '
For ex: -
RMAN> delete force archivelog like '+FLASH/testdb/archivelog/2009_08_11/thread_1_seq_366.663.1;
To delete multiple files just place them after the LIKE clause and use wildcard for file names.
RMAN> delete force archivelog like '+FLASH/asm/archivelog/2009_08_11/thread_1_*;
Method 2: Delete archive logs using RMAN with out Recovery Catalog.
RMAN> connect target
RMAN> delete force archivelog like '+FLASH/asm/archivelog/2009_08_11/thread_1_seq_366.663.1;
RMAN will update the controlfile/recovery catalog that the files have been removed.
Click here to learn How to delete the database files and archive logs without using RMAN.
Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com/
Posts
1 comments:
Step Configuration :
The first thing to do is, find where the archive log is put and after that you must use RMAN to delete the archive on command promt. type this command RMAN
RMAN> run { allocate channel d1 type disk;
delete archivelog all;
release channel d1;
}
16GB SD Karte
Post a Comment