During the datapump import job in the database, got an error in alert log
Issue :-
1. Check the alert log:
2019-12-10T02:20:21.150375-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 202468352 bytes disk space from 10009706496 bytes limit
ARC1: Error 19809 Creating archive log file to 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_%U_.ARC'
2019-12-10T02:20:21.416377-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc2_1992.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 10009706496 bytes is 100.00% used, and has 0 remaining bytes available.
2019-12-10T02:20:21.416377-08:00
2.
There is no space in db_recovery_file_dest_size. He cannot extend it more as he has already extended it.
RMAN>select * from v$flash_recovery_area_usage;
RMAN>crosscheck archivelog all;
RMAN>delete expired archivelog all;
RMAN> list expired archivelog all;
RMAN>DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
RMAN> delete archivelog all;
3. Check the alert log
2019-12-10T02:20:21.416377-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc2_1992.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 202476032 bytes disk space from 10009706496 bytes limit
ARC2: Error 19809 Creating archive log file to 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_52_%U_.ARC'
2019-12-10T02:20:25.759706-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T02:20:25.759706-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYWC5F0_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYWC5F0_.ARC
2019-12-10T02:20:26.322995-08:00
Deleted file C:\APP\ORACLE\PRODUCT\12.2.0\DBHOME_1\RDBMS\REACT_TEST_3339D01C.ARC
2019-12-10T02:20:41.166087-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T02:20:41.166087-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYWCBHY_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYWCBHY_.ARC
2019-12-10T02:20:44.541408-08:00
4.
Clear the redo log files having issue due to power failure or unclean shutdown of database
SQL> SELECT * FROM V$LOG;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------------- ------------- --------- ------------ --------- ----------
1 1 61 209715200 512 1 YES
ACTIVE 1691153 10-DEC-19 1711124 10-DEC-19 0
2 1 62 209715200 512 1 NO
CURRENT 1711124 10-DEC-19 1.8447E+19 0
3 1 24 209715200 512 1 NO
INACTIVE 1650895 09-DEC-19 1651256 09-DEC-19 0
SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
Database altered.
SQL> SELECT * FROM V$LOG;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------------- ------------- --------- ------------ --------- ----------
1 1 0 209715200 512 1 YES
UNUSED 1691153 10-DEC-19 1711124 10-DEC-19 0
2 1 62 209715200 512 1 NO
CURRENT 1711124 10-DEC-19 1.8447E+19 0
3 1 24 209715200 512 1 NO
INACTIVE 1650895 09-DEC-19 1651256 09-DEC-19 0
SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
Database altered.
SQL> SELECT * FROM V$LOG;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------------- ------------- --------- ------------ --------- ----------
1 1 63 209715200 512 1 NO
CURRENT 1720939 10-DEC-19 1.8447E+19 0
2 1 0 209715200 512 1 YES
UNUSED 1711124 10-DEC-19 1720939 10-DEC-19 0
3 1 24 209715200 512 1 NO
INACTIVE 1650895 09-DEC-19 1651256 09-DEC-19 0
SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Database altered.
SQL> SELECT * FROM V$LOG;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID
---------------- ------------- --------- ------------ --------- ----------
1 1 63 209715200 512 1 YES
INACTIVE 1720939 10-DEC-19 1721180 10-DEC-19 0
2 1 64 209715200 512 1 NO
ACTIVE 1721180 10-DEC-19 1722867 10-DEC-19 0
3 1 65 209715200 512 1 NO
CURRENT 1722867 10-DEC-19 1.8447E+19 0
SQL>
5.
The alert log files showed this
ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ8KXM_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ8KXM_.ARC
2019-12-10T03:10:18.432542-08:00
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
2019-12-10T03:10:27.775964-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:10:27.775964-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ8RHG_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ8RHG_.ARC
2019-12-10T03:10:28.213479-08:00
Clearing online log 1 of thread 1 sequence number 61
2019-12-10T03:10:41.417428-08:00
Completed: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
2019-12-10T03:10:44.573227-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:10:44.573227-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ96MW_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ96MW_.ARC
2019-12-10T03:10:45.088707-08:00
Deleted file C:\APP\ORACLE\PRODUCT\12.2.0\DBHOME_1\RDBMS\REACT_TEST_3339D01C.ARC
2019-12-10T03:10:49.697689-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:10:49.697689-08:00
ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ9OHG_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ9OHG_.ARC
2019-12-10T03:10:53.854743-08:00
Thread 1 cannot allocate new log, sequence 63
Private strand flush not complete
Current log# 2 seq# 62 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO02.LOG
2019-12-10T03:10:56.838529-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:10:56.838529-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ9TQR_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZ9TQR_.ARC
2019-12-10T03:10:57.353847-08:00
Thread 1 advanced to log sequence 63 (LGWR switch)
Current log# 1 seq# 63 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO01.LOG
2019-12-10T03:11:09.745125-08:00
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2
2019-12-10T03:11:10.198201-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:11:10.198201-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZB20B_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZB20B_.ARC
2019-12-10T03:11:19.400551-08:00
WARNING! CLEARING REDO LOG WHICH HAS NOT BEEN ARCHIVED. BACKUPS TAKEN
BEFORE 12/10/2019 03:10:57 (CHANGE 1720939) CANNOT BE USED FOR RECOVERY.
Clearing online log 2 of thread 1 sequence number 62
2019-12-10T03:11:22.369535-08:00
ARC2: Log 2 mismatch, expected sequence 62 found T-1.S-0
2019-12-10T03:11:25.291800-08:00
Resize operation completed for file# 9, old size 13915072K, new size 13980608K
2019-12-10T03:11:27.197839-08:00
Resize operation completed for file# 201, old size 110592K, new size 111616K
2019-12-10T03:11:34.729530-08:00
Resize operation completed for file# 201, old size 111616K, new size 112640K
2019-12-10T03:11:38.056820-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:11:38.056820-08:00
ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZBRF1_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZBRF1_.ARC
2019-12-10T03:11:38.510755-08:00
Completed: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2
2019-12-10T03:11:38.525518-08:00
Resize operation completed for file# 201, old size 112640K, new size 113664K
2019-12-10T03:11:39.229419-08:00
Resize operation completed for file# 9, old size 13980608K, new size 14046144K
2019-12-10T03:11:42.432593-08:00
Resize operation completed for file# 9, old size 14046144K, new size 14111680K
2019-12-10T03:11:44.713119-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc2_1992.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:11:44.713119-08:00
ARC2: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCC9M_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCC9M_.ARC
2019-12-10T03:11:45.777131-08:00
Deleted file C:\APP\ORACLE\PRODUCT\12.2.0\DBHOME_1\RDBMS\REACT_TEST_3339D01C.ARC
2019-12-10T03:11:52.135063-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:11:52.135063-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCL8M_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCL8M_.ARC
2019-12-10T03:11:57.978651-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:11:57.978651-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCSLD_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCSLD_.ARC
2019-12-10T03:12:02.932461-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc2_1992.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:02.932461-08:00
ARC2: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCZ5P_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZCZ5P_.ARC
2019-12-10T03:12:11.088332-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:11.088332-08:00
ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZD47O_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZD47O_.ARC
2019-12-10T03:12:17.620212-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:17.620212-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDD09_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDD09_.ARC
2019-12-10T03:12:26.963343-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:26.963343-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDMPB_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDMPB_.ARC
2019-12-10T03:12:34.713728-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc2_1992.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:34.713728-08:00
ARC2: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDWDK_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZDWDK_.ARC
2019-12-10T03:12:39.463415-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:39.463415-08:00
ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZF35O_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZF35O_.ARC
2019-12-10T03:12:46.713674-08:00
Thread 1 advanced to log sequence 64 (LGWR switch)
Current log# 2 seq# 64 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO02.LOG
2019-12-10T03:12:47.619886-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:12:47.619886-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZF85P_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZF85P_.ARC
2019-12-10T03:12:47.948187-08:00
Deleted file C:\APP\ORACLE\PRODUCT\12.2.0\DBHOME_1\RDBMS\REACT_TEST_3339D01C.ARC
2019-12-10T03:13:04.510268-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc1_800.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:13:04.510268-08:00
ARC1: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZFSG0_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZFSG0_.ARC
2019-12-10T03:13:10.619983-08:00
Archived Log entry 62 added for T-1.S-63 ID 0x3339731c LAD:1
2019-12-10T03:13:17.556869-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc0_1500.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:13:17.556869-08:00
ARC0: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZG6WN_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZG6WN_.ARC
2019-12-10T03:13:18.447372-08:00
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3
2019-12-10T03:13:23.291905-08:00
WARNING! CLEARING REDO LOG WHICH HAS NOT BEEN ARCHIVED. BACKUPS TAKEN
BEFORE 12/09/2019 21:55:07 (CHANGE 1651256) CANNOT BE USED FOR RECOVERY.
Clearing online log 3 of thread 1 sequence number 24
2019-12-10T03:13:25.416820-08:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcllrde\orcllrde\trace\orcllrde_arc3_908.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 24 block 254424
ORA-00312: online log 3 thread 1: 'C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG'
2019-12-10T03:13:25.416820-08:00
ARC3: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZGG56_.ARC' (error 742)
Deleted Oracle managed file C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\ARCHIVELOG\2019_12_10\O1_MF_1_24_GYYZGG56_.ARC
ARC3: Log 3 mismatch, expected sequence 24 found T-1.S-0
2019-12-10T03:13:42.182171-08:00
Completed: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3
2019-12-10T03:13:48.104281-08:00
Deleted file C:\APP\ORACLE\PRODUCT\12.2.0\DBHOME_1\RDBMS\REACT_TEST_3339D01C.ARC
krsd_check_stuck_arch: stuck archiver condition cleared
2019-12-10T03:13:57.198035-08:00
Thread 1 advanced to log sequence 65 (LGWR switch)
Current log# 3 seq# 65 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG
2019-12-10T03:14:14.385493-08:00
Archived Log entry 64 added for T-1.S-64 ID 0x3339731c LAD:1
2019-12-10T03:16:30.276361-08:00
Thread 1 advanced to log sequence 66 (LGWR switch)
Current log# 1 seq# 66 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO01.LOG
2019-12-10T03:16:49.463925-08:00
Archived Log entry 65 added for T-1.S-65 ID 0x3339731c LAD:1
2019-12-10T03:16:52.510273-08:00
Resize operation completed for file# 9, old size 14111680K, new size 14119872K
2019-12-10T03:16:53.619613-08:00
Resize operation completed for file# 9, old size 14119872K, new size 14185408K
2019-12-10T03:16:54.886085-08:00
Resize operation completed for file# 9, old size 14185408K, new size 14250944K
2019-12-10T03:16:56.275849-08:00
Resize operation completed for file# 9, old size 14250944K, new size 14316480K
2019-12-10T03:16:57.635433-08:00
Resize operation completed for file# 9, old size 14316480K, new size 14382016K
2019-12-10T03:16:58.713797-08:00
Resize operation completed for file# 9, old size 14382016K, new size 14447552K
2019-12-10T03:17:00.400782-08:00
Resize operation completed for file# 9, old size 14447552K, new size 14513088K
2019-12-10T03:17:01.824416-08:00
Resize operation completed for file# 9, old size 14513088K, new size 14578624K
2019-12-10T03:17:03.306924-08:00
Resize operation completed for file# 9, old size 14578624K, new size 14644160K
Resize operation completed for file# 9, old size 14644160K, new size 14709696K
2019-12-10T03:17:05.494588-08:00
Resize operation completed for file# 9, old size 14709696K, new size 14775232K
2019-12-10T03:17:06.635738-08:00
Resize operation completed for file# 9, old size 14775232K, new size 14840768K
2019-12-10T03:17:20.182022-08:00
Starting control autobackup
2019-12-10T03:17:24.744426-08:00
Control autobackup written to DISK device
handle 'C:\APP\ORACLE\FAST_RECOVERY_AREA\ORCLLRDE\ORCLLRDE\AUTOBACKUP\2019_12_10\O1_MF_S_1026616640_GYYZP3R8_.BKP'
2019-12-10T03:17:46.166232-08:00
Thread 1 advanced to log sequence 67 (LGWR switch)
Current log# 2 seq# 67 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO02.LOG
2019-12-10T03:17:47.229675-08:00
The value (163) of MAXTRANS parameter ignored.
The value (163) of MAXTRANS parameter ignored.
2019-12-10T03:17:57.745105-08:00
Archived Log entry 66 added for T-1.S-66 ID 0x3339731c LAD:1
2019-12-10T03:18:41.073644-08:00
Resize operation completed for file# 201, old size 113664K, new size 114688K
Resize operation completed for file# 201, old size 114688K, new size 115712K
Resize operation completed for file# 201, old size 115712K, new size 116736K
Resize operation completed for file# 201, old size 116736K, new size 117760K
Resize operation completed for file# 201, old size 117760K, new size 118784K
Resize operation completed for file# 201, old size 118784K, new size 119808K
Resize operation completed for file# 201, old size 119808K, new size 120832K
Resize operation completed for file# 201, old size 120832K, new size 121856K
Resize operation completed for file# 201, old size 121856K, new size 122880K
2019-12-10T03:18:42.197839-08:00
Resize operation completed for file# 201, old size 122880K, new size 123904K
Resize operation completed for file# 201, old size 123904K, new size 124928K
Resize operation completed for file# 201, old size 124928K, new size 125952K
Resize operation completed for file# 201, old size 125952K, new size 126976K
Resize operation completed for file# 201, old size 126976K, new size 128000K
Resize operation completed for file# 201, old size 128000K, new size 129024K
Resize operation completed for file# 201, old size 129024K, new size 130048K
Resize operation completed for file# 201, old size 130048K, new size 131072K
Resize operation completed for file# 201, old size 131072K, new size 132096K
Resize operation completed for file# 201, old size 132096K, new size 133120K
Resize operation completed for file# 201, old size 133120K, new size 134144K
Resize operation completed for file# 201, old size 134144K, new size 135168K
Resize operation completed for file# 201, old size 135168K, new size 136192K
Resize operation completed for file# 201, old size 136192K, new size 137216K
2019-12-10T03:18:43.307514-08:00
Resize operation completed for file# 201, old size 137216K, new size 138240K
Resize operation completed for file# 201, old size 138240K, new size 139264K
Resize operation completed for file# 201, old size 139264K, new size 140288K
Resize operation completed for file# 201, old size 140288K, new size 141312K
Resize operation completed for file# 201, old size 141312K, new size 142336K
Resize operation completed for file# 201, old size 142336K, new size 143360K
2019-12-10T03:18:44.338653-08:00
Resize operation completed for file# 201, old size 143360K, new size 144384K
Resize operation completed for file# 201, old size 144384K, new size 145408K
Resize operation completed for file# 201, old size 145408K, new size 146432K
Resize operation completed for file# 201, old size 146432K, new size 147456K
Resize operation completed for file# 201, old size 147456K, new size 148480K
Resize operation completed for file# 201, old size 148480K, new size 149504K
Resize operation completed for file# 201, old size 149504K, new size 150528K
Resize operation completed for file# 201, old size 150528K, new size 151552K
Resize operation completed for file# 201, old size 151552K, new size 152576K
Resize operation completed for file# 201, old size 152576K, new size 153600K
Resize operation completed for file# 201, old size 153600K, new size 154624K
Resize operation completed for file# 201, old size 154624K, new size 155648K
2019-12-10T03:18:46.870284-08:00
Thread 1 advanced to log sequence 68 (LGWR switch)
Current log# 3 seq# 68 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO03.LOG
2019-12-10T03:19:00.353989-08:00
Archived Log entry 67 added for T-1.S-67 ID 0x3339731c LAD:1
2019-12-10T03:19:22.354183-08:00
Resize operation completed for file# 201, old size 155648K, new size 156672K
Resize operation completed for file# 201, old size 156672K, new size 157696K
Resize operation completed for file# 201, old size 157696K, new size 158720K
Resize operation completed for file# 201, old size 158720K, new size 159744K
Resize operation completed for file# 201, old size 159744K, new size 160768K
Resize operation completed for file# 201, old size 160768K, new size 161792K
Resize operation completed for file# 201, old size 161792K, new size 162816K
Resize operation completed for file# 201, old size 162816K, new size 163840K
Resize operation completed for file# 201, old size 163840K, new size 164864K
Resize operation completed for file# 201, old size 164864K, new size 165888K
Resize operation completed for file# 201, old size 165888K, new size 166912K
Resize operation completed for file# 201, old size 166912K, new size 167936K
Resize operation completed for file# 201, old size 167936K, new size 168960K
Resize operation completed for file# 201, old size 168960K, new size 169984K
Resize operation completed for file# 201, old size 169984K, new size 171008K
Resize operation completed for file# 201, old size 171008K, new size 172032K
Resize operation completed for file# 201, old size 172032K, new size 173056K
Resize operation completed for file# 201, old size 173056K, new size 174080K
Resize operation completed for file# 201, old size 174080K, new size 175104K
Resize operation completed for file# 201, old size 175104K, new size 176128K
Resize operation completed for file# 201, old size 176128K, new size 177152K
2019-12-10T03:19:23.385545-08:00
Resize operation completed for file# 201, old size 177152K, new size 178176K
Resize operation completed for file# 201, old size 178176K, new size 179200K
Resize operation completed for file# 201, old size 179200K, new size 180224K
Resize operation completed for file# 201, old size 180224K, new size 181248K
Resize operation completed for file# 201, old size 181248K, new size 182272K
Resize operation completed for file# 201, old size 182272K, new size 183296K
2019-12-10T03:19:27.307488-08:00
Resize operation completed for file# 201, old size 183296K, new size 184320K
Resize operation completed for file# 201, old size 184320K, new size 185344K
Resize operation completed for file# 201, old size 185344K, new size 186368K
Resize operation completed for file# 201, old size 186368K, new size 187392K
Resize operation completed for file# 201, old size 187392K, new size 188416K
Resize operation completed for file# 201, old size 188416K, new size 189440K
Resize operation completed for file# 201, old size 189440K, new size 190464K
Resize operation completed for file# 201, old size 190464K, new size 191488K
Resize operation completed for file# 201, old size 191488K, new size 192512K
Resize operation completed for file# 201, old size 192512K, new size 193536K
Resize operation completed for file# 201, old size 193536K, new size 194560K
Resize operation completed for file# 201, old size 194560K, new size 195584K
Resize operation completed for file# 201, old size 195584K, new size 196608K
Resize operation completed for file# 201, old size 196608K, new size 197632K
Resize operation completed for file# 201, old size 197632K, new size 198656K
Resize operation completed for file# 201, old size 198656K, new size 199680K
Resize operation completed for file# 201, old size 199680K, new size 200704K
Resize operation completed for file# 201, old size 200704K, new size 201728K
Resize operation completed for file# 201, old size 201728K, new size 202752K
Resize operation completed for file# 201, old size 202752K, new size 203776K
Resize operation completed for file# 201, old size 203776K, new size 204800K
Resize operation completed for file# 201, old size 204800K, new size 205824K
Resize operation completed for file# 201, old size 205824K, new size 206848K
Resize operation completed for file# 201, old size 206848K, new size 207872K
Resize operation completed for file# 201, old size 207872K, new size 208896K
2019-12-10T03:19:28.369410-08:00
Resize operation completed for file# 201, old size 208896K, new size 209920K
Resize operation completed for file# 201, old size 209920K, new size 210944K
Resize operation completed for file# 201, old size 210944K, new size 211968K
Resize operation completed for file# 201, old size 211968K, new size 212992K
Resize operation completed for file# 201, old size 212992K, new size 214016K
Resize operation completed for file# 201, old size 214016K, new size 215040K
Resize operation completed for file# 201, old size 215040K, new size 216064K
Resize operation completed for file# 201, old size 216064K, new size 217088K
Resize operation completed for file# 201, old size 217088K, new size 218112K
Resize operation completed for file# 201, old size 218112K, new size 219136K
Resize operation completed for file# 201, old size 219136K, new size 220160K
Resize operation completed for file# 201, old size 220160K, new size 221184K
Resize operation completed for file# 201, old size 221184K, new size 222208K
Resize operation completed for file# 201, old size 222208K, new size 223232K
Resize operation completed for file# 201, old size 223232K, new size 224256K
Resize operation completed for file# 201, old size 224256K, new size 225280K
Resize operation completed for file# 201, old size 225280K, new size 226304K
Resize operation completed for file# 201, old size 226304K, new size 227328K
Resize operation completed for file# 201, old size 227328K, new size 228352K
Resize operation completed for file# 201, old size 228352K, new size 229376K
Resize operation completed for file# 201, old size 229376K, new size 230400K
Resize operation completed for file# 201, old size 230400K, new size 231424K
Resize operation completed for file# 201, old size 231424K, new size 232448K
Resize operation completed for file# 201, old size 232448K, new size 233472K
Resize operation completed for file# 201, old size 233472K, new size 234496K
Resize operation completed for file# 201, old size 234496K, new size 235520K
Resize operation completed for file# 201, old size 235520K, new size 236544K
Resize operation completed for file# 201, old size 236544K, new size 237568K
Resize operation completed for file# 201, old size 237568K, new size 238592K
Resize operation completed for file# 201, old size 238592K, new size 239616K
Resize operation completed for file# 201, old size 239616K, new size 240640K
Resize operation completed for file# 201, old size 240640K, new size 241664K
Resize operation completed for file# 201, old size 241664K, new size 242688K
Resize operation completed for file# 201, old size 242688K, new size 243712K
Resize operation completed for file# 201, old size 243712K, new size 244736K
Resize operation completed for file# 201, old size 244736K, new size 245760K
Resize operation completed for file# 201, old size 245760K, new size 246784K
Resize operation completed for file# 201, old size 246784K, new size 247808K
2019-12-10T03:19:29.384977-08:00
Resize operation completed for file# 201, old size 247808K, new size 248832K
Resize operation completed for file# 201, old size 248832K, new size 249856K
Resize operation completed for file# 201, old size 249856K, new size 250880K
Resize operation completed for file# 201, old size 250880K, new size 251904K
Resize operation completed for file# 201, old size 251904K, new size 252928K
Resize operation completed for file# 201, old size 252928K, new size 253952K
Resize operation completed for file# 201, old size 253952K, new size 254976K
Resize operation completed for file# 201, old size 254976K, new size 256000K
Resize operation completed for file# 201, old size 256000K, new size 257024K
Resize operation completed for file# 201, old size 257024K, new size 258048K
Resize operation completed for file# 201, old size 258048K, new size 259072K
Resize operation completed for file# 201, old size 259072K, new size 260096K
Resize operation completed for file# 201, old size 260096K, new size 261120K
2019-12-10T03:19:33.338869-08:00
Resize operation completed for file# 201, old size 261120K, new size 262144K
Resize operation completed for file# 201, old size 262144K, new size 263168K
Resize operation completed for file# 201, old size 263168K, new size 264192K
Resize operation completed for file# 201, old size 264192K, new size 265216K
Resize operation completed for file# 201, old size 265216K, new size 266240K
Resize operation completed for file# 201, old size 266240K, new size 267264K
Resize operation completed for file# 201, old size 267264K, new size 268288K
Resize operation completed for file# 201, old size 268288K, new size 269312K
Resize operation completed for file# 201, old size 269312K, new size 270336K
2019-12-10T03:19:34.400918-08:00
Resize operation completed for file# 201, old size 270336K, new size 271360K
Resize operation completed for file# 201, old size 271360K, new size 272384K
Resize operation completed for file# 201, old size 272384K, new size 273408K
Resize operation completed for file# 201, old size 273408K, new size 274432K
Resize operation completed for file# 201, old size 274432K, new size 275456K
Resize operation completed for file# 201, old size 275456K, new size 276480K
Resize operation completed for file# 201, old size 276480K, new size 277504K
2019-12-10T03:19:35.401399-08:00
Resize operation completed for file# 201, old size 277504K, new size 278528K
Resize operation completed for file# 201, old size 278528K, new size 279552K
Resize operation completed for file# 201, old size 279552K, new size 280576K
Resize operation completed for file# 201, old size 280576K, new size 281600K
Resize operation completed for file# 201, old size 281600K, new size 282624K
Resize operation completed for file# 201, old size 282624K, new size 283648K
Resize operation completed for file# 201, old size 283648K, new size 284672K
Resize operation completed for file# 201, old size 284672K, new size 285696K
Resize operation completed for file# 201, old size 285696K, new size 286720K
Resize operation completed for file# 201, old size 286720K, new size 287744K
Resize operation completed for file# 201, old size 287744K, new size 288768K
Resize operation completed for file# 201, old size 288768K, new size 289792K
Resize operation completed for file# 201, old size 289792K, new size 290816K
Resize operation completed for file# 201, old size 290816K, new size 291840K
Resize operation completed for file# 201, old size 291840K, new size 292864K
Resize operation completed for file# 201, old size 292864K, new size 293888K
Resize operation completed for file# 201, old size 293888K, new size 294912K
Resize operation completed for file# 201, old size 294912K, new size 295936K
Resize operation completed for file# 201, old size 295936K, new size 296960K
Resize operation completed for file# 201, old size 296960K, new size 297984K
2019-12-10T03:19:36.416795-08:00
Resize operation completed for file# 201, old size 297984K, new size 299008K
Resize operation completed for file# 201, old size 299008K, new size 300032K
Resize operation completed for file# 201, old size 300032K, new size 301056K
Resize operation completed for file# 201, old size 301056K, new size 302080K
Resize operation completed for file# 201, old size 302080K, new size 303104K
Resize operation completed for file# 201, old size 303104K, new size 304128K
Resize operation completed for file# 201, old size 304128K, new size 305152K
Resize operation completed for file# 201, old size 305152K, new size 306176K
Resize operation completed for file# 201, old size 306176K, new size 307200K
Resize operation completed for file# 201, old size 307200K, new size 308224K
Resize operation completed for file# 201, old size 308224K, new size 309248K
Resize operation completed for file# 201, old size 309248K, new size 310272K
Resize operation completed for file# 201, old size 310272K, new size 311296K
Resize operation completed for file# 201, old size 311296K, new size 312320K
Resize operation completed for file# 201, old size 312320K, new size 313344K
Resize operation completed for file# 201, old size 313344K, new size 314368K
Resize operation completed for file# 201, old size 314368K, new size 315392K
Resize operation completed for file# 201, old size 315392K, new size 316416K
Resize operation completed for file# 201, old size 316416K, new size 317440K
Resize operation completed for file# 201, old size 317440K, new size 318464K
Resize operation completed for file# 201, old size 318464K, new size 319488K
Resize operation completed for file# 201, old size 319488K, new size 320512K
Resize operation completed for file# 201, old size 320512K, new size 321536K
Resize operation completed for file# 201, old size 321536K, new size 322560K
Resize operation completed for file# 201, old size 322560K, new size 323584K
Resize operation completed for file# 201, old size 323584K, new size 324608K
Resize operation completed for file# 201, old size 324608K, new size 325632K
Resize operation completed for file# 201, old size 325632K, new size 326656K
Resize operation completed for file# 201, old size 326656K, new size 327680K
2019-12-10T03:19:37.432280-08:00
Resize operation completed for file# 201, old size 327680K, new size 328704K
Resize operation completed for file# 201, old size 328704K, new size 329728K
Resize operation completed for file# 201, old size 329728K, new size 330752K
Resize operation completed for file# 201, old size 330752K, new size 331776K
Resize operation completed for file# 201, old size 331776K, new size 332800K
Resize operation completed for file# 201, old size 332800K, new size 333824K
Resize operation completed for file# 201, old size 333824K, new size 334848K
Resize operation completed for file# 201, old size 334848K, new size 335872K
Resize operation completed for file# 201, old size 335872K, new size 336896K
Resize operation completed for file# 201, old size 336896K, new size 337920K
Resize operation completed for file# 201, old size 337920K, new size 338944K
Resize operation completed for file# 201, old size 338944K, new size 339968K
Resize operation completed for file# 201, old size 339968K, new size 340992K
Resize operation completed for file# 201, old size 340992K, new size 342016K
2019-12-10T03:19:39.541305-08:00
Resize operation completed for file# 9, old size 14840768K, new size 14906304K
2019-12-10T03:19:42.088389-08:00
Resize operation completed for file# 9, old size 14906304K, new size 14971840K
2019-12-10T03:19:45.322521-08:00
Resize operation completed for file# 9, old size 14971840K, new size 15037376K
2019-12-10T03:19:48.151545-08:00
Resize operation completed for file# 9, old size 15037376K, new size 15102912K
2019-12-10T03:19:52.776158-08:00
Resize operation completed for file# 9, old size 15102912K, new size 15168448K
2019-12-10T03:19:56.104915-08:00
Resize operation completed for file# 9, old size 15168448K, new size 15233984K
2019-12-10T03:19:58.682216-08:00
Resize operation completed for file# 9, old size 15233984K, new size 15299520K
2019-12-10T03:20:01.401175-08:00
Resize operation completed for file# 9, old size 15299520K, new size 15365056K
2019-12-10T03:20:04.901382-08:00
Resize operation completed for file# 9, old size 15365056K, new size 15430592K
2019-12-10T03:20:07.074033-08:00
Resize operation completed for file# 9, old size 15430592K, new size 15496128K
2019-12-10T03:20:11.213864-08:00
Resize operation completed for file# 9, old size 15496128K, new size 15561664K
2019-12-10T03:20:14.354094-08:00
Resize operation completed for file# 9, old size 15561664K, new size 15627200K
2019-12-10T03:20:17.791629-08:00
Thread 1 advanced to log sequence 69 (LGWR switch)
Current log# 1 seq# 69 mem# 0: C:\APP\ORACLE\ORADATA\ORCLLRDE\REDO01.LOG
2019-12-10T03:20:18.119626-08:00
Resize operation completed for file# 9, old size 15627200K, new size 15692736K
2019-12-10T03:20:35.088832-08:00
Archived Log entry 68 added for T-1.S-68 ID 0x3339731c LAD:1
2019-12-10T03:20:51.541569-08:00
Resize operation completed for file# 201, old size 342016K, new size 343040K
Resize operation completed for file# 201, old size 343040K, new size 344064K
2019-12-10T03:20:54.072519-08:00