为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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.
看了下你的操作,你第二次添加的这个归档,和你前一次添加的归档是同一个文件,也就是说,这个归档你已经添加过了,不能重复添加,要先执行移除日志文件的命令
然后再添加