Hi,
I'm having trouble cataloging my Old Backups from SBT_TAPE.
I want to RMAN to Read and Catalog all the backupsets from tape, I ran the following without luck.
We tried the following:
#####################################################################################
RMAN> catalog device type 'SBT_TAPE' backuppiece '*';
released channel: ORA_SBT_TAPE_1
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=1351 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: NMDA Oracle v1.2.0
ORA-19870: error while restoring backup piece *
ORA-19507: failed to retrieve sequential file, handle="*", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Could not locate the LNM save file '*' on server 'mtcngnbknetwsrv'. (2:9:2)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 06/20/2014 11:31:29
RMAN-06209: List of failed objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece *
#####################################################################################
Then we also tried to pass the ALLOCATE CHANNEL and PARMS:
##########################################################################################################################################################################
RMAN> RUN
{
ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' PARMS='ENV=(NSR_SERVER=mtcngnbknetwsrv,NSR_CLIENT=mtcifsdb01,NSR_DATA_VOLUME_POOL=VL923)';
catalog device type 'SBT_TAPE' backuppiece 'FULL_IFSPROD_nupb8gkl_1_1';
}2> 3> 4> 5>
allocated channel: t1
channel t1: SID=1351 device type=SBT_TAPE
channel t1: NMDA Oracle v1.2.0
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 06/20/2014 11:34:03
RMAN-06470: DEVICE TYPE is supported only when automatic channels are used
##########################################################################################################################################################################
I do not know the backupset names on tape, neither do I have the backupset names my recovery catalog, I want to catalog any backups found from SBT_TAPE.
Regards
Stephan