Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Have a problem with oracle rman backup to remote bab server

Status
Not open for further replies.

vkirichenko

IS-IT--Management
Mar 28, 2006
18
0
0
UA
I has two BAB servers 11.5 SP3 with oracle agent. If I try to do rman backup localy on server - that is ok. But if i try backup to remote bab server i have error.
Please help me - how to do remote rman backup???
Script
//////////////////////////////////////
run
{
allocate channel dev1 device type sbt parms='ENV=(SBT_HOST=eniro_b, SBT_ORIGINAL_CLIENT_HOST=mbs_2,SBT_LOGDETAIL=all,SBT_LOGFILE=c:\temp\sbt.log,SBT_DESTGROUP=rman0)';
#send channel dev1 "SBT_HOST=10.10.10.61";
#send channel dev1 "SBT_ORIGINAL_CLIENT_HOST=10.10.10.50";
#send channel dev1 "SBT_LOGDETAIL=all";
#send channel dev1 "SBT_LOGFILE=c:\temp\my_sbt.log";
#send channel dev1 "SBT_DESTGROUP=RMAN0";
#send channel dev1 "SBT_MEDIAPOOL=ORA_RMAN";
backup current controlfile;
#BACKUP INCREMENTAL LEVEL 0 DATABASE include current controlfile ;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP archivelog from time 'SYSDATE-8' until time 'SYSDATE+1';
release channel dev1;
}
/////////////////////////////////////////
LOGFILE rman's
/////////////////////////////////////////
allocated channel: dev1
channel dev1: sid=31 devtype=SBT_TAPE
channel dev1: MMS Version 0.0.0.0

Starting backup at 26.11.2007
channel dev1: starting full datafile backupset
channel dev1: specifying datafile(s) in backupset
including current controlfile in backupset
channel dev1: starting piece 1 at 26.11.2007
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 11/26/2007 14:36:17
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-12004: unhandled exception during command execution on channel dev1
RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential file, name="2bj217f0_1_1", parms=""
ORA-27007: failed to open file
ORA-19511: Error received from media manager layer, error text:
SBT error = 7009, errno = 164790556, sbtopen: can't connect with media manager
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Recovery Manager complete.
//////////////////////////////////////////////////////
IN SBTIO.LOG
//////////////////////////////////////////////////////
<11/26/07:14:36:16>: _ASFileBackup() failed. ASResult = -1
//////////////////////////////////////////////////////
IN ORASBT.TRC
//////////////////////////////////////////////////////
<14:36:16 :TID[928]>: Trace is on, orasbt.dll is loaded with delay load cstool.dll

<14:36:16 :TID[928]>: agentHomeDir=C:\Program Files\CA\BrightStor ARCserve Backup Agent for Oracle

<14:36:16 :TID[928]>: loading C:\Program Files\CA\BrightStor ARCserve Backup Agent for Oracle\ASAPI.dll succesful
<14:36:16 :TID[928]>: ****** 11/26/07 14:36 ****** sbtinit() ******
<14:36:16 :TID[928]>: ****** 11/26/07 14:36 ****** sbtopen() ******
<14:36:16 :TID[928]>: - sbtopen() called:backup file name = 2bj217f0_1_1, open mode = 2, tape block size = 65536
<14:36:16 :TID[928]>: sbtopen(): Timeout set to be 600 seconds
<14:36:16 :TID[928]>: CreateIPCforIdx() is called
<14:36:16 :TID[928]>: creating global mutex for transfering idx
<14:36:16 :TID[928]>: Create mutex for tranfering idx successful. GetLastError()=183
<14:36:16 :TID[928]>: creating global Event for transfering idx
<14:36:16 :TID[928]>: Creat Event for tranfering idx successful. GetLastError()=183
<14:36:16 :TID[928]>: creating g_idxReplyEvent for transfering idx
<14:36:16 :TID[928]>: Creat g_idxReplyEvent for tranfering idx successful. GetLastError()=183
<14:36:16 :TID[928]>: waiting for g_idxMutex
<14:36:16 :TID[928]>: database name = eniro
<14:36:16 :TID[928]>: domain name =
<14:36:16 :TID[928]>: ASComputerName = eniro_b
<14:36:16 :TID[928]>: ASUserName = ca
<14:36:16 :TID[928]>: strlen(ASPassword) = 8
<14:36:16 :TID[928]>: ASDomain = eniro_b
<14:36:16 :TID[928]>: sSourceUserName = tiran
<14:36:16 :TID[928]>: strlen(sSourcePassword) = 8
<14:36:16 :TID[928]>: sTargetTapeGroup = RMAN0
<14:36:16 :TID[928]>: sTargetTapeName = *
<14:36:16 :TID[928]>: NetWkstaGetInfo() is successful. sSourceDomain=MBSWORK
<14:36:16 :TID[928]>: currentUser=SYSTEM, impersonate necessary.
<14:36:16 :TID[928]>: LogonUser() is O.K. sSourceUserName=tiran, sSourceDomain=(.)
<14:36:16 :TID[928]>: ImpersonateLoggedOnUser() successful
<14:36:16 :TID[928]>: _ASFileBackup: sASComputerName=eniro_b sASUserName=ca sASPassword=(len=8), sASDomain=eniro_b, sTargetTapeGroup=RMAN0, sTargetTapeName=*, sTargetTapeID=(null), sSourceDomain=MBSWORK, sSourceUserName=tiran, sSourcePassword=(len=8)
<14:36:16 :TID[928]>: _ASFileBackup() failed. ASResult = -1
//////////////////////////////////////////////////////
IN then log activity on server side - none.


PLASE HELP - WHY backup does not work? what is missing?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top