Hello;
I'm facing issues with RMAN backup, after completing the backup and all channels released, a connection time out received.
error message:
channel t4: backup set complete, elapsed time: 00:06:29
Finished backup at 25-OCT-17
released channel: t1
released channel: t2
released channel: t3
released channel: t4
released channel: t5
released channel: t6
released channel: t7
released channel: t8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-03135: connection lost contact
Process ID: 11519
Session ID: 133 Serial number: 50271
ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE
==============RMAN Script =====================================================
RMAN Script:#For full Incremental backup (Level 0).
connect target rman_Cat/rmancat@CC
connect catalog rman_CC/rman@DD
run {
allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_CLIENT=XXX,NSR_SERVER=nwriy1)';
allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_CLIENT=XXX,NSR_SERVER=nwriy1)';
allocate channel t3 type 'SBT_TAPE' parms 'ENV=(NSR_CLIENT=XXX,NSR_SERVER=nwriy1)';
allocate channel t4 type 'SBT_TAPE' parms 'ENV=(NSR_CLIENT=XXX,NSR_SERVER=nwriy1)';
allocate channel t5 type 'SBT_TAPE' parms 'ENV=(NSR_CLIENT=XXX,NSR_SERVER=nwriy1)';
allocate channel t6 type 'SBT_TAPE' parms 'ENV=(NSR_CLIENT=XXX,NSR_SERVER=nwriy1)';
allocate channel t7 type 'SBT_TAPE' parms 'ENV=(NSR_CLIENT=XXX,NSR_SERVER=nwriy1)';
allocate channel t8 type 'SBT_TAPE' parms 'ENV=(NSR_CLIENT=XXX,NSR_SERVER=nwriy1)';
crosscheck archivelog all;
delete noprompt expired archivelog all;delete noprompt force obsolete;
backup incremental level 0 filesperset 1 format 'db_t%t_s%s_p%p'(database include current controlfile)spfile format 'spfile_%d_%s_%T.bak' tag 'spfile backup';
sql "alter system archive log current";
backup archivelog all not backed up 2 times ;
delete archivelog all backed up 2 times to device type sbt completed before 'sysdate-7';
release channel t1;
release channel t2;
release channel t3;
release channel t4;
release channel t5;
release channel t6;
release channel t7;
release channel t8;
}
Thanks and best regards
Ali
Message was edited by: Ali M. Labadi