All Forums UDA
Tdarc 6 posts Joined 07/11
01 Jul 2011
not able to rename table while backups running

Hello All,
we are using Netbackup and TARA for backups .
ETL job was failed with RDBMS code 7595: Operation not allowed: an online archive logging is currently active on Database. my investigation is
while the backup job is running on the database it is holding lock on that database until it complete the backup for that database. Example CAPACC01 database takes around 50 minutes to
complte backup,during this time ETL jobs not abel do any change on tables in that database, etl jobs aborting with 7595 error. once backup job compltes same ETL jobs runs fine.

here is my backup job script
logon $ logon
archive data tables
release lock,
file = archive;
my question ::: --->> Is there anyway we can take just a current database snapshot and allow ETL jobs to work on that database with out holding the lock untill backup completes.
Thanks in advance.

Thank you
You must sign in to leave a comment.