Oracle Database Discussions

Hi,

it is happening that after having changed our backup scheduled time ..the backup full of our database on the tape is failing..

On the other hand the backup of the archivelogs on the tape is successful!!

The error returned is:

RMAN-03009: failure of backup command on t2 channel at 10/29/2012 10:08:44
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
RPC receive operation failed. A network connection could not be established with the host.

The database is Oracle 10.2.0.3 Standard Edition on Microsoft Windows Server 2003 R2.

The backup software is Legato.


The script used for the failed backup is the following:

connect target sys/****@jhoray01;
run{
set command id to 'RMAN';
### allocate channel
allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=,NSR_CLIENT=,NSR_DATA_VOLUME_POOL=)';
allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=,NSR_CLIENT=,NSR_DATA_VOLUME_POOL=)';
allocate channel t3 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=,NSR_CLIENT=,NSR_DATA_VOLUME_POOL=)';
allocate channel t4 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=,NSR_CLIENT=,NSR_DATA_VOLUME_POOL=)';
### backup db
backup incremental level 0 TAG BCK_DATABASE_FULL_DD format '%d_L0_%s_%p' (database) ;
### backup controlfile
backup TAG BCK_CONTROLFILE format '%d_controlfile_%s_%p' (current controlfile);
### copia file del controlfile per sicurezza
sql 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE';

### rilascio dei canali precedentemente allocati
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}


The script used for the successful backup (archive logs) is:

connect target sys/******@jhoray01;
run{
set command id to 'RMAN';
###
allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=bck-host-ev,NSR_CLIENT=NHPAYROLLDB01,NSR_DATA_VOLUME_POOL=Pool15g)';
allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=bck-host-ev,NSR_CLIENT=NHPAYROLLDB01,NSR_DATA_VOLUME_POOL=Pool15g)';
backup archivelog all not backed up 2 times;
delete noprompt archivelog all backed up 2 times to device type 'SBT_TAPE';

}



Any help would be very appreciated!! Thanks in advance


Susy

Edited by: user8837052 on 29-ott-2012 2.33