Re: Archiving Oracle Archived Logs via RMAN with Legato

From: Wolfgang Behrentin <behrentin_at_netcologne.de>
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

Original text of this message