Hello,
I am using DP5.5. with Oracle10g environment for backup and restore operations.
While I was able to successfully able to allocate the channels I am getting the below error message stack when the backup script is executed.
Could anybody provide some pointers and guidance as to how I should proceed and what else needs to be looked .
The error message that is seen is
ORA-07863: ssfduic: $PARSE failure (filename syntax)
and SBT error ::7011.
I have also added the RMAN "SHOW ALL" command with this note in case any changes needed there.
*************************************************************************************
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3> parms 'SBT_LIBRARY=sys$share:libobk2shr32.exe ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=full-bkup)';
4> allocate channel 'dev_1' type 'sbt_tape'
5> parms 'SBT_LIBRARY=sys$share:libobk2shr32.exe ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=full-bkup)';
6> allocate channel 'dev_2' type 'sbt_tape'
7> parms 'SBT_LIBRARY=sys$share:libobk2shr32.exe ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD,OB2BARLIST=full-bkup)';
8> backup incremental level 0
9> format 'full-bkup<PROD_%s:%t:%p>.dbf'
10> tablespace USERS;
11> }
12>
allocated channel: dev_0
channel dev_0: sid=142 devtype=SBT_TAPE
channel dev_0: MMS Version 65.5.50.0
allocated channel: dev_1
channel dev_1: sid=146 devtype=SBT_TAPE
channel dev_1: MMS Version 65.5.50.0
allocated channel: dev_2
channel dev_2: sid=145 devtype=SBT_TAPE
channel dev_2: MMS Version 65.5.50.0
Starting backup at 11/09/05 17:49:14
channel dev_0: starting incremental level 0 datafile backupset
channel dev_0: specifying datafile(s) in backupset
input datafile fno=00004 name=sys$sysdevice:[oracle10g.oradata.prod]users01.dbf
channel dev_0: starting piece 1 at 11/09/05 17:49:15
[Normal] From: BMA@iavms2.india.hp.com "filedev" Time: 11/9/2005 9:48:15 AM
STARTING Media Agent "filedev"
[Normal] From: OB2BAR_Oracle8@iprvms1.india.hp.com "PROD" Time: 11/9/2005 3:19:47 PM
Starting OB2BAR Backup: iprvms1.india.hp.com:` "Oracle8"
[Normal] From: BMA@iavms2.india.hp.com "filedev" Time: 11/9/2005 9:48:34 AM
omni$root:[tmp]nardev.dat
Initializing new medium: "Default File_321"
[Normal] From: OB2BAR_Oracle8@iprvms1.india.hp.com "PROD" Time: 11/9/2005 3:20:01 PM
Completed OB2BAR Backup: iprvms1.india.hp.com:` "Oracle8"
RMAN-03009: failure of backup command on dev_0 channel at 11/09/2005 17:50:56
ORA-07863: ssfduic: $PARSE failure (filename syntax)
%RMS-F-SYN, file specification syntax error
channel dev_0 disabled, job failed on it will be run on another channel
channel dev_1: starting incremental level 0 datafile backupset
channel dev_1: specifying datafile(s) in backupset
input datafile fno=00004 name=sys$sysdevice:[oracle10g.oradata.prod]users01.dbf
channel dev_1: starting piece 1 at 11/09/05 17:50:56
[Major] From: OB2BAR_Oracle8@iprvms1.india.hp.com "PROD" Time: 11/9/2005 3:20:57 PM
Received ABORT request from BSM (ERR: Set name is duplicated. )
RMAN-03009: failure of backup command on dev_1 channel at 11/09/2005 17:50:59
ORA-19506: failed to create sequential file, name="full-bkup<PROD_61:573933056:1>.dbf", parms=""
ORA-27007: failed to open file
%SYSTEM-I-NOMSG, Message number 00001B63 - %SYSTEM-S-NORMAL, normal successful completion
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 0, sbtopen: system error
channel dev_1 disabled, job failed on it will be run on another channel
channel dev_2: starting incremental level 0 datafile backupset
channel dev_2: specifying datafile(s) in backupset
input datafile fno=00004 name=sys$sysdevice:[oracle10g.oradata.prod]users01.dbf
channel dev_2: starting piece 1 at 11/09/05 17:51:00
[Major] From: OB2BAR_Oracle8@iprvms1.india.hp.com "PROD" Time: 11/9/2005 3:21:00 PM
Received ABORT request from BSM (ERR: Set name is duplicated. )
released channel: dev_0
released channel: dev_1
released channel: dev_2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev_2 channel at 11/09/2005 17:51:01
ORA-19506: failed to create sequential file, name="full-bkup<PROD_62:573933060:1>.dbf", parms=""
ORA-27007: failed to open file
%SYSTEM-I-NOMSG, Message number 00001B63 - %SYSTEM-S-NORMAL, normal successful completion
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 0, sbtopen: system error
Recovery Manager complete.
[Major] From: OB2RMAN@iprvms1.india.hp.com "" Time: 11/09/05 17:51:03
Oracle RMAN command failed with exit status 2.
[Normal] From: OB2RMAN@iprvms1.india.hp.com "" Time: 11/09/05 17:51:03
There are no errors in the Data Protector SBT library.
*********************************************************************************************
*********************************************************************************************
RMAN>SHOW ALL
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO 'DKA100:[O
RACLE10G.oradata.PROD]]%d_%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM
1;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=sys$share:libobk2sh
r32.exe ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PROD)';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'DKA100:[000000.ORACLE10G]%d_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'sys$sysdevice:[oracle10g.oradata.prod]sn
apcf_prod.f'; # default
******************************************************************************************
Any inputs greatly appreciated.
Thanks in advance,
Anup