I installed a new machine xyz (Sun with Solaris 9), my colleague installed Oracle9; next we moved the databasefiles from the host abc to xyz and renamed xyz to abc so users do not need to change their configs. File Backup of this client works fine but RMAN backups fail!?
root@abc /home/oracle/VeritasNetBackup/logfiles-USUNEU:> more fullbackup.USUNEU.Tue.log
starting backup Tue Mar 28 18:23:49 CEST 2006
stty: : No such device or address
neric May 2002
Recovery Manager: Release 9.2.0.6.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN>
connected to recovery catalog database
RMAN>
connected to target database: USUNEU (DBID=586190995)
RMAN> 2> 3> 4> 5> 6> 7>
allocated channel: t1
channel t1: sid=11 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 4.5FP_3GA (2002121901)
Starting backup at 28.03.06
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2655 recid=5846 stamp=585840591
input archive log thread=1 sequence=2656 recid=5847 stamp=585973156
input archive log thread=1 sequence=2657 recid=5848 stamp=586126163
input archive log thread=1 sequence=2658 recid=5849 stamp=586186768
input archive log thread=1 sequence=2659 recid=5850 stamp=586256972
channel t1: starting piece 1 at 28.03.06
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 03/28/2006 18:39:17
ORA-19506: failed to create sequential file, name="97hf451n_1_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
Failed to open for backup.
RMAN>
Recovery Manager complete.
finished backup Tue Mar 28 18:39:18 CEST 2006
root@abc /home/oracle/VeritasNetBackup/logfiles-USUNEU:>
This is the RMAN Script, which did not change:
root@abc /home/oracle/VeritasNetBackup/logfiles-USUNEU:> more ../bin/fullbackup.USUNEU.sh
#!/bin/sh
su - oracle -c "ORACLE_SID=USUNEU; export ORACLE_SID; rman <<EOF
connect rcvcat rman/rman@SAVEDB.MYDOMAIN.DE
connect target
run {
allocate channel t1 type 'SBT_TAPE';
backup archivelog until time = 'sysdate' delete input;
backup full database;
backup current controlfile;
release channel t1;
}
EOF"
root@abc /home/oracle/VeritasNetBackup/logfiles-USUNEU:>
any ideas?
Best Regards, Franz
--
Solaris System Manager from Munich, Germany
I used to work for Sun Microsystems Support (EMEA) for 5 years in the domain of the OS, Backup and Storage
root@abc /home/oracle/VeritasNetBackup/logfiles-USUNEU:> more fullbackup.USUNEU.Tue.log
starting backup Tue Mar 28 18:23:49 CEST 2006
stty: : No such device or address
neric May 2002
Recovery Manager: Release 9.2.0.6.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN>
connected to recovery catalog database
RMAN>
connected to target database: USUNEU (DBID=586190995)
RMAN> 2> 3> 4> 5> 6> 7>
allocated channel: t1
channel t1: sid=11 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 4.5FP_3GA (2002121901)
Starting backup at 28.03.06
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2655 recid=5846 stamp=585840591
input archive log thread=1 sequence=2656 recid=5847 stamp=585973156
input archive log thread=1 sequence=2657 recid=5848 stamp=586126163
input archive log thread=1 sequence=2658 recid=5849 stamp=586186768
input archive log thread=1 sequence=2659 recid=5850 stamp=586256972
channel t1: starting piece 1 at 28.03.06
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 03/28/2006 18:39:17
ORA-19506: failed to create sequential file, name="97hf451n_1_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
Failed to open for backup.
RMAN>
Recovery Manager complete.
finished backup Tue Mar 28 18:39:18 CEST 2006
root@abc /home/oracle/VeritasNetBackup/logfiles-USUNEU:>
This is the RMAN Script, which did not change:
root@abc /home/oracle/VeritasNetBackup/logfiles-USUNEU:> more ../bin/fullbackup.USUNEU.sh
#!/bin/sh
su - oracle -c "ORACLE_SID=USUNEU; export ORACLE_SID; rman <<EOF
connect rcvcat rman/rman@SAVEDB.MYDOMAIN.DE
connect target
run {
allocate channel t1 type 'SBT_TAPE';
backup archivelog until time = 'sysdate' delete input;
backup full database;
backup current controlfile;
release channel t1;
}
EOF"
root@abc /home/oracle/VeritasNetBackup/logfiles-USUNEU:>
any ideas?
Best Regards, Franz
--
Solaris System Manager from Munich, Germany
I used to work for Sun Microsystems Support (EMEA) for 5 years in the domain of the OS, Backup and Storage