Re: Archiving Oracle Archived Logs via RMAN with Legato
Date: 2000/07/09
Message-ID: <8k9q5l$sj2$1_at_news.netcologne.de>
Hello.
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
Database and don't explicitly append the Net-Service-Name in your
Connection-String, it will default to the Bequeath-Stack. Set ORACLE SID
instead.
connect target rman/rman_at_wdba ;
connect rcvcat rman/rman_at_dorecover ;
run {
set command id to "ARC" ; allocate channel t1 type 'SBT TAPE' allocate channel t2 type 'SBT TAPE' parms 'ENV=(NSR SERVER=sun-ph-server)'; sql "alter system archive log current" ; backup setsize = 1000 filesperset=4 format '%d %u' ( archivelog all delete input) ; release channel t1 ; release channel t2 ;
}
"manaloe" <manaloe_at_my-deja.com> schrieb im Newsbeitrag
news:8k5g5f$6as$1_at_nnrp1.deja.com...
> Hi, there ...
>
> 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_at_wdba ;
> connect rcvcat rman/rman_at_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.
--Received on Sun Jul 09 2000 - 00:00:00 CEST