Data Backup and Recovery

Referencing to profile and config variables?

f_duranti
4,512 Views

Hi, there's any way to referencing to profile directory and config name from a config file?

Something to pass to the ARCHIVE_CMDxx= in a standard way instead of having to configure it manually for every config?

Example:

I launch /opt/SnapCreator/scServer3.4.0/snapcreator --verbose --policy daily --profile TestProfile --config testoracleaonline --global --action snap

and i can define something like:

ARCHIVE_CMD01=/opt/SnapCreator/scServer3.4.0/snapcreator --verbose --policy %SNAP_TYPE --profile %PROFILE --config %CONFIG --global --action arch

Francesco

1 ACCEPTED SOLUTION

ktenzer
4,512 Views

If you configure ARCHIVE* settings and set ARCHIVE_LOG_ENABLE=Y then SC will delete archive logs based on retention.

Your other option if you want to use something custom is using the ARCHIVE_CMDxx, this allows you to run scripts or command to handle archive log MGMT.

Does this make sense?

Keith

View solution in original post

7 REPLIES 7

charly
4,512 Views

Hi,

I think you can use %CONF_NAME and %CONF_DIR. But I doubt about the usage of calling another action as commandline.

regards

f_duranti
4,512 Views

Thanks for the answer, i'll try to' test it today. I've tested the run of action arch at the end of the normal full backup of oracle to delete old archive logs and it seems to work correctly.

ktenzer
4,512 Views

You can do something like this in config

PRE_APP_QUIESCE_CMD01=echo %CONFNAME

PRE_APP_QUIESCE_CMD02=echo %CONFDIR

CONFNAME = profile

CONFDIR = config directoy

On a single line you can only reference one variable with % so doing echo "%CONFNAME %CONFDIR" wouldnt work.

Passing the %CONFNAME and %CONFDIR in as CLI arguments wont work unfortunately since they are not set till run time.

Regards,

Keith

f_duranti
4,512 Views

I think it's all solved (probably I did not understood how archiving was working)...

I was thinking that i should run the snapcreator --action arch to do archive log deletion but I saw that configuring the archivelog command inside the config file at the end of the backup of oracle it will automatically do an "arch" step so it will delete older then 1 day archivelogs automatically while doing the backup.

Is this the correct behaviour? in the manual I think the archive part is not well documented... it just say how to config it but not that it will do archive automatically at end of database backup.

ktenzer
4,513 Views

If you configure ARCHIVE* settings and set ARCHIVE_LOG_ENABLE=Y then SC will delete archive logs based on retention.

Your other option if you want to use something custom is using the ARCHIVE_CMDxx, this allows you to run scripts or command to handle archive log MGMT.

Does this make sense?

Keith

f_duranti
4,512 Views

Yes Keith the only think I was misunderstanding is that I was thinking that I should use "snapcreator --action arch" after the --action snap (so I was thinking to put the run of snapcreator --action arch inside a ARCHIVE_CMDxx into the same config used by --action snap).

Instead it's already running the archive procedure after the backup was done. So it's all ok And a really nice feature

Thanks

Francesco

ktenzer
4,512 Views

Yep --action arch allows you to run archive log handling only outside of SC. Mostly you wouldnt need this but if you wanted to handle archive logs outside of backup SC could do that. We recommend setting up snapvault or snapmirror and then deleting archive logs as part of backup. With SnapMirror make sure you set NTAP_CLONE_SECONDARY=Y or with PM NTAP_PM_RUN_BACKUP=Y so SC waits for completion and we know it is safe to delete archive logs. Otherwise archive logs could be deleted before we can copy them to secondary.

Keith

Public