物理DG刪除歸檔測試
備庫上檢視歸檔日誌的應用情況：（顯示是YES的日誌表示已經被應用）
SQL> select name,creator,sequence#,applied,completion_time from v$archived_log;
NAME CREATOR SEQUENCE# APP COMPLETIO
--------------------------------------------- ------- ---------- --- ---------
/u01/orcl_arch/1_2_847903838.dbf ARCH 2 YES 18-MAY-14
/u01/orcl_arch/1_3_847903838.dbf ARCH 3 YES 18-MAY-14
/u01/orcl_arch/1_4_847903838.dbf ARCH 4 YES 18-MAY-14
/u01/orcl_arch/1_5_847903838.dbf ARCH 5 YES 18-MAY-14
/u01/orcl_arch/1_6_847903838.dbf ARCH 6 YES 18-MAY-14
/u01/orcl_arch/1_7_847903838.dbf ARCH 7 YES 18-MAY-14
/u01/orcl_arch/1_8_847903838.dbf ARCH 8 YES 18-MAY-14
/u01/orcl_arch/1_9_847903838.dbf ARCH 9 YES 18-MAY-14
/u01/orcl_arch/1_10_847903838.dbf ARCH 10 YES 18-MAY-14
/u01/orcl_arch/1_11_847903838.dbf ARCH 11 YES 18-MAY-14
/u01/orcl_arch/1_12_847903838.dbf ARCH 12 YES 18-MAY-14
NAME CREATOR SEQUENCE# APP COMPLETIO
--------------------------------------------- ------- ---------- --- ---------
/u01/orcl_arch/1_13_847903838.dbf ARCH 13 YES 18-MAY-14
/u01/orcl_arch/1_14_847903838.dbf ARCH 14 YES 18-MAY-14
/u01/orcl_arch/1_15_847903838.dbf ARCH 15 YES 18-MAY-14
/u01/orcl_arch/1_16_847903838.dbf ARCH 16 YES 18-MAY-14
/u01/orcl_arch/1_17_847903838.dbf ARCH 17 YES 18-MAY-14
/u01/orcl_arch/1_18_847903838.dbf ARCH 18 YES 18-MAY-14
/u01/orcl_arch/1_19_847903838.dbf ARCH 19 YES 18-MAY-14
/u01/orcl_arch/1_20_847903838.dbf ARCH 20 YES 18-MAY-14
/u01/orcl_arch/1_21_847903838.dbf ARCH 21 YES 18-MAY-14
/u01/orcl_arch/1_22_847903838.dbf ARCH 22 YES 18-MAY-14
/u01/orcl_arch/1_23_847903838.dbf ARCH 23 YES 18-MAY-14
NAME CREATOR SEQUENCE# APP COMPLETIO
--------------------------------------------- ------- ---------- --- ---------
/u01/orcl_arch/1_24_847903838.dbf ARCH 24 YES 18-MAY-14
/u01/orcl_arch/1_25_847903838.dbf ARCH 25 YES 18-MAY-14
/u01/orcl_arch/1_26_847903838.dbf ARCH 26 YES 18-MAY-14
/u01/orcl_arch/1_27_847903838.dbf ARCH 27 YES 18-MAY-14
/u01/orcl_arch/1_28_847903838.dbf ARCH 28 YES 18-MAY-14
/u01/orcl_arch/1_29_847903838.dbf ARCH 29 YES 18-MAY-14
/u01/orcl_arch/1_30_847903838.dbf ARCH 30 YES 18-MAY-14
/u01/orcl_arch/1_31_847903838.dbf ARCH 31 YES 18-MAY-14
/u01/orcl_arch/1_32_847903838.dbf ARCH 32 NO 18-MAY-14
/u01/orcl_arch/1_33_847903838.dbf ARCH 33 NO 18-MAY-14
/u01/orcl_arch/1_34_847903838.dbf ARCH 34 NO 18-MAY-14
33 rows selected.
主庫上檢視程式資訊：
SQL> select process,client_process,sequence#,status from v$managed_standby;
PROCESS CLIENT_P SEQUENCE# STATUS
--------- -------- ---------- ------------
ARCH ARCH 34 CLOSING
ARCH ARCH 34 CLOSING
closing表示已經歸檔程式已經關閉
主庫檢視standby資料庫未接受的日誌（此處顯示的這些是dg搭建前的日誌，已經不存在，故不用考慮，正常的應該是沒有資料，如果有資料，查詢出的日誌不可刪除）：
SQL> select local.thread#,local.sequence# from
2 (select thread#,sequence# from v$archived_log where dest_id=1) local
3 where local.sequence# not in
4 (select sequence# from v$archived_log where dest_id=2 and
5 thread# = local.thread#);
THREAD# SEQUENCE#
---------- ----------
1 124
1 125
1 126
1 127
1 128
1 129
1 130
1 131
1 130
1 129
1 1
11 rows selected.
刪除可以刪除的日誌：（APPLED狀態為YES並且確定standby資料庫已經接收的日誌可以被刪除），以上顯示可以看出，除以下三組日誌外其他日誌均可刪除
/u01/orcl_arch/1_32_847903838.dbf ARCH 32 NO 18-MAY-14
/u01/orcl_arch/1_33_847903838.dbf ARCH 33 NO 18-MAY-14
/u01/orcl_arch/1_34_847903838.dbf ARCH 34 NO 18-MAY-14
作業系統刪除日誌：
[oracle@localhost ~]$ cd /u01/orcl_arch/
[oracle@localhost orcl_arch]$ ls
1_10_847903838.dbf 1_18_847903838.dbf 1_27_847903838.dbf 1_3_847903838.dbf
1_11_847903838.dbf 1_19_847903838.dbf 1_2_847903838.dbf 1_4_847903838.dbf
1_12_847903838.dbf 1_20_847903838.dbf 1_28_847903838.dbf 1_5_847903838.dbf
1_13_847903838.dbf 1_21_847903838.dbf 1_29_847903838.dbf 1_6_847903838.dbf
1_14_847903838.dbf 1_22_847903838.dbf 1_30_847903838.dbf 1_7_847903838.dbf
1_15_847903838.dbf 1_23_847903838.dbf 1_31_847903838.dbf 1_8_847903838.dbf
1_16_847903838.dbf 1_24_847903838.dbf 1_32_847903838.dbf 1_9_847903838.dbf
1_17_847903838.dbf 1_25_847903838.dbf 1_33_847903838.dbf
1_1_847903838.dbf 1_26_847903838.dbf 1_34_847903838.dbf
[oracle@localhost orcl_arch]$ rm -rf 1_1*
[oracle@localhost orcl_arch]$ rm -rf 1_2*
[oracle@localhost orcl_arch]$ rm -rf 1_4*
[oracle@localhost orcl_arch]$ rm -rf 1_5*
[oracle@localhost orcl_arch]$ rm -rf 1_6*
[oracle@localhost orcl_arch]$ rm -rf 1_7*
[oracle@localhost orcl_arch]$ rm -rf 1_8*
[oracle@localhost orcl_arch]$ rm -rf 1_9*
[oracle@localhost orcl_arch]$ rm -rf 1_3_847903838.dbf
[oracle@localhost orcl_arch]$ rm -rf 1_30_847903838.dbf
[oracle@localhost orcl_arch]$ rm -rf 1_31_847903838.dbf
[oracle@localhost orcl_arch]$ ls
1_32_847903838.dbf 1_33_847903838.dbf 1_34_847903838.dbf
當然，不用刪除那麼多，刪除較早的日誌就行了
rman清楚刪除的日誌（rman檢查後會指定被刪除的日誌不可用，可以刪除）
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=136 devtype=DISK
validation failed for archived log
archive log filename=/u01/orcl_arch/1_1_847903838.dbf recid=137 stamp=847904734
validation failed for archived log
archive log filename=/u01/orcl_arch/1_2_847903838.dbf recid=138 stamp=847915787
validation failed for archived log
archive log filename=/u01/orcl_arch/1_3_847903838.dbf recid=140 stamp=847915904
validation failed for archived log
archive log filename=/u01/orcl_arch/1_4_847903838.dbf recid=142 stamp=847915908
validation failed for archived log
archive log filename=/u01/orcl_arch/1_5_847903838.dbf recid=144 stamp=847916927
validation failed for archived log
archive log filename=/u01/orcl_arch/1_6_847903838.dbf recid=146 stamp=847916927
validation failed for archived log
archive log filename=/u01/orcl_arch/1_7_847903838.dbf recid=148 stamp=847916932
validation failed for archived log
archive log filename=/u01/orcl_arch/1_8_847903838.dbf recid=150 stamp=847917055
validation failed for archived log
archive log filename=/u01/orcl_arch/1_9_847903838.dbf recid=152 stamp=847917056
validation failed for archived log
archive log filename=/u01/orcl_arch/1_10_847903838.dbf recid=154 stamp=847917061
validation failed for archived log
archive log filename=/u01/orcl_arch/1_11_847903838.dbf recid=156 stamp=847917063
validation failed for archived log
archive log filename=/u01/orcl_arch/1_12_847903838.dbf recid=158 stamp=847917063
validation failed for archived log
archive log filename=/u01/orcl_arch/1_13_847903838.dbf recid=160 stamp=847917064
validation failed for archived log
archive log filename=/u01/orcl_arch/1_14_847903838.dbf recid=162 stamp=847917065
validation failed for archived log
archive log filename=/u01/orcl_arch/1_15_847903838.dbf recid=164 stamp=847917065
validation failed for archived log
archive log filename=/u01/orcl_arch/1_16_847903838.dbf recid=166 stamp=847917066
validation failed for archived log
archive log filename=/u01/orcl_arch/1_17_847903838.dbf recid=168 stamp=847917067
validation failed for archived log
archive log filename=/u01/orcl_arch/1_18_847903838.dbf recid=170 stamp=847917076
validation failed for archived log
archive log filename=/u01/orcl_arch/1_19_847903838.dbf recid=172 stamp=847917078
validation failed for archived log
archive log filename=/u01/orcl_arch/1_20_847903838.dbf recid=174 stamp=847917079
validation failed for archived log
archive log filename=/u01/orcl_arch/1_21_847903838.dbf recid=176 stamp=847917079
validation failed for archived log
archive log filename=/u01/orcl_arch/1_22_847903838.dbf recid=178 stamp=847917084
validation failed for archived log
archive log filename=/u01/orcl_arch/1_23_847903838.dbf recid=180 stamp=847917085
validation failed for archived log
archive log filename=/u01/orcl_arch/1_24_847903838.dbf recid=182 stamp=847917085
validation failed for archived log
archive log filename=/u01/orcl_arch/1_25_847903838.dbf recid=184 stamp=847917086
validation failed for archived log
archive log filename=/u01/orcl_arch/1_26_847903838.dbf recid=186 stamp=847917086
validation failed for archived log
archive log filename=/u01/orcl_arch/1_27_847903838.dbf recid=188 stamp=847917087
validation failed for archived log
archive log filename=/u01/orcl_arch/1_28_847903838.dbf recid=190 stamp=847917087
validation failed for archived log
archive log filename=/u01/orcl_arch/1_29_847903838.dbf recid=192 stamp=847917088
validation failed for archived log
archive log filename=/u01/orcl_arch/1_30_847903838.dbf recid=194 stamp=847917088
validation failed for archived log
archive log filename=/u01/orcl_arch/1_31_847903838.dbf recid=196 stamp=847917094
validation succeeded for archived log
archive log filename=/u01/orcl_arch/1_32_847903838.dbf recid=198 stamp=847917139
validation succeeded for archived log
archive log filename=/u01/orcl_arch/1_33_847903838.dbf recid=200 stamp=847917139
validation succeeded for archived log
archive log filename=/u01/orcl_arch/1_34_847903838.dbf recid=202 stamp=847917145
Crosschecked 34 objects
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=136 devtype=DISK
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
137 1 1 X 18-MAY-14 /u01/orcl_arch/1_1_847903838.dbf
138 1 2 X 18-MAY-14 /u01/orcl_arch/1_2_847903838.dbf
140 1 3 X 18-MAY-14 /u01/orcl_arch/1_3_847903838.dbf
142 1 4 X 18-MAY-14 /u01/orcl_arch/1_4_847903838.dbf
144 1 5 X 18-MAY-14 /u01/orcl_arch/1_5_847903838.dbf
146 1 6 X 18-MAY-14 /u01/orcl_arch/1_6_847903838.dbf
148 1 7 X 18-MAY-14 /u01/orcl_arch/1_7_847903838.dbf
150 1 8 X 18-MAY-14 /u01/orcl_arch/1_8_847903838.dbf
152 1 9 X 18-MAY-14 /u01/orcl_arch/1_9_847903838.dbf
154 1 10 X 18-MAY-14 /u01/orcl_arch/1_10_847903838.dbf
156 1 11 X 18-MAY-14 /u01/orcl_arch/1_11_847903838.dbf
158 1 12 X 18-MAY-14 /u01/orcl_arch/1_12_847903838.dbf
160 1 13 X 18-MAY-14 /u01/orcl_arch/1_13_847903838.dbf
162 1 14 X 18-MAY-14 /u01/orcl_arch/1_14_847903838.dbf
164 1 15 X 18-MAY-14 /u01/orcl_arch/1_15_847903838.dbf
166 1 16 X 18-MAY-14 /u01/orcl_arch/1_16_847903838.dbf
168 1 17 X 18-MAY-14 /u01/orcl_arch/1_17_847903838.dbf
170 1 18 X 18-MAY-14 /u01/orcl_arch/1_18_847903838.dbf
172 1 19 X 18-MAY-14 /u01/orcl_arch/1_19_847903838.dbf
174 1 20 X 18-MAY-14 /u01/orcl_arch/1_20_847903838.dbf
176 1 21 X 18-MAY-14 /u01/orcl_arch/1_21_847903838.dbf
178 1 22 X 18-MAY-14 /u01/orcl_arch/1_22_847903838.dbf
180 1 23 X 18-MAY-14 /u01/orcl_arch/1_23_847903838.dbf
182 1 24 X 18-MAY-14 /u01/orcl_arch/1_24_847903838.dbf
184 1 25 X 18-MAY-14 /u01/orcl_arch/1_25_847903838.dbf
186 1 26 X 18-MAY-14 /u01/orcl_arch/1_26_847903838.dbf
188 1 27 X 18-MAY-14 /u01/orcl_arch/1_27_847903838.dbf
190 1 28 X 18-MAY-14 /u01/orcl_arch/1_28_847903838.dbf
192 1 29 X 18-MAY-14 /u01/orcl_arch/1_29_847903838.dbf
194 1 30 X 18-MAY-14 /u01/orcl_arch/1_30_847903838.dbf
196 1 31 X 18-MAY-14 /u01/orcl_arch/1_31_847903838.dbf
Do you really want to delete the above objects (enter YES or NO)? YES
deleted archive log
archive log filename=/u01/orcl_arch/1_1_847903838.dbf recid=137 stamp=847904734
deleted archive log
archive log filename=/u01/orcl_arch/1_2_847903838.dbf recid=138 stamp=847915787
deleted archive log
archive log filename=/u01/orcl_arch/1_3_847903838.dbf recid=140 stamp=847915904
deleted archive log
archive log filename=/u01/orcl_arch/1_4_847903838.dbf recid=142 stamp=847915908
deleted archive log
archive log filename=/u01/orcl_arch/1_5_847903838.dbf recid=144 stamp=847916927
deleted archive log
archive log filename=/u01/orcl_arch/1_6_847903838.dbf recid=146 stamp=847916927
deleted archive log
archive log filename=/u01/orcl_arch/1_7_847903838.dbf recid=148 stamp=847916932
deleted archive log
archive log filename=/u01/orcl_arch/1_8_847903838.dbf recid=150 stamp=847917055
deleted archive log
archive log filename=/u01/orcl_arch/1_9_847903838.dbf recid=152 stamp=847917056
deleted archive log
archive log filename=/u01/orcl_arch/1_10_847903838.dbf recid=154 stamp=847917061
deleted archive log
archive log filename=/u01/orcl_arch/1_11_847903838.dbf recid=156 stamp=847917063
deleted archive log
archive log filename=/u01/orcl_arch/1_12_847903838.dbf recid=158 stamp=847917063
deleted archive log
archive log filename=/u01/orcl_arch/1_13_847903838.dbf recid=160 stamp=847917064
deleted archive log
archive log filename=/u01/orcl_arch/1_14_847903838.dbf recid=162 stamp=847917065
deleted archive log
archive log filename=/u01/orcl_arch/1_15_847903838.dbf recid=164 stamp=847917065
deleted archive log
archive log filename=/u01/orcl_arch/1_16_847903838.dbf recid=166 stamp=847917066
deleted archive log
archive log filename=/u01/orcl_arch/1_17_847903838.dbf recid=168 stamp=847917067
deleted archive log
archive log filename=/u01/orcl_arch/1_18_847903838.dbf recid=170 stamp=847917076
deleted archive log
archive log filename=/u01/orcl_arch/1_19_847903838.dbf recid=172 stamp=847917078
deleted archive log
archive log filename=/u01/orcl_arch/1_20_847903838.dbf recid=174 stamp=847917079
deleted archive log
archive log filename=/u01/orcl_arch/1_21_847903838.dbf recid=176 stamp=847917079
deleted archive log
archive log filename=/u01/orcl_arch/1_22_847903838.dbf recid=178 stamp=847917084
deleted archive log
archive log filename=/u01/orcl_arch/1_23_847903838.dbf recid=180 stamp=847917085
deleted archive log
archive log filename=/u01/orcl_arch/1_24_847903838.dbf recid=182 stamp=847917085
deleted archive log
archive log filename=/u01/orcl_arch/1_25_847903838.dbf recid=184 stamp=847917086
deleted archive log
archive log filename=/u01/orcl_arch/1_26_847903838.dbf recid=186 stamp=847917086
deleted archive log
archive log filename=/u01/orcl_arch/1_27_847903838.dbf recid=188 stamp=847917087
deleted archive log
archive log filename=/u01/orcl_arch/1_28_847903838.dbf recid=190 stamp=847917087
deleted archive log
archive log filename=/u01/orcl_arch/1_29_847903838.dbf recid=192 stamp=847917088
deleted archive log
archive log filename=/u01/orcl_arch/1_30_847903838.dbf recid=194 stamp=847917088
deleted archive log
archive log filename=/u01/orcl_arch/1_31_847903838.dbf recid=196 stamp=847917094
Deleted 31 EXPIRED objects
刪除完畢，為了測試，重啟一下主庫：
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 71305460 bytes
Database Buffers 92274688 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
主庫重啟正常
切換主庫日誌，看備庫能否正常接收：
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
備庫檢視一下日誌接收情況：
SQL> select name,creator,sequence#,applied,completion_time from v$archived_log;
NAME CREATOR SEQUENCE# APP COMPLETIO
--------------------------------------------- ------- ---------- --- ---------
/u01/orcl_arch/1_2_847903838.dbf ARCH 2 YES 18-MAY-14
/u01/orcl_arch/1_3_847903838.dbf ARCH 3 YES 18-MAY-14
/u01/orcl_arch/1_4_847903838.dbf ARCH 4 YES 18-MAY-14
/u01/orcl_arch/1_5_847903838.dbf ARCH 5 YES 18-MAY-14
/u01/orcl_arch/1_6_847903838.dbf ARCH 6 YES 18-MAY-14
/u01/orcl_arch/1_7_847903838.dbf ARCH 7 YES 18-MAY-14
/u01/orcl_arch/1_8_847903838.dbf ARCH 8 YES 18-MAY-14
/u01/orcl_arch/1_9_847903838.dbf ARCH 9 YES 18-MAY-14
/u01/orcl_arch/1_10_847903838.dbf ARCH 10 YES 18-MAY-14
/u01/orcl_arch/1_11_847903838.dbf ARCH 11 YES 18-MAY-14
/u01/orcl_arch/1_12_847903838.dbf ARCH 12 YES 18-MAY-14
NAME CREATOR SEQUENCE# APP COMPLETIO
--------------------------------------------- ------- ---------- --- ---------
/u01/orcl_arch/1_13_847903838.dbf ARCH 13 YES 18-MAY-14
/u01/orcl_arch/1_14_847903838.dbf ARCH 14 YES 18-MAY-14
/u01/orcl_arch/1_15_847903838.dbf ARCH 15 YES 18-MAY-14
/u01/orcl_arch/1_16_847903838.dbf ARCH 16 YES 18-MAY-14
/u01/orcl_arch/1_17_847903838.dbf ARCH 17 YES 18-MAY-14
/u01/orcl_arch/1_18_847903838.dbf ARCH 18 YES 18-MAY-14
/u01/orcl_arch/1_19_847903838.dbf ARCH 19 YES 18-MAY-14
/u01/orcl_arch/1_20_847903838.dbf ARCH 20 YES 18-MAY-14
/u01/orcl_arch/1_21_847903838.dbf ARCH 21 YES 18-MAY-14
/u01/orcl_arch/1_22_847903838.dbf ARCH 22 YES 18-MAY-14
/u01/orcl_arch/1_23_847903838.dbf ARCH 23 YES 18-MAY-14
NAME CREATOR SEQUENCE# APP COMPLETIO
--------------------------------------------- ------- ---------- --- ---------
/u01/orcl_arch/1_24_847903838.dbf ARCH 24 YES 18-MAY-14
/u01/orcl_arch/1_25_847903838.dbf ARCH 25 YES 18-MAY-14
/u01/orcl_arch/1_26_847903838.dbf ARCH 26 YES 18-MAY-14
/u01/orcl_arch/1_27_847903838.dbf ARCH 27 YES 18-MAY-14
/u01/orcl_arch/1_28_847903838.dbf ARCH 28 YES 18-MAY-14
/u01/orcl_arch/1_29_847903838.dbf ARCH 29 YES 18-MAY-14
/u01/orcl_arch/1_30_847903838.dbf ARCH 30 YES 18-MAY-14
/u01/orcl_arch/1_31_847903838.dbf ARCH 31 YES 18-MAY-14
/u01/orcl_arch/1_32_847903838.dbf ARCH 32 NO 18-MAY-14
/u01/orcl_arch/1_33_847903838.dbf ARCH 33 NO 18-MAY-14
/u01/orcl_arch/1_34_847903838.dbf ARCH 34 NO 18-MAY-14
NAME CREATOR SEQUENCE# APP COMPLETIO
--------------------------------------------- ------- ---------- --- ---------
/u01/orcl_arch/1_35_847903838.dbf ARCH 35 NO 18-MAY-14
/u01/orcl_arch/1_36_847903838.dbf ARCH 36 NO 18-MAY-14
35 rows selected.
啟動REDO應用（為了演示，實驗前沒開啟REDO應用，如果你的資料庫一直開啟REDO的話，applied應該會自己置為YES）
SQL> select name,creator,sequence#,applied,completion_time from v$archived_log;
NAME CREATOR SEQUENCE# APP COMPLETIO
--------------------------------------------- ------- ---------- --- ---------
/u01/orcl_arch/1_2_847903838.dbf ARCH 2 YES 18-MAY-14
/u01/orcl_arch/1_3_847903838.dbf ARCH 3 YES 18-MAY-14
/u01/orcl_arch/1_4_847903838.dbf ARCH 4 YES 18-MAY-14
/u01/orcl_arch/1_5_847903838.dbf ARCH 5 YES 18-MAY-14
/u01/orcl_arch/1_6_847903838.dbf ARCH 6 YES 18-MAY-14
/u01/orcl_arch/1_7_847903838.dbf ARCH 7 YES 18-MAY-14
/u01/orcl_arch/1_8_847903838.dbf ARCH 8 YES 18-MAY-14
/u01/orcl_arch/1_9_847903838.dbf ARCH 9 YES 18-MAY-14
/u01/orcl_arch/1_10_847903838.dbf ARCH 10 YES 18-MAY-14
/u01/orcl_arch/1_11_847903838.dbf ARCH 11 YES 18-MAY-14
/u01/orcl_arch/1_12_847903838.dbf ARCH 12 YES 18-MAY-14
NAME CREATOR SEQUENCE# APP COMPLETIO
--------------------------------------------- ------- ---------- --- ---------
/u01/orcl_arch/1_13_847903838.dbf ARCH 13 YES 18-MAY-14
/u01/orcl_arch/1_14_847903838.dbf ARCH 14 YES 18-MAY-14
/u01/orcl_arch/1_15_847903838.dbf ARCH 15 YES 18-MAY-14
/u01/orcl_arch/1_16_847903838.dbf ARCH 16 YES 18-MAY-14
/u01/orcl_arch/1_17_847903838.dbf ARCH 17 YES 18-MAY-14
/u01/orcl_arch/1_18_847903838.dbf ARCH 18 YES 18-MAY-14
/u01/orcl_arch/1_19_847903838.dbf ARCH 19 YES 18-MAY-14
/u01/orcl_arch/1_20_847903838.dbf ARCH 20 YES 18-MAY-14
/u01/orcl_arch/1_21_847903838.dbf ARCH 21 YES 18-MAY-14
/u01/orcl_arch/1_22_847903838.dbf ARCH 22 YES 18-MAY-14
/u01/orcl_arch/1_23_847903838.dbf ARCH 23 YES 18-MAY-14
NAME CREATOR SEQUENCE# APP COMPLETIO
--------------------------------------------- ------- ---------- --- ---------
/u01/orcl_arch/1_24_847903838.dbf ARCH 24 YES 18-MAY-14
/u01/orcl_arch/1_25_847903838.dbf ARCH 25 YES 18-MAY-14
/u01/orcl_arch/1_26_847903838.dbf ARCH 26 YES 18-MAY-14
/u01/orcl_arch/1_27_847903838.dbf ARCH 27 YES 18-MAY-14
/u01/orcl_arch/1_28_847903838.dbf ARCH 28 YES 18-MAY-14
/u01/orcl_arch/1_29_847903838.dbf ARCH 29 YES 18-MAY-14
/u01/orcl_arch/1_30_847903838.dbf ARCH 30 YES 18-MAY-14
/u01/orcl_arch/1_31_847903838.dbf ARCH 31 YES 18-MAY-14
/u01/orcl_arch/1_32_847903838.dbf ARCH 32 YES 18-MAY-14
/u01/orcl_arch/1_33_847903838.dbf ARCH 33 YES 18-MAY-14
/u01/orcl_arch/1_34_847903838.dbf ARCH 34 YES 18-MAY-14
NAME CREATOR SEQUENCE# APP COMPLETIO
--------------------------------------------- ------- ---------- --- ---------
/u01/orcl_arch/1_35_847903838.dbf ARCH 35 YES 18-MAY-14
/u01/orcl_arch/1_36_847903838.dbf ARCH 36 YES 18-MAY-14
35 rows selected.
發現新的日誌已經被正確應用，DG環境無損壞。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29320885/viewspace-1163849/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 刪除DG歸檔保留5個
- DG歸檔自動刪除 & _log_deletion_policy
- rac+dg環境刪除歸檔日誌
- Oracle DG standby刪除歸檔的判斷指令碼Oracle指令碼
- 邏輯dg刪除主庫過期歸檔日誌
- 刪除歸檔物理檔案備份失敗！ORA-19625
- ORACLE刪除歸檔Oracle
- dg刪除備庫已經應用的歸檔日誌指令碼指令碼
- 強制刪除歸檔檔案
- 刪除歸檔日誌檔案
- oracle刪除歸檔日誌Oracle
- 歸檔日誌的刪除
- Rman Crosscheck刪除失效歸檔ROS
- Oracle歸檔日誌刪除Oracle
- 使用RMAN安全刪除歸檔檔案
- DG_保證歸檔日誌不能隨意被刪除的四種方法
- 刪除data guard歸檔日誌
- 手動刪除歸檔日誌
- rman 刪除所有過期歸檔
- 作用RMAN 刪除歸檔日誌
- 刪除歸檔，保留最近的5個歸檔日誌
- 歸檔日誌物理刪除後閃回恢復區空間未釋放
- 定期刪除歸檔檔案的指令碼指令碼
- Oracle刪除效率測試Oracle
- oracle rman 刪除過期的歸檔Oracle
- 生產上刪除歸檔的命令
- rman刪除指定時間的歸檔
- 恢復rm -f物理刪除資料檔案
- oracle 刪除過期的歸檔日誌Oracle
- rman刪除歸檔日誌命令集
- crontab不能自動刪除歸檔日誌
- oracle dataguard 自動刪除歸檔日誌Oracle
- 歸檔日誌刪除的五種方法
- 如何定期自動刪除歸檔日誌
- 【Oracle】 rman 刪除歸檔日誌的命令Oracle
- 【警鐘】謹慎刪除歸檔日誌
- 如何正確刪除ORACLE歸檔日誌檔案Oracle
- Oracle Data Guard 主庫歸檔檔案刪除策略Oracle