Syncronize archive log

Artikel ini berhubungan dengan artikel gw yang mengenai merubah ukuran archived log pada database, apabila 
kita telah membackup archived log maka kita perlu menghapusnya secara fisik pada server kita, dan setelah
kita menghapus file archive secara fisik dari server/OS maka pada database harus dilakukan sinkronisasi?.

Langkah-langkah teknis :

[root@alt2007 archivelog]# pwd
/app/oracle/flash_recovery_area/MCC2007/archivelog

[root@alt2007 archivelog]# ls -al
total 44
drwxr-x---   11 oracle   oinstall     4096 Feb 15 00:53 .
drwxr-----    5 oracle   oinstall     4096 Apr  2  2007 ..
drwxr-x---    2 oracle   oinstall     4096 Feb  5 23:40 2008_02_05
drwxr-x---    2 oracle   oinstall     4096 Feb  6 23:00 2008_02_06
drwxr-x---    2 oracle   oinstall     4096 Feb  7 23:00 2008_02_07
drwxr-x---    2 oracle   oinstall     4096 Feb  8 17:34 2008_02_08
drwxr-x---    2 oracle   oinstall     4096 Feb 11 23:00 2008_02_11
drwxr-x---    2 oracle   oinstall     4096 Feb 12 23:10 2008_02_12
drwxr-x---    2 oracle   oinstall     4096 Feb 13 23:00 2008_02_13
drwxr-x---    2 oracle   oinstall     4096 Feb 14 23:56 2008_02_14
drwxr-x---    2 oracle   oinstall     4096 Feb 15 15:13 2008_02_15

[root@alt2007 archivelog]# rm -rf /app/oracle/flash_recovery_area/MCC2007/
                           archivelog/2008_02_0*
[root@alt2007 bin]# ./rman target gunawan/mccdba@mcc2007
Recovery Manager: Release 10.1.0.3.0 - Production
Copyright (c) 1995, 2004, Oracle.  All rights reserved.
connected to target database: MCC2007 (DBID=3021959133)
RMAN> crosscheck copy;
====================== potong =========================================
validation succeeded for archived log
archive log filename=/app/oracle/oradata/mcc2007/archive/1_39940_614016670.dbf recid=39806 stamp=647924450
validation succeeded for archived log
archive log filename=/app/oracle/oradata/mcc2007/archive/1_39941_614016670.dbf recid=39807 stamp=647928023
validation succeeded for archived log
archive log filename=/app/oracle/oradata/mcc2007/archive/1_39942_614016670.dbf recid=39808 stamp=647931658
validation succeeded for archived log
archive log filename=/app/oracle/oradata/mcc2007/archive/1_39943_614016670.dbf recid=39809 stamp=647935254
validation succeeded for archived log
archive log filename=/app/oracle/oradata/mcc2007/archive/1_39944_614016670.dbf recid=39810 stamp=647938818
validation succeeded for archived log
archive log filename=/app/oracle/oradata/mcc2007/archive/1_39945_614016670.dbf recid=39811 stamp=647942443
validation succeeded for archived log
archive log filename=/app/oracle/oradata/mcc2007/archive/1_39946_614016670.dbf recid=39812 stamp=647946018
validation succeeded for archived log
archive log filename=/app/oracle/oradata/mcc2007/archive/1_39947_614016670.dbf recid=39813 stamp=647949632
validation succeeded for archived log
archive log filename=/app/oracle/oradata/mcc2007/archive/1_39948_614016670.dbf recid=39814 stamp=647953230
Crosschecked 598 objects

RMAN> delete noprompt expired copy;

=================potong===============

deleted archive log
archive log filename=/app/oracle/flash_recovery_area/MCC2007/archivelog/2008_02_13/o1_mf_1_39521_3v5nhc3n_.arc recid=39387 stamp=646597083
deleted archive log
archive log filename=/app/oracle/flash_recovery_area/MCC2007/archivelog/2008_02_13/o1_mf_1_39522_3v5qv763_.arc recid=39388 stamp=646600535
deleted archive log
archive log filename=/app/oracle/flash_recovery_area/MCC2007/archivelog/2008_02_13/o1_mf_1_39523_3v5v29vv_.arc recid=39389 stamp=646603834
deleted archive log
archive log filename=/app/oracle/flash_recovery_area/MCC2007/archivelog/2008_02_13/o1_mf_1_39524_3v5v9zsj_.arc recid=39390 stamp=646604080
deleted archive log
archive log filename=/app/oracle/flash_recovery_area/MCC2007/archivelog/2008_02_13/o1_mf_1_39525_3v5y0n6k_.arc recid=39391 stamp=646606852
deleted archive log
archive log filename=/app/oracle/flash_recovery_area/MCC2007/archivelog/2008_02_13/o1_mf_1_39526_3v61jfn6_.arc recid=39392 stamp=646610430
deleted archive log
archive log filename=/app/oracle/flash_recovery_area/MCC2007/archivelog/2008_02_13/o1_mf_1_39527_3v6518sb_.arc recid=39393 stamp=646614041
Deleted 176 EXPIRED objects
RMAN>

Selesai....