we must set our database from CIRCULAR to ARCHIVE mode in order to enable ONLINE backups. Backups will be done every 1 day. Database is now almost 30GB. Database grows approximately 1GB per month. For online backup we will use Veritas NetBackup so we use its library file in the LOGARCHMETH1 parameter for the VENDOR option. Time to restore is not so important parameter, it is important to everything restore from previous day when everything was OK.
Can you please assist me to set those three parameters on appropriate value? This is production database with important data.
LOGPRIMARY and LOGSECOND are set to values 13 and 15 by default but I think it is not enough? Is it to large if I set them to 50 for example? What can be negative effect?
Current values are: 13, 15, 4096. I run Configuration Advisor and it gives me those values: 27, 7, 1024. But for many wizard questions I used default values because I do not know exact answers (for example Transactions per minute,or Average number of connected remote applications..) Why it put the lower value for LOGFILSIZ?
Can someone additionally suggest me are those good values or not ? Thank you!!!!