Archiving Oracle Archived Logs via RMAN with Legato
manaloe
We are using Legato Networker 5.5.1 to backup our Oracle DB and
Archived Logs via RMAN and we are getting the following error messages
in the Client's /nsr/applogs/rman.log file:
==============================
:
:
RMAN-08031: released channel: t1
RMAN-00569: ================error message stack follows================
RMAN-03099: job cancelled at user request
RMAN-10035: exception raised in RPC: ORA-01013: user requested cancel
of current operation
RMAN-10031: ORA-1013 occurred during call to
DBMS_BACKUP_RESTORE.DELETEARCHIVEDLOG
:
:
==============================
The actual archiving script is as follows:
==============================
connect target rman/rman@wdba ;
connect rcvcat rman/rman@dorecover ;
run {
set command id to "ARC" ;
allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=sun-ph-server)';
sql "alter system archive log current" ;
backup
(archivelog all
format '%d_%u'
delete input) ;
release channel t1 ;
}
==============================
Has anyone seen this before? What could be wrong here?
Thanks a lot for the information.
--
Edwin M. Manalo
CCSC
UNIX Systems Administrator
Sent via Deja.com http://www.deja.com/
Before you buy.
Wolfgang Behrentin
The procedure DBMS_BACKUP_RESTORE.deleteArchivedlog
deletes an operating system file and marks its record in
the controlfile as obsolete so that its row will not appear in the fixed
view. If the stamp in the record does not match the stamp argument, the
controlfile record will not be marked as obsolete. The record is marked
as obsolete before the OSD is called to do the delete. Thus a failure
could result in the piece continuing to exist while the controlfile record
is marked obsolete. An I/O error during the delete will return an error,
but still mark the controlfile record as obsolete.
The control file record describing the file to be deleted in a call to
deleteArchivedLog must match the validation data supplied by
Recovery Manager.
Because of this and the RPC-error, try to improve the average output of
the stream. You migth use the Bequeath-Stack instead of the TCP-Stack in your
connection-string as well. If you want to connect from a Client to a local
connect target rman/rman@wdba ;
connect rcvcat rman/rman@dorecover ;
run {
set command id to "ARC" ;
allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=sun-ph-server)';
sql "alter system archive log current" ;
backup
filesperset=4
format '%d_%u'
( archivelog all delete input) ;
release channel t1 ;
release channel t2 ;
}