Changing Archivelog Destination of the Primary Database

 
Usually it is generally easy to change the archivelog destination of the primary database especially when the current archivelog destination system is almost full. However, when Oracle Dataguard is configured using Dataguard Broker you also need to change the Dataguard Broker configuration. Failure to edit the dataguard broker configuration file will cause the Dataguard broker to make its own changes on the archive log destination parameters.

Change the archivelog dest via alter system command (/tmp is the new location):
ALTER SYSTEM SET log_archive_dest_1='location="/tmp", valid_for=(ONLINE_LOGFILE,ALL_ROLES)' scope=both sid='*';

If you’re using dataguard broker, edit the broker configuration settings (/tmp is the new location):

— check current config
DGMGRL> connect /
Connected.
DGMGRL> show database [database_name] standbyarchivelocation
StandbyArchiveLocation = '/arch1'

— edit current config
DGMGRL> connect /
Connected.
edit database [database_name] set property StandbyArchiveLocation = '/tmp';

— check again
DGMGRL> connect /
Connected.
DGMGRL> show database [database_name] standbyarchivelocation
StandbyArchiveLocation = '/tmp'

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

About Jimbart