Help Center/ GaussDB/ User Guide/ Logs and Auditing/ Downloading Switchover/Failover Logs of a GaussDB Instance
Updated on 2024-11-11 GMT+08:00

Downloading Switchover/Failover Logs of a GaussDB Instance

You can download switchover/failover logs of a GaussDB instance. If switchover/failover log collection is enabled for an instance whose Failover Priority is Availability, GaussDB can collect Xlogs that cannot be replayed on the standby node in time when a switchover or failover occurs and convert the Xlogs into a SQL file. You can download the SQL file and run SQL statements to replay the data in the SQL file as required.

Precautions

  • CNs and DNs of the instance are normal.
  • The IaaS network is normal.
  • Switchover/Failover logs are available only for distributed instances whose Failover Priority is Availability.

Switchover/Failover Logs

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page and choose Databases > GaussDB.
  4. On the Instances page, click the name of the target instance to go to the Basic Information page.
  5. In the navigation pane on the left, choose Log Analysis.
  6. On the displayed page, click the Switchover/Failover Logs page, enable Switchover/Failover Log Collection, and click Download in the Operation column of the record whose status is Preparation completed to download the switchover/failover log file.