not able to rename table while backups running

UDA
Enthusiast

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
(CAPACC01)ALL,
(CAPACC02)ALL,
(CAPACC03)ALL,
release lock,
online,
file = archive;
logoff;
endscript
---------------------------
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.
Krish.
Tags (3)