Oracle or Legato problem???

[day88]

Hi guys,
Below is the RMAN script i run via Legato Networker
____________________________________________________________
Recovery Manager: Release 8.1.7.2.1 - Production
RMAN> connect target sys/xxxxxx@DBAS
2> connect rcvcat bkrman/xxxxxx@rcat
3> run {
4> allocate channel t1 type 'sbt_tape'
5> parms 'ENV=(NSR_SERVER=backupserver01, NSR_DATA_VOLUME_POOL=Daily)';
6>
7> backup full
8> (database include current controlfile);
9>
10> backup
11> (archivelog all delete input);
12>
13> release channel t1;
____________________________________________________________

when it backup till the archive logs portion, it simply just stop there giving no error (see below) and the Legato Networker will eject the tape but the job is still in running state.

RMAN-08504: input archivelog thread=1 sequence=11748 recid=22136 stamp=536899885
RMAN-08504: input archivelog thread=1 sequence=11749 recid=22137 stamp=536904682
RMAN-08504: input archivelog thread=1 sequence=11750 recid=22138 stamp=536909234


If i change the script to "backup archivelog all;" rather then delete all input. It seem OK(See below).
I extracted a portion of the log to post here.
____________________________________________________________
RMAN-08504: input archivelog thread=1 sequence=12175 recid=22563 stamp=538929508
RMAN-08504: input archivelog thread=1 sequence=12176 recid=22564 stamp=538934524
RMAN-08504: input archivelog thread=1 sequence=12177 recid=22565 stamp=538935406
RMAN-08013: channel t1: piece 1 created
RMAN-08503: piece handle=t6g21g3a_1_1 comment=API Version 2.0,MMS Version 3.1.0.0
RMAN-08525: backup set complete, elapsed time: 00:02:05
RMAN-08009: channel t1: starting archivelog backupset
RMAN-08502: set_count=1959 set_stamp=539017448 creation_time=08-OCT-04
RMAN-08014: channel t1: specifying archivelog(s) in backup set
RMAN-08504: input archivelog thread=1 sequence=12178 recid=22566 stamp=538935802
RMAN-08504: input archivelog thread=1 sequence=12179 recid=22567 stamp=538936175
RMAN-08504: input archivelog thread=1 sequence=12232 recid=22620 stamp=539007273
RMAN-08504: input archivelog thread=1 sequence=12233 recid=22621 stamp=539010234
RMAN-08504: input archivelog thread=1 sequence=12234 recid=22622 stamp=539015066
RMAN-08013: channel t1: piece 1 created
RMAN-08503: piece handle=t7g21g78_1_1 comment=API Version 2.0,MMS Version 3.1.0.0
RMAN-08525: backup set complete, elapsed time: 00:02:05
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1

Recovery Manager complete.
________________________________________________________


I dont see it creating the channel t1 as shown below when i use delete all inpuit for archive log.

RMAN-08013: channel t1: piece 1 created
RMAN-08503: piece handle=t6g21g3a_1_1 comment=API Version 2.0,MMS Version 3.1.0.0

Backing the datafiles are OK.

ANY IDEA????

Thanks

 

[milanvo]

Hi day88,

try run RMAN commands manually - start RMAN and enter commands line by line. RMAN should produce error messages if there is problem.

Before archivelogs backup it is recommended to archive current redolog :

...
sql "alter system archive log current";
backup archivelog all delete input;
...

 

[day88]

Thanks, milanvo. Just solved the problem. I added "filesperset" in the script and it works well. Now, i trying to solve another issue.

Thanks