注册

LOGMNR第二次增加归档文件报错

董小姐 2023/11/24 530 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:

SQL> SELECT NAME,FIRST_TIME,NEXT_TIME,FIRST_CHANGE#,NEXT_CHANGE# FROM V$ARCHIVED_LOG;

LINEID     NAME                                                                FIRST_TIME                 NEXT_TIME                  FIRST_CHANGE#        NEXT_CHANGE#        
---------- ------------------------------------------------------------------- -------------------------- -------------------------- -------------------- --------------------
1          /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-52-16.log 2023-11-23 15:52:16.296368 2023-11-23 15:57:27.566010 41089                41437
2          /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-57-36.log 2023-11-23 15:57:36.203305 2023-11-23 15:57:36.203305 41438                42312

used time: 1.333(ms). Execute id is 1085.
SQL> DBMS_LOGMNR.ADD_LOGFILE('/dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-57-36.log');
DMSQL executed successfully
used time: 4.207(ms). Execute id is 1086.
SQL> SELECT LOW_SCN, NEXT_SCN, LOW_TIME, HIGH_TIME, LOG_ID, FILENAME FROM V$LOGMNR_LOGS;

LINEID     LOW_SCN              NEXT_SCN             LOW_TIME                   HIGH_TIME                  LOG_ID      FILENAME                                                           
---------- -------------------- -------------------- -------------------------- -------------------------- ----------- -------------------------------------------------------------------
1          41438                42312                1900-01-01 00:00:00.000000 1900-01-01 00:00:00.000000 0           /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-57-36.log

used time: 1.140(ms). Execute id is 1087.
SQL> checkpoint;
checkpoint;
[-2207]:Error in line: 1
Member access [checkpoint] unresolved.
used time: 0.256(ms). Execute id is 0.
SQL> alter system switchlogfile;
alter system switchlogfile;

alter system switchlogfile;
            *              
line 1, column 13, nearby [switchlogfile] has error[-2007]:
Syntax error.
used time: 0.124(ms). Execute id is 0.
SQL> alter system switchlog;
alter system switchlog;

alter system switchlog;
            *          
line 1, column 13, nearby [switchlog] has error[-2007]:
Syntax error.
used time: 0.199(ms). Execute id is 0.
SQL> alter system switch logfile;
executed successfully
used time: 1.078(ms). Execute id is 0.
SQL> SELECT LOW_SCN, NEXT_SCN, LOW_TIME, HIGH_TIME, LOG_ID, FILENAME FROM V$LOGMNR_LOGS;

LINEID     LOW_SCN              NEXT_SCN             LOW_TIME                   HIGH_TIME                  LOG_ID      FILENAME                                                           
---------- -------------------- -------------------- -------------------------- -------------------------- ----------- -------------------------------------------------------------------
1          41438                42312                1900-01-01 00:00:00.000000 1900-01-01 00:00:00.000000 0           /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-57-36.log

used time: 0.296(ms). Execute id is 1088.
SQL> SELECT NAME,FIRST_TIME,NEXT_TIME,FIRST_CHANGE#,NEXT_CHANGE# FROM V$ARCHIVED_LOG;

LINEID     NAME                                                                FIRST_TIME                 NEXT_TIME                  FIRST_CHANGE#        NEXT_CHANGE#        
---------- ------------------------------------------------------------------- -------------------------- -------------------------- -------------------- --------------------
1          /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-52-16.log 2023-11-23 15:52:16.296368 2023-11-23 15:57:27.566010 41089                41437
2          /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-57-36.log 2023-11-23 15:57:36.203305 2023-11-24 09:16:28.113272 41438                42312

used time: 0.791(ms). Execute id is 1089.
SQL> DBMS_LOGMNR.ADD_LOGFILE('/dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-57-36.log');
DBMS_LOGMNR.ADD_LOGFILE('/dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-57-36.log');
[-2848]:cannot add duplicate logfile
-2848: DBMS_LOGMNR.add_logfile line 22 .
used time: 0.452(ms). Execute id is 0.
SQL> DBMS_LOGMNR.END_LOGMNR();
DBMS_LOGMNR.END_LOGMNR();
[-2846]:no LogMiner session is currently active
-2846: DBMS_LOGMNR.end_logmnr line 43 .
used time: 0.513(ms). Execute id is 0.
SQL> SELECT NAME,FIRST_TIME,NEXT_TIME,FIRST_CHANGE#,NEXT_CHANGE# FROM V$ARCHIVED_LOG;

LINEID     NAME                                                                FIRST_TIME                 NEXT_TIME                  FIRST_CHANGE#        NEXT_CHANGE#        
---------- ------------------------------------------------------------------- -------------------------- -------------------------- -------------------- --------------------
1          /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-52-16.log 2023-11-23 15:52:16.296368 2023-11-23 15:57:27.566010 41089                41437
2          /dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-57-36.log 2023-11-23 15:57:36.203305 2023-11-24 09:16:28.113272 41438                42312

used time: 0.448(ms). Execute id is 1092.
SQL> DBMS_LOGMNR.ADD_LOGFILE('/dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-57-36.log');
DBMS_LOGMNR.ADD_LOGFILE('/dmdb8/dmarch/ARCHIVE_LOCAL1_0x482D9BC8_EP0_2023-11-23_15-57-36.log');
[-2848]:cannot add duplicate logfile
-2848: DBMS_LOGMNR.add_logfile line 22 .
used time: 0.333(ms). Execute id is 0.

回答 0
暂无回答
扫一扫
联系客服