Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

moved Oracle DB to new host -> RMAN does not backup

Status
Not open for further replies.

daFranze

Technical User
Dec 29, 2003
1,334
DE
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
 
guess I just fixed it myself... ;-)

>> and renamed xyz to abc so users do not need to change their configs.

just grepped in all files under /usr/openv for the first hostname; though I (re)installed the NBu Client after renaming the host the old name is still in the config files...
I changed the clientname in
* /usr/openv/netbackup/bp.conf
* /usr/openv/java/nbj.conf
next I started the RMAN Backups and as far as I can see it works fine...

Oracle Metalink says it might be a read only of /usr/openv/netbackup/logs, which I chmod' to rwxrwxrwx


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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top