Data Backup and Recovery

Multiple archive log dirs in SC 4.x

JOSEF_158

Hello.

We have database writing its archivelogs into two independent NFS locations. We wanted SnapCreator to manage both locations. In post http://community.netapp.com/t5/Backup-and-Restore-Discussions/DB2-Archive-Log-Management/td-p/24244, there is mentioned that parameters ARCHIVE_LOG_DIR<##> should be used. This is however not working with SC 4.x (we have tested it on  4.1P2 and  4.1.2P1). Also in documentation, there is not mentioned that we could use multiple ARCHIVE_LOG_DIR destinations. 

 

So what is the best and recomended way how to manage multiple archive log directoried ? Thank you very much for help.

 

Best regards,

Josef

1 REPLY 1

JOSEF_158

Hi.

We have not find any direct solution, just a workaround, so I'm posting it here, maybe it will help someone.

 

We changed location of log directories. Primary logs are stored in /db2/TST/log_archive/primary and secondary are stored in /db2/TST/log_archive/secondary. In snapcreator, there is the parent directory as ARCHIVE_LOG_DIR=/db2/TST/log_archive . Snapcreator then recursivly goes through all directories and processes logs as needed.

 

 

Josef

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public