The init.ora parameter LOG_ARCHIVE_TRACE can be used to find problems with the archiver process. I recently used this to sort out some archiving issues with a standby database. The parameter is dynamically changable using ALTER SYSTEM.
The following values can be used. To get a combination of the required states add the numbers.
* 0 : Disables Tracing
* 1 : Records archiving of redo log files
* 2 : Records status of archiving for each destination
* 4 : Traces archival operation
* 8 : Tracks activity at the archive log destination
* 16 : Tracks in detail activity at archive log destination
* 32 : Records archive log destination parameter changes
* 64 : Tracks ARCn process state
* 128: Traces FAL server activity
* 512: Traces asynchronous log writer activity
*1024: Traces RFS client
*2048: Traces RFS/ARCn heartbeats
No comments:
Post a Comment