Both sides previous revisionPrevious revisionNext revision | Previous revision |
dba:oracle:logminer_mini-howto [2022/02/11 11:12] – ↷ Page moved from oracle:logminer_mini-howto to dba:oracle:logminer_mini-howto dodger | dba:oracle:howtos:logminer_mini-howto [2023/01/31 08:26] (current) – ↷ Page moved from dba:oracle:logminer_mini-howto to dba:oracle:howtos:logminer_mini-howto dodger |
---|
GROUP# STATUS TYPE MEMBER IS_RECOVE | GROUP# STATUS TYPE MEMBER IS_RECOVE |
------------ -------- -------- ------------------------------------------------------------ --------- | ------------ -------- -------- ------------------------------------------------------------ --------- |
8 ONLINE +DG_VXLPRE_DATA/voxelpre/onlinelog/group_8.313.785158951 NO | 8 ONLINE +DG_VXLPRE_DATA/ciberterminalpre/onlinelog/group_8.313.785158951 NO |
8 ONLINE +DG_VXLPRE_FRA/voxelpre/onlinelog/group_8.7459.785158955 YES | 8 ONLINE +DG_VXLPRE_FRA/ciberterminalpre/onlinelog/group_8.7459.785158955 YES |
7 ONLINE +DG_VXLPRE_DATA/voxelpre/onlinelog/group_7.312.785158943 NO | 7 ONLINE +DG_VXLPRE_DATA/ciberterminalpre/onlinelog/group_7.312.785158943 NO |
7 ONLINE +DG_VXLPRE_FRA/voxelpre/onlinelog/group_7.7446.785158947 YES | 7 ONLINE +DG_VXLPRE_FRA/ciberterminalpre/onlinelog/group_7.7446.785158947 YES |
6 ONLINE +DG_VXLPRE_DATA/voxelpre/onlinelog/group_6.311.785158933 NO | 6 ONLINE +DG_VXLPRE_DATA/ciberterminalpre/onlinelog/group_6.311.785158933 NO |
6 ONLINE +DG_VXLPRE_FRA/voxelpre/onlinelog/group_6.7429.785158937 YES | 6 ONLINE +DG_VXLPRE_FRA/ciberterminalpre/onlinelog/group_6.7429.785158937 YES |
5 ONLINE +DG_VXLPRE_DATA/voxelpre/onlinelog/group_5.310.785158925 NO | 5 ONLINE +DG_VXLPRE_DATA/ciberterminalpre/onlinelog/group_5.310.785158925 NO |
5 ONLINE +DG_VXLPRE_FRA/voxelpre/onlinelog/group_5.7444.785158929 YES | 5 ONLINE +DG_VXLPRE_FRA/ciberterminalpre/onlinelog/group_5.7444.785158929 YES |
4 ONLINE +DG_VXLPRE_DATA/voxelpre/onlinelog/group_4.309.785158915 NO | 4 ONLINE +DG_VXLPRE_DATA/ciberterminalpre/onlinelog/group_4.309.785158915 NO |
4 ONLINE +DG_VXLPRE_FRA/voxelpre/onlinelog/group_4.7440.785158919 YES | 4 ONLINE +DG_VXLPRE_FRA/ciberterminalpre/onlinelog/group_4.7440.785158919 YES |
3 ONLINE +DG_VXLPRE_DATA/voxelpre/onlinelog/group_3.308.785158905 NO | 3 ONLINE +DG_VXLPRE_DATA/ciberterminalpre/onlinelog/group_3.308.785158905 NO |
3 ONLINE +DG_VXLPRE_FRA/voxelpre/onlinelog/group_3.7478.785158911 YES | 3 ONLINE +DG_VXLPRE_FRA/ciberterminalpre/onlinelog/group_3.7478.785158911 YES |
2 ONLINE +DG_VXLPRE_DATA/voxelpre/onlinelog/group_2.307.785158895 NO | 2 ONLINE +DG_VXLPRE_DATA/ciberterminalpre/onlinelog/group_2.307.785158895 NO |
2 ONLINE +DG_VXLPRE_FRA/voxelpre/onlinelog/group_2.7465.785158903 YES | 2 ONLINE +DG_VXLPRE_FRA/ciberterminalpre/onlinelog/group_2.7465.785158903 YES |
1 ONLINE +DG_VXLPRE_DATA/voxelpre/onlinelog/group_1.306.785158857 NO | 1 ONLINE +DG_VXLPRE_DATA/ciberterminalpre/onlinelog/group_1.306.785158857 NO |
1 ONLINE +DG_VXLPRE_FRA/voxelpre/onlinelog/group_1.7474.785158885 YES | 1 ONLINE +DG_VXLPRE_FRA/ciberterminalpre/onlinelog/group_1.7474.785158885 YES |
</code> | </code> |
| |
<code> | <code> |
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( - | EXECUTE DBMS_LOGMNR.ADD_LOGFILE( - |
LogFileName => '+DG_VXLPRE_DATA/voxelpre/onlinelog/group_8.313.785158951', - | LogFileName => '+DG_VXLPRE_DATA/ciberterminalpre/onlinelog/group_8.313.785158951', - |
Options => dbms_logmnr.NEW); | Options => dbms_logmnr.NEW); |
</code> | </code> |
<code> | <code> |
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( - | EXECUTE DBMS_LOGMNR.ADD_LOGFILE( - |
LogFileName => '+DG_VXLPRE_FRA/voxelpre/onlinelog/group_8.7459.785158955', - | LogFileName => '+DG_VXLPRE_FRA/ciberterminalpre/onlinelog/group_8.7459.785158955', - |
Options => dbms_logmnr.ADDFILE ) ; | Options => dbms_logmnr.ADDFILE ) ; |
</code> | </code> |