Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN - Is it possible to run Archivelog Backup while Full backup is running

user8869408Apr 12 2013 — edited Apr 13 2013
Hi,

Our full database backups runs daily in the night. It fails whenever an archivelog backup kicks off. This happens on our big databases where backups run for long hours and we have to run the archivelog backup to backup/delete the archivelogs to maintain the archivelog destinations.

Is there any way to run these 2 backups in parallel without both failing. We use RMAN catalog to take backups, and we get errors when resyncing of catalog happens during backup.


We get these errors:-
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03008: error while performing automatic resync of recovery catalog
RMAN-20033: control file sequence# too low


and sometimes

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03008: error while performing automatic resync of recovery catalog
ORA-00230: operation disallowed: snapshot control file enqueue unavailable


Our archivelog destinations are not big enough to hold more than 1 days of logs and we have backups that runs for 30 hours. We have to backup and delete the archivelogs in between, while the full backup is running and right now its failing with able errors. Is there any solution or workaround I can opt for in this scenario.

Any help is Highly appreciated. Thanks in advance for the Help.

Thanks,
Vish
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2013
Added on Apr 12 2013
14 comments
3,397 views