time base 불완전복구 employees sql 쿼리

[21기_남준혁]

EXEC DBMS_LOGMNR.ADD_LOGFILE(   
          logfilename => '+DATA/RACDB/ONLINELOG/group_1.267.1215872115',
         options     => DBMS_LOGMNR.NEW);

--

혹은

EXEC DBMS_LOGMNR.ADD_LOGFILE(
  LOGFILENAME => '+DATA/RACDB/ONLINELOG/group_ 1.267.1215872115',
  OPTIONS     => DBMS_LOGMNR.ADDFILE);

--

EXEC DBMS_LOGMNR.START_LOGMNR(dictfilename => '/home/oracle/miner/dir_file');

SELECT timestamp, username, sql_redo
     FROM   v$logmnr_contents
     WHERE  sql_redo LIKE '%EMPLOYEES%';
     
select timestamp_to_scn(to_timestamp('2025/10/30 14:47:13','RRRR/MM/DD:HH24:MI:SS')) from dual;