[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