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-03009 ORA-27192 ORA-19511 VxBSAEndTxn: Failed with error:

845201Mar 6 2011 — edited Mar 8 2011
Hello Gurus,

I am using oracle 9.2.0.6 for my production database of size 800+GB. We are using RMAN for backup using netbackup (Symantec). I am facing errors while taking full backup, it was happened as ….

In past backup was happened properly, infact I restore the same database last year from the backup took. All was well until last month, suddenly my backup was failing, and when I contacting my vendor for backup failed they mentioned modifying the backup script.
After changing the script successful backup was done only once. It is throwing error as below.

It was able to backed up few DB files, later it breaks and throws errors. Using same script I can take successfull backup from the my end, while it failed when executed from netbackup server.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
channel ch1: starting piece 1 at 07-MAR-11
released channel: ch1
released channel: ch2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch2 channel at 03/07/2011 01:12:32
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
VxBSAEndTxn: Failed with error:
The transaction was aborted.

Following RMAN command is used to have backup.

CMD_STR="
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
rman target / catalog rman/******** msglog $RMAN_LOG_FILE append << EOF
RUN {
ALLOCATE CHANNEL ch1 TYPE 'SBT_TAPE' ;
ALLOCATE CHANNEL ch2 TYPE 'SBT_TAPE' ;
# Issue full backup
SEND 'NB_ORA_SERV=aliasAUV102, NB_ORA_CLIENT=aliasAUV129, NB_ORA_POLICY=GENAOS-RMAN-WEEKLY';
BACKUP
FULL DATABASE
TAG FULL_DB_WEEKLY
FILESPERSET 10
FORMAT 'HOT_BACKUP_RMAN_DB_%d_%u_%p_%t'
;
# Archive current log file
# sql 'alter system archive log current';
# Release channels
RELEASE CHANNEL ch1;
RELEASE CHANNEL ch2;
ALLOCATE CHANNEL ch1 TYPE 'SBT_TAPE' ;
# Backup all archive logs
SEND 'NB_ORA_SERV=aliasAUV102, NB_ORA_CLIENT=aliasAUV129, NB_ORA_POLICY=GENAOS-RMAN';
BACKUP ARCHIVELOG ALL
TAG ARCH_LOG_ALL
FILESPERSET 50
FORMAT 'al_t%t_s%s_p%p'
;
# Release channels
RELEASE CHANNEL ch1;
DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE sbt;
}

------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Appriciate immediate help.

Thank you for your time.

Regards
Ashish
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 5 2011
Added on Mar 6 2011
3 comments
10,473 views