ITPub博客

首页 > 数据库 > Oracle > 物理DG删除归档测试

物理DG删除归档测试

原创 Oracle 作者:静以致远√团团 时间:2014-05-18 21:52:31 0 删除 编辑

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

请登录后发表评论 登录
全部评论
每个人都有梦想,去实现吧!

注册时间:2013-11-14

  • 博文量
    164
  • 访问量
    2103578