You can trace the archive logs on either the primary or the standby database by setting the log_archive_trace initialization parameter

Trace files located in user_dump_dest location.

On the primary database, the log_archive_trace parameter controls the output of the

  • ARCn (archiver)
  • FAL (fetcharchived log)
  • LGWR (log writer) background processes.

On the standby databases, it traces the work of the

  • ARCn
  • RFS (remote file server)
  • FAL processes.

You can specify any of 17 levels of archive log tracing.

If you specify Level 17, the trace file will include trace information from Levels 1, 2, 4, 8 and 16.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply