Rman recover

[akimziadi]

Hi, we have problem to recover oracle 9i DB using RMAN
Each time we try to recover the DB i get this error message

RMAN-03002: failure of Duplicate Db command at 10/17/2005 00:21:18
RMAN-03015: error occurred in stored script Memory Script
ORA-19507: failed to retrieve sequential file, handle="/FULL_BIP01_ach1aohm/", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
nwora_open_restore: Cannot connect to media index server 'bckctrn05'.

Any idea...

Also, another question

I have a library with 6 LTOII Tape drive, my DB is 3TB.
How much channel should i need to allocate in my rman script in order to improve by Backup/restore time.

Thanks

 

[605]

Obviously, there is an error in your script.

-----------------

At least you need one channel per drive. However, the number of streams also depend on the the parallelism for the device (target session) and also on the server parallelism.

 

[akimziadi]

Hi,

We start the recover at 15:00 and it's terminate by the error at 00:20


restoring datafile 00212 to /oracle/datafiles1/BIP01/S_ST_TRF_D/C0408/s_st_trf_c0408_d01.dbf
restoring datafile 02726 to /oracle/datafiles3/BIP01/S_BI_FRD_I/M200412/C0018/s_bi_frd_m200412_c0018_i01.dbf
restoring datafile 03108 to /oracle/datafiles3/BIP01/S_BI_TRF_D/M200412/C0286/s_bi_trf_m200412_c0286_d01.dbf
restoring datafile 06955 to /oracle/datafiles5/BIP01/S_BI_TRF_D/M200508/C0347/s_bi_trf_m200508_c0347_d01.dbf
channel t2: restored backup piece 1
piece handle=/FULL_BIP01_aah1aoc9/ tag=TAG20051016T053223 params=NULL
channel t2: restore complete
channel t2: starting datafile backupset restore
channel t2: specifying datafile(s) to restore from backup set
restoring datafile 00087 to /oracle/datafiles1/BIP01/S_BI_ACT_I/C0008/s_bi_act_c0008_i01.dbf
restoring datafile 02176 to /oracle/datafiles2/BIP01/S_BI_TRF_D/M200411/C0008/s_bi_trf_m200411_c0008_d01.dbf
restoring datafile 02435 to /oracle/datafiles4/BIP01/S_BI_TRF_D/M200509/C0460/s_bi_trf_m200509_c0460_d01.dbf
restoring datafile 02653 to /oracle/datafiles4/BIP01/S_BI_TRF_D/M200509/C1065/s_bi_trf_m200509_c1065_d01.dbf
channel t3: restored backup piece 1
piece handle=/FULL_BIP01_a6h1ao04/ tag=TAG20051016T053223 params=NULL
channel t3: restore complete
channel t3: starting datafile backupset restore
channel t3: specifying datafile(s) to restore from backup set
restoring datafile 05075 to /oracle/datafiles2/BIP01/S_BI_TRF_D/M200504/C0024/s_bi_trf_m200504_c0024_d01.dbf
restoring datafile 05085 to /oracle/datafiles2/BIP01/S_BI_TRF_D/M200504/C0090/s_bi_trf_m200504_c0090_d01.dbf
restoring datafile 05322 to /oracle/datafiles2/BIP01/S_BI_TRF_D/M200505/C0007/s_bi_trf_m200505_c0007_d01.dbf
restoring datafile 06530 to /oracle/datafiles5/BIP01/S_PROC_D/s_proc_d13.dbf
released channel: t1
released channel: t2
released channel: t3
released channel: t4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/17/2005 00:21:18
RMAN-03015: error occurred in stored script Memory Script
ORA-19507: failed to retrieve sequential file, handle="/FULL_BIP01_ach1aohm/", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
nwora_open_restore: Cannot connect to media index server 'bckctrn05'.

Recovery Manager complete.

 

[605]

Make sure that the media db is intact by running the command "nsrim -Xv".

You may also try to and set the NSR_NO_BUSY environment variable to False on the Oracle client.