Dear all,

I Having a proplem with Networker module for Oracle when I restore oracle db to another server:

The backup is ok, the out put is :

RMAN> connect target *
2> change archivelog all validate;
3> run {
4> allocate channel t1 type 'SBT_TAPE';
5> allocate channel t2 type 'SBT_TAPE';
6> send 'NSR_ENV=(NSR_SERVER=ghost-svr,NSR_DATA_VOLUME_POOL=RmanOneMonthPools)';
7> backup
8>   incremental level 0
9>   tag db_kieuhoi_L0
10>   filesperset 5
11>   (database);
12> sql 'alter system archive log current';
13> backup
14>   tag db_kieuhoi_archivelog_L0
15>   filesperset 5
16>   (archivelog all delete input);
17> backup
18>   tag db_kieuhoi_spfile_L0
19>   spfile;
20> backup
21>   tag db_kieuhoi_controlfile_L0
22>   current controlfile;
23> release channel t1;
24> release channel t2;
25> }
26>
connected to target database: KIEUHOI (DBID=3003554212)
using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=958 devtype=DISK
sent command to channel: ORA_DISK_1
specification does not match any archive log in the recovery catalog

released channel: ORA_DISK_1
allocated channel: t1
channel t1: sid=958 devtype=SBT_TAPE
channel t1: NMO v4.5.0.0
sent command to channel: t1

allocated channel: t2
channel t2: sid=1060 devtype=SBT_TAPE
channel t2: NMO v4.5.0.0
sent command to channel: t2

sent command to channel: t1
sent command to channel: t2

Starting backup at 17-JUN-10
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00005 name=/u02/oradata/kieuhoi/KIEUHOI_01.dbf
input datafile fno=00004 name=/u02/oradata/kieuhoi/users01.dbf
channel t1: starting piece 1 at 17-JUN-10
channel t2: starting incremental level 0 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/oradata/kieuhoi/system01.dbf
input datafile fno=00003 name=/u02/oradata/kieuhoi/sysaux01.dbf
input datafile fno=00002 name=/u02/oradata/kieuhoi/undotbs01.dbf
channel t2: starting piece 1 at 17-JUN-10
channel t2: finished piece 1 at 17-JUN-10
piece handle=5mlgfhjb_1_1 tag=DB_KIEUHOI_L0 comment=API Version 2.0,MMS Version 4.5.0.0
channel t2: backup set complete, elapsed time: 00:01:15
channel t2: starting incremental level 0 datafile backupset
channel t2: specifying datafile(s) in backupset
including current control file in backupset
channel t2: starting piece 1 at 17-JUN-10
channel t2: finished piece 1 at 17-JUN-10
piece handle=5nlgfhlm_1_1 tag=DB_KIEUHOI_L0 comment=API Version 2.0,MMS Version 4.5.0.0
channel t2: backup set complete, elapsed time: 00:00:03
channel t2: starting incremental level 0 datafile backupset
channel t2: specifying datafile(s) in backupset
including current SPFILE in backupset
channel t2: starting piece 1 at 17-JUN-10
channel t2: finished piece 1 at 17-JUN-10
piece handle=5olgfhlp_1_1 tag=DB_KIEUHOI_L0 comment=API Version 2.0,MMS Version 4.5.0.0
channel t2: backup set complete, elapsed time: 00:00:03
channel t1: finished piece 1 at 17-JUN-10
piece handle=5llgfhjb_1_1 tag=DB_KIEUHOI_L0 comment=API Version 2.0,MMS Version 4.5.0.0
channel t1: backup set complete, elapsed time: 00:01:46
Finished backup at 17-JUN-10

sql statement: alter system archive log current

Starting backup at 17-JUN-10
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=5827 recid=5725 stamp=721929944
channel t1: starting piece 1 at 17-JUN-10
channel t2: starting archive log backupset
channel t2: specifying archive log(s) in backup set
input archive log thread=1 sequence=5828 recid=5726 stamp=721929944
channel t2: starting piece 1 at 17-JUN-10
channel t1: finished piece 1 at 17-JUN-10
piece handle=5plgfhmo_1_1 tag=DB_KIEUHOI_ARCHIVELOG_L0 comment=API Version 2.0,MMS Version 4.5.0.0
channel t1: backup set complete, elapsed time: 00:00:04
channel t1: deleting archive log(s)
archive log filename=/u07/archive/kieuhoi/1_5827_659697255.dbf recid=5725 stamp=721929944
channel t2: finished piece 1 at 17-JUN-10
piece handle=5qlgfhmo_1_1 tag=DB_KIEUHOI_ARCHIVELOG_L0 comment=API Version 2.0,MMS Version 4.5.0.0
channel t2: backup set complete, elapsed time: 00:00:04
channel t2: deleting archive log(s)
archive log filename=/u07/archive/kieuhoi/1_5828_659697255.dbf recid=5726 stamp=721929944
Finished backup at 17-JUN-10

Starting backup at 17-JUN-10
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel t1: starting piece 1 at 17-JUN-10
channel t1: finished piece 1 at 17-JUN-10
piece handle=5rlgfhmt_1_1 tag=DB_KIEUHOI_SPFILE_L0 comment=API Version 2.0,MMS Version 4.5.0.0
channel t1: backup set complete, elapsed time: 00:00:03
Finished backup at 17-JUN-10

Starting backup at 17-JUN-10
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
including current control file in backupset
channel t1: starting piece 1 at 17-JUN-10
channel t1: finished piece 1 at 17-JUN-10
piece handle=5slgfhn0_1_1 tag=DB_KIEUHOI_CONTROLFILE_L0 comment=API Version 2.0,MMS Version 4.5.0.0
channel t1: backup set complete, elapsed time: 00:00:04
Finished backup at 17-JUN-10

released channel: t1

released channel: t2

Recovery Manager complete.

When I restore the error appear like :

RMAN> run {
2> shutdown immediate;
3> startup nomount;
4> allocate channel t1 type 'SBT_TAPE';
5> allocate channel t2 type 'SBT_TAPE'
6> send 'NSR_ENV=(NSR_SERVER=ghost-svr,NSR_CLIENT=db-kieuhoi.eab.com.vn)';
7> restore controlfile from '5slgfhn0_1_1';
8> sql 'alter database mount';
9> restore database;
10> recover database;
11> release channel t1;
12> release channel t2;
13> }
14>
using target database control file instead of recovery catalog
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started

Total System Global Area    2147483648 bytes

Fixed Size                     1268508 bytes
Variable Size                486540516 bytes
Database Buffers            1644167168 bytes
Redo Buffers                  15507456 bytes

allocated channel: t1
channel t1: sid=1092 devtype=SBT_TAPE
channel t1: NMO v4.5.0.0

allocated channel: t2
channel t2: sid=1091 devtype=SBT_TAPE
channel t2: NMO v4.5.0.0

Starting restore at 17-JUN-10

channel t2: restoring control file
channel t2: restore complete, elapsed time: 00:00:07
output filename=/u03/m1/control/kieuhoi/control_kieuhoi_01.ctl
output filename=/u03/m2/control/kieuhoi/control_kieuhoi_02.ctl
Finished restore at 17-JUN-10

sql statement: alter database mount

Starting restore at 17-JUN-10
Starting implicit crosscheck backup at 17-JUN-10
Finished implicit crosscheck backup at 17-JUN-10

Starting implicit crosscheck copy at 17-JUN-10
Finished implicit crosscheck copy at 17-JUN-10

searching for all files in the recovery area
cataloging files...
no files cataloged

skipping datafile 4; already restored to file /u02/oradata/kieuhoi/users01.dbf
skipping datafile 5; already restored to file /u02/oradata/kieuhoi/KIEUHOI_01.dbf
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u02/oradata/kieuhoi/system01.dbf
restoring datafile 00002 to /u02/oradata/kieuhoi/undotbs01.dbf
restoring datafile 00003 to /u02/oradata/kieuhoi/sysaux01.dbf
channel t1: reading from backup piece 5mlgfhjb_1_1
ORA-19870: error reading backup piece 5mlgfhjb_1_1
ORA-19507: failed to retrieve sequential file, handle="5mlgfhjb_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Could not locate the LNM save file '5mlgfhjb_1_1' on server 'ghost-svr.eab.com.vn'. (2:9:2)
failover to previous backup

;

;

;

released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/17/2010 16:25:36
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

Recovery Manager complete.

Please help me to solve this problem

Many Thanks,