Tuesday, May 31, 2016

Automatic Archival Process in Oracle 9i


In the alert log, ...
Tue May 31 09:57:05 2016
ORACLE Instance ldwtdb - Can not allocate log, archival required




The archival process died after automatic archival is disabled.



This is only happen in oracle 9i and oracle 10g on wards, auto archival is enabled when the database is placed in archive log mode.

In the alert log, ...
Wed Jun  1 14:08:53 2016
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed Jun  1 14:08:53 2016
ARC0: Becoming the 'no FAL' ARCH
ARC1 started with pid=28
ARC1: Archival started
ARC1: Becoming the heartbeat ARCH
Wed Jun  1 14:08:53 2016
ARC0: Becoming the 'no FAL' ARCHARC0: Evaluating archive   log 2 thread 1 sequence 1458
Wed Jun  1 14:08:53 2016
ARC1: Becoming the heartbeat ARCHARC1: Evaluating archive   log 2 thread 1 sequence 1458




Since, these 2 archival processes is working, archiving redolog is working pretty good.