物理DG删除归档测试

最新推荐文章于 2021-04-13 06:33:19 发布
最新推荐文章于 2021-04-13 06:33:19 发布
阅读量143 收藏
点赞数
文章标签： 数据库 操作系统

备库上查看归档日志的应用情况：（显示是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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29320885/viewspace-1163849/

csi83845
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle Data Guard （RAC+DG) 归档删除策略及脚本
Paladin的专栏
07-08 1695
此次备库的归档删除策略是在单机版的基础上进行升级，增加了日志功能，支持对2个节点RAC主库的归档文件在备库上删除的功能，可以作为计划任务执行也可以以交互的形式单独执行。 由于备库一般不执行rman备份计划，所以需要脚本删除这些归档日志文件。
Oracle DG主备库删除归档脚本
12-04
Oracle DG主备库删除归档脚本,包含了脚步使用说明
ORACLE 11G 单实例 磁盘文件系统 DG 归档日志删除脚本 基于RED HAT LINUX 5.3 X86 64BIT
海鲨MYSQL精英架构师
05-07 3035
最近做个DG的归档日志删除,[oracle@.local logs]crontab -l * 8 * * * sh /home/oracle/dbscripts/del_arc.sh 该脚本分别调用 生成 删除 校验 三个脚本cat del_arc.sh #! /bin/bash source /home/oracle/.bash_profile sh /home/oracle/dbscrip
DG归档自动删除 & _log_deletion_policy
cti27515的博客
06-08 390
11g以前，主库配置了CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY但是指向备库的归档路径不是mandatory的，那么主库不会自动删除已经在备库应...
DG环境定时删除主备库归档日志方法
cm_0205的博客
11-30 1858
在DG主备库都执行该策略，原则上只有主库需要，但如果主备切换备库转为主库也同样需要修改。 RMAN>show all; --查看到原策略是NONE CONFIGURE ARCHIVELOG DELETION POL...
物理DG部署.pdf
10-24
Oracle DG搭建文档。
Oracle11g搭建物理DG.docx|Oracle11g搭建物理DG.docx
11-11
在Oracle 11g中，物理DG是一种复制方法，通过实时地传输和应用生产数据库的日志到一个或多个备用数据库，使得备用数据库与主库保持几乎同步的状态。这样，当生产数据库遇到故障时，可以通过快速切换到备用数据库来...
win平台oracle rman备份和删除dg备库归档日志脚本
09-10
本文将详细讲解如何在Windows上使用RMAN进行数据库备份以及删除DG（Data Guard）备库的归档日志。 首先，我们来看RMAN备份脚本`backup_oracle.bat`。这个脚本主要分为两部分：定义配置和执行备份操作。`CONFIGURE`...
完整的Oracle12C物理DG搭建.pdf
10-14
Oracle 12C 物理 DG 搭建 本文档旨在指导读者如何搭建一个完整的 Oracle 12C 物理 DG（Data Guard），从安装备库 Oracle 软件到配置 Oracle 用户的环境变量。下面是详细的知识点： 1. 安装备库 Oracle 软件 在...
oracle dg 删除归档,ORACLE 11G 单范例 磁盘文件系统 DG 归档日志删除脚本 基于RED HAT LINUX 5.3 X86 64BIT...
weixin_29109553的博客
04-13 155
ORACLE 11G 单实例 磁盘文件系统 DG 归档日志删除脚本 基于RED HAT LINUX 5.3 X86 64BIT最近做个DG的归档日志删除,[oracle@.local logs]crontab -l* 8 * * * sh /home/oracle/dbscripts/del_arc.sh该脚本分别调用 生成 删除 校验 三个脚本cat del_arc.sh#! /bin/bash...
Windows DG环境中ORACLE 自动清理归档
袁子建
06-10 472
DG环境中对归档日志的要求不同于普通环境，自动清理的目标应该是那些已经被正常应用的备库的归档日志。 center.bat--总的调度中心，设置环境变量，调用其他脚本 @echooff echo================================================ echoWindows环境下Oracle数据库的自动清理归档脚...
oracle dg 删除备库已经应用或的归档日志
袁子建
06-08 2115
#!/bin/sh #Create_time:2019.11.27 #Author: #Description:DeletethearchivedlogsonStandbywhichhadbeenapplied #Usage: #Lastmodify:2019.11.27 #Note: #InitialParameters _SCRIPT...
oracle dg 删除归档,简单DG归档日志删除脚本
weixin_31207903的博客
04-13 1081
最近在摆弄DG，由于磁盘资源紧缺，需要一个归档日志处理的策略网上找了几个脚本，发现写的那么麻烦毛了，于是简单写了一个，实际路径等可以自己在修改主库备库都可以用，自己再做crontab就好，建议错开时间进行需要注意，提前查询DEST_ID，下面这个是主库删除的脚本(备库只需更改dest_id即可)，我的主库v$archived_log里，主库的归档dest_id=1,备库是dest_id=21. ...
RAMAN正确删除归档日志方法
weixin_30467087的博客
12-24 413
如何正确地删除Archivelog： Archivelog并不能直接得从OS层直接物理删除，因为archivelog的相关信息是记录在controlfile中的，当物理删除后不会改变controlfile的设置。并且在查询相关的动态视图(例如v$archived_log)时，该部分日志仍然标注为存在。也就是说Oracle并不认为这些日志被删除了，所以在删除archivelog的时...
DG上RMAN归档删除策略及with warnings
文档搬运工
03-20 1833
在备库上查询，发现日志没有被应用SYS@test_stdby>select sequence#,applied from v$archived_log order by sequence#; SEQUENCE# APPLIED ---------- --------- 19 YES 20 YES 21 YES 22 YES 23 YES 24 YES 25 YES 26 ...
dg修改归档目录 oracle_如何修改DG的主库删除归档策略！
weixin_32903229的博客
01-17 533
在DG的生产环境中，主备库的归档删除策略是一定要配置的，oracle并不会主动删除归档日志，所以需要在搭建DG之后，修改相应的配置，但需要注意的是，在最大可用(maximum availability)和最大性能(maximum performance)两种模式下，必须要在归档文件在备库应用后才可以删除。针对最大保护(maximum protection)模式下，因为这种模式是同时写到主库和备库的...
Oracle 11g Data Guard环境中的归档管理
weiwang的专栏
08-01 1032
Oracle 11g Data Guard环境中的归档管理 在11g里面，随着ASM、RAC、Data Guard（包括Active Data Guard）的成熟，使用RAC+ASM+Data Guard越来越成为一种可靠的、维护简单、稳定的高可用性和容灾保护方案。这篇文章谈谈如何管理Oracle 11g Data Guard环境中的归档日志。 归档日志是重要的，不然就不必提到这篇文章，备
定期删除DG归档日志的脚本
e_ant的专栏
04-13 514
定期删除DG归档日志的脚本· 作者 小荷||【转载时请务必以超链接形式标明文章原始出处和作者信息】 · 永久链接: http://www.oracleblog.cn/useful-script/shell-for-delete-standby-arch/ ----------------------------------------------------------------...
dg删除备库已经应用的归档日志脚本
cpc84938的博客
08-30 700
#!/bin/bash #by ray #2017-08-30 #v0.1 . ~/.bash_profile #get sequen...
物理dg和逻辑dg的区别
最新发布
06-06
物理DG和逻辑DG都是指Directed Graphs（有向图）。 物理DG是指实际存在的图形，如电路图、道路网络、社交网络等。物理DG的节点和边都有具体的物理含义，它们之间的连通性是由物理因素所决定的。 逻辑DG是指概念上...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值