Video Screencast Help

Backup of Oracle DB fail

Created: 24 May 2012 • Updated: 30 May 2012 | 8 comments
This issue has been solved. See solution.

Hi.

I have BE 2012 on windows server, and RALUS installed on oracle linux 5 with Oracle 11g2.

When i start oracle backup job, it's run about 2 minutes and successfully complete.

But in the job log section "rman" i see some errors.

Any Ideas?

 

Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 22 15:36:18 2012
 
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
 
 
connected to target database: PLANETA (DBID=2559744829)
 
 
 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=10.144.8.21,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={0657A713-E136-4262-AE1D-544728386596},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\sun\planeta';
 BACKUP
     FULL
     FORMAT 'BE_U'
     DATABASE FORCE PLUS ARCHIVELOG FORCE NOT BACKED UP;
 BACKUP CURRENT CONTROLFILE 
     FORMAT 'BE_U';
 
 RELEASE CHANNEL ch0;
 }
using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: SID=183 device type=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0
 
sent command to channel: ch0
 
 
Starting backup at 22-MAY-12
current log archived
channel ch0: starting archived log backup set
channel ch0: specifying archived log(s) in backup set
input archived log thread=1 sequence=76152 RECID=296539 STAMP=783820936
input archived log thread=1 sequence=76153 RECID=296542 STAMP=783821145
input archived log thread=1 sequence=76154 RECID=296545 STAMP=783821397
input archived log thread=1 sequence=76155 RECID=296548 STAMP=783821429
input archived log thread=1 sequence=76156 RECID=296551 STAMP=783821984
input archived log thread=1 sequence=76157 RECID=296554 STAMP=783823143
input archived log thread=1 sequence=76158 RECID=296556 STAMP=783824413
input archived log thread=1 sequence=76159 RECID=296560 STAMP=783825268
input archived log thread=1 sequence=76160 RECID=296563 STAMP=783826486
input archived log thread=1 sequence=76161 RECID=296566 STAMP=783829793
input archived log thread=1 sequence=76162 RECID=296569 STAMP=783830307
input archived log thread=1 sequence=76163 RECID=296572 STAMP=783832308
input archived log thread=1 sequence=76164 RECID=296575 STAMP=783834765
input archived log thread=1 sequence=76165 RECID=296578 STAMP=783840907
input archived log thread=1 sequence=76166 RECID=296581 STAMP=783846337
input archived log thread=1 sequence=76167 RECID=296584 STAMP=783846757
input archived log thread=1 sequence=76168 RECID=296587 STAMP=783846773
input archived log thread=1 sequence=76169 RECID=296589 STAMP=783846790
input archived log thread=1 sequence=76170 RECID=296592 STAMP=783846806
input archived log thread=1 sequence=76171 RECID=296595 STAMP=783846825
input archived log thread=1 sequence=76172 RECID=296598 STAMP=783846842
input archived log thread=1 sequence=76173 RECID=296601 STAMP=783846863
input archived log thread=1 sequence=76174 RECID=296604 STAMP=783846881
input archived log thread=1 sequence=76175 RECID=296607 STAMP=783846899
input archived log thread=1 sequence=76176 RECID=296611 STAMP=783848667
input archived log thread=1 sequence=76177 RECID=296614 STAMP=783850207
input archived log thread=1 sequence=76178 RECID=296617 STAMP=783852315
input archived log thread=1 sequence=76179 RECID=296620 STAMP=783853903
input archived log thread=1 sequence=76180 RECID=296623 STAMP=783854065
input archived log thread=1 sequence=76181 RECID=296626 STAMP=783854404
input archived log thread=1 sequence=76182 RECID=296629 STAMP=783855241
input archived log thread=1 sequence=76183 RECID=296632 STAMP=783856419
input archived log thread=1 sequence=76184 RECID=296635 STAMP=783857128
input archived log thread=1 sequence=76185 RECID=296638 STAMP=783857340
input archived log thread=1 sequence=76186 RECID=296641 STAMP=783857549
input archived log thread=1 sequence=76187 RECID=296644 STAMP=783857802
input archived log thread=1 sequence=76188 RECID=296647 STAMP=783858297
input archived log thread=1 sequence=76189 RECID=296650 STAMP=783858793
input archived log thread=1 sequence=76190 RECID=296653 STAMP=783859547
input archived log thread=1 sequence=76191 RECID=296656 STAMP=783860337
input archived log thread=1 sequence=76192 RECID=296659 STAMP=783860629
input archived log thread=1 sequence=76193 RECID=296662 STAMP=783861173
input archived log thread=1 sequence=76194 RECID=296665 STAMP=783861277
input archived log thread=1 sequence=76195 RECID=296668 STAMP=783861479
input archived log thread=1 sequence=76196 RECID=296671 STAMP=783861938
input archived log thread=1 sequence=76197 RECID=296674 STAMP=783862183
input archived log thread=1 sequence=76198 RECID=296677 STAMP=783862474
input archived log thread=1 sequence=76199 RECID=296680 STAMP=783862700
input archived log thread=1 sequence=76200 RECID=296683 STAMP=783863073
input archived log thread=1 sequence=76201 RECID=296686 STAMP=783863278
input archived log thread=1 sequence=76202 RECID=296689 STAMP=783865399
input archived log thread=1 sequence=76203 RECID=296692 STAMP=783867090
input archived log thread=1 sequence=76204 RECID=296695 STAMP=783867615
input archived log thread=1 sequence=76205 RECID=296698 STAMP=783869181
input archived log thread=1 sequence=76206 RECID=296701 STAMP=783869240
input archived log thread=1 sequence=76207 RECID=296704 STAMP=783869328
input archived log thread=1 sequence=76208 RECID=296707 STAMP=783869421
input archived log thread=1 sequence=76209 RECID=296710 STAMP=783869582
input archived log thread=1 sequence=76210 RECID=296713 STAMP=783869719
input archived log thread=1 sequence=76211 RECID=296716 STAMP=783870811
input archived log thread=1 sequence=76212 RECID=296719 STAMP=783871573
input archived log thread=1 sequence=76213 RECID=296722 STAMP=783871736
input archived log thread=1 sequence=76214 RECID=296725 STAMP=783871969
channel ch0: starting piece 1 at 22-MAY-12
released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 05/22/2012 15:36:34
ORA-19506: ???? ??? ???????? ????????????????? ?????, ???="BE_0mnbkl80_1_1", ?????????=""
ORA-27028: skgfqcre: ?????????? ?????? sbtbackup
ORA-19511: ? ?????? ?????????? ????????? ???????? ????????? ?? ??????, ????? ??????:
 
 EXIT
 

Recovery Manager complete. 

Comments 8 CommentsJump to latest comment

Manjunath Rajanna's picture

If possible please post the RMAN logs and Job logs. It will gives more info.

MaratG's picture

Unfortunately job logs in russian.

I already attach agent log in first message "beremote_log.txt" from "beremote --log-console" command. 

 

SuperBrain's picture

These may help you, since they are all related to the same ORA codes which I see in the RMAN output you pasted above:
 

http://www.symantec.com/docs/TECH85031 - Backup of Oracle fails with "ora-19506: failed to create sequential file" in the Database script output in the job log.

http://www.symantec.com/docs/TECH176686 - When repeating incremental or differential backups using Oracle Agent, the job intermittently fails with a communications failure has occurred

http://www.symantec.com/docs/TECH51408 - Oracle Recovery Manager (RMAN) backups fail intermittently with error: ORA-19506: failed to create sequential file

http://www.symantec.com/docs/TECH77064 - Oracle backups fail if the user expanding the Oracle server in the selection list do not have the correct credentials

http://www.symantec.com/docs/TECH61808 - Backup Exec 11d and 12.0 for Windows Servers: Software compressed or encrypted backups of Oracle databases larger than 4 gigs cannot be restored.

MaratG's picture

I think connection between server and client fine, because i had successfully backup about 1Tb data from file system on this server. There now any enabled firewalls in network and operating systems. Server with RALUS and media server in one broadcast domain.

swati's picture

Please try to rerun the job and this time with VXBSA level set to 8. You can set this in /etc/VRTSRalus/ralus.cfg. If issue is reproduced, please post vxbsa log that gets generated at /var/VRTSRalus/ folder.

Thanks.

MaratG's picture

Thanks to everyone. The problem was in credentials.

Re-entry users and passwords in media server solved the issue.

SOLUTION