[10/02] Admin2 C3-2
RMAN> list archivelog all;
List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
416 1 220 A 30-SEP-15
Name: /u01/app/oracle/product/11.2.0/db_1/dbs/disk6orcl_1_220_890551615.arc
417 1 221 A 01-OCT-15
Name: /disk6/orcl_1_221_890551615.arc
418 1 222 A 01-OCT-15
Name: /disk6/orcl_1_222_890551615.arc
419 1 223 A 01-OCT-15
Name: /disk6/_1_223_890551615.arc
420 1 224 A 02-OCT-15
Name: /disk6/_1_224_890551615.arc
451 1 225 A 02-OCT-15
Name: /disk6/_1_225_890551615.arc
458 1 226 A 02-OCT-15
Name: /disk6/_1_226_890551615.arc
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=165 device type=DISK
validation failed for archived log
archived log file name=/u01/app/oracle/product/11.2.0/db_1/dbs/disk6orcl_1_220_890551615.arc RECID=160 STAMP=891934119
validation failed for archived log
archived log file name=/disk6/orcl_1_221_890551615.arc RECID=161 STAMP=891961536
validation failed for archived log
archived log file name=/disk6/orcl_1_222_890551615.arc RECID=162 STAMP=891963292
validation failed for archived log
archived log file name=/disk6/_1_223_890551615.arc RECID=163 STAMP=892019365
validation failed for archived log
archived log file name=/disk6/_1_224_890551615.arc RECID=164 STAMP=892035177
validation failed for archived log
archived log file name=/disk6/_1_225_890551615.arc RECID=165 STAMP=892035682
validation failed for archived log
archived log file name=/disk6/_1_226_890551615.arc RECID=166 STAMP=892036555
Crosschecked 7 objects
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=165 device type=DISK
List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
416 1 220 X 30-SEP-15
Name: /u01/app/oracle/product/11.2.0/db_1/dbs/disk6orcl_1_220_890551615.arc
417 1 221 X 01-OCT-15
Name: /disk6/orcl_1_221_890551615.arc
418 1 222 X 01-OCT-15
Name: /disk6/orcl_1_222_890551615.arc
419 1 223 X 01-OCT-15
Name: /disk6/_1_223_890551615.arc
420 1 224 X 02-OCT-15
Name: /disk6/_1_224_890551615.arc
451 1 225 X 02-OCT-15
Name: /disk6/_1_225_890551615.arc
458 1 226 X 02-OCT-15
Name: /disk6/_1_226_890551615.arc
Do you really want to delete the above objects (enter YES or NO)? y
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/db_1/dbs/disk6orcl_1_220_890551615.arc RECID=160 STAMP=891934119
deleted archived log
archived log file name=/disk6/orcl_1_221_890551615.arc RECID=161 STAMP=891961536
deleted archived log
archived log file name=/disk6/orcl_1_222_890551615.arc RECID=162 STAMP=891963292
deleted archived log
archived log file name=/disk6/_1_223_890551615.arc RECID=163 STAMP=892019365
deleted archived log
archived log file name=/disk6/_1_224_890551615.arc RECID=164 STAMP=892035177
deleted archived log
archived log file name=/disk6/_1_225_890551615.arc RECID=165 STAMP=892035682
deleted archived log
archived log file name=/disk6/_1_226_890551615.arc RECID=166 STAMP=892036555
Deleted 7 EXPIRED objects