Re:Archiv Oracle Archived Logs via RMAN with Legato
Date: 2000/07/09
Message-ID: <8k9qi1$sqg$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