alter session set container_name=PDB_NAME;alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';set lines 200 pages 999col name for a80col completion_time for a20select thread#,name,completion_time  from v$archived_log where completion_time >TO_DATE('2022-03-03 02:00:00','YYYY-MM-DD HH24:MI:SS')and completion_time <TO_DATE('2022-03-03 22:00:00','YYYY-MM-DD HH24:MI:SS') order by completion_time;

ALTER SESSION SET CONTAINER=cdb$root;BEGIN   sys.DBMS_LOGMNR.    add_logfile (      logfilename   => '+DG/XXXCDB/ARCHIVELOG/2022_03_03/thread_2_seq_21.332.1098327611',      options       => sys.DBMS_LOGMNR.addfile);   sys.DBMS_LOGMNR.    add_logfile (      logfilename   => '+DG/XXXCDB/ARCHIVELOG/2022_03_03/thread_1_seq_53.333.1098388821',      options       => sys.DBMS_LOGMNR.addfile);END;/ BEGIN   sys.DBMS_LOGMNR.    start_logmnr (options => sys.DBMS_LOGMNR.dict_from_online_catalog);END;/

# 如分析含有create的DDL语句set lines 2000set pages 999col sql_redo for a50col MACHINE_NAME for a15col USERNAME for a15col TABLE_NAME for a20col SEG_OWNER for a15col exec_time for a20 SELECT sql_redo,       TO_CHAR (TIMESTAMP, 'yyyymmdd hh24:mi:ss') exec_time,       SEG_OWNER,       TABLE_NAME,       USERNAME,       MACHINE_NAME,       con_id  FROM v$logmnr_contents WHERE OPERATION = 'DDL' AND sql_redo LIKE '%create %';

BEGIN   sys.DBMS_LOGMNR.end_logmnr;END;/