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.
Subscribe to:
Posts (Atom)