I have a problem with Oracle 8.0.5 RMAN backups (they don't work) ever
since we installed a new NIC for the backup network to the database
server. Rob Worman posted a similar problem to this list a while back,
but his solution of changing the NBU configuration doesn't seem to work
for me. I changed the hostname in the oracle class config from
'dbserver' to 'dbserver-hme0', which is the backup interface. I also
changed the bp.conf SERVER entry to be the backup interface,
'nbuserver-qfe0'.
What happens is that the backup starts, takes about 20 seconds and backs
up nothing, then NBU comes back with it finishing as a status 0. The
interesting thing is that the same server has 7.3.4 EBU backups that are
working just fine. Below is the RMAN log. Any help is appreciated.
Regards,
RCA
--
---------------------------------------------------
Ryan C. Anderson United Defense L.P.
UNIX Administrator http://www.udlp.com/
(desk) 763.572.6684 (pager) 612.235.9936
ryan_anderson AT udlp DOT com Mail stop M313
---------------------------------------------------
Wed Oct 4 14:05:36 CDT 2000
Recovery Manager: Release 8.0.5.0.0 - Production
RMAN-06005: connected to target database: PRD805
RMAN-06008: connected to recovery catalog database
RMAN> run {
2> allocate channel t1 type 'SBT_TAPE';
3> backup
4> format 'db_%d_t%t_s%s_p%p'
5> (database);
6> sql 'alter system archive log current';
7> backup
8> format 'arch_%d_t%t_s%s_p%p'
9> (archivelog all delete input);
10> }
11>
12>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=62 devtype=SBT_TAPE
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting datafile backupset
RMAN-08502: set_count=317 set_stamp=410105140
RMAN-08010: channel t1: including datafile 8 in backupset
RMAN-08010: channel t1: including datafile 9 in backupset
RMAN-08010: channel t1: including datafile 10 in backupset
RMAN-08010: channel t1: including datafile 11 in backupset
RMAN-08010: channel t1: including datafile 12 in backupset
RMAN-08010: channel t1: including datafile 13 in backupset
RMAN-08010: channel t1: including datafile 14 in backupset
RMAN-08010: channel t1: including datafile 15 in backupset
RMAN-08010: channel t1: including datafile 16 in backupset
RMAN-08010: channel t1: including datafile 2 in backupset
RMAN-08010: channel t1: including datafile 3 in backupset
RMAN-08010: channel t1: including datafile 4 in backupset
RMAN-08010: channel t1: including datafile 1 in backupset
RMAN-08011: channel t1: including current controlfile in backupset
RMAN-08010: channel t1: including datafile 5 in backupset
RMAN-08010: channel t1: including datafile 6 in backupset
RMAN-08010: channel t1: including datafile 7 in backupset
RMAN-00569: ================error message stack follows================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10032: unhandled exception during execution of job step 1:
ORA-06512: at line 396
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry
possible
ORA-19506: failed to create sequential file,
name="db_PRD805_t410105140_s317_p1", parms=""
ORA-27006: sbtremove returned error
SVR4 Error: 17493288: Unknown system error
Additional information: -268456584
Additional information: 1
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 408
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
Recovery Manager complete.
Wed Oct 4 14:05:52 CDT 2000
|