Deleting Oracle Archive Logs from the Node Which Is Not Running Backups

An Oracle Data Guard configuration has two or more database sites. One site is designated as the primary site and the remaining sites are standby sites. Since the logs are deleted where the backups occur, create a log subclient for each site.

Procedure

  1. On the server which is not involved in running backups, create a separate log-only subclient that has the delete archivelogs option.

  2. Set up the configuration such that streams are passed on the nodes where archivelog backup needs to be initiated but no streams are passed on nodes making database backups, since those nodes will not run archivelog backups.

  3. Schedule the backup job to run on that subclient.

  4. This method can be configured in the opposite manner on both the primary and standby servers.

In an Oracle Data Guard configuration, whether the primary or standby host runs the data or log backups depends on the roles configured for the sites. For more information about configuring the roles, see Specifying the Servers that Run Backups in an Oracle Data Guard Configuration.

Page contents

×

Loading...