Re: Oracle Backup with Veritas

From: Eddy Vagapov <eddyv_at_udm.net>
Date: Mon, 01 Sep 2003 20:06:31 +0500
Message-ID: <3F536077.6070803@udm.net>

Hello, Sybrand Bakker!

   Thank you for answer...
   But, I must replace 'SBT_TAPE' and
   wrote '/dev/rmt/0un' or name my tape drive?

Best Regards,
Eddy
e-mail: eddyv_at_udm.net

Sybrand Bakker wrote:
"Eddy Vagapov" <eddyv_at_udm.net> wrote in message news:3F521303.20807_at_udm.net...

Hello All!

Sorry for mine english...

I'am have Oracle version 8.1.7 in sparc platform and Veritas Netbackup Datacenter 4.5
For backuping Oracle, Veritas start script. Script make following steps:

Shutdown database (shutdown immediate)
Mount database (database is not active mode)
Call rman (Recover manager) with commands: rman target system/manager nocatalog msglog backup1.out << EOF RUN { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE'; BACKUP INCREMENTAL LEVEL=0 FORMAT 'bk_u%u_s%s_p%p_t%t' DATABASE; sql 'alter database open'; RELEASE CHANNEL ch00; RELEASE CHANNEL ch01; } EOF

log file backup1.out:

Recovery Manager: Release 8.1.7.0.0 - Production RMAN-06005: connected to target database: GF4_0_4 (DBID=549212598) RMAN-06009: using target database controlfile instead of recovery

catalog

<skip>
RMAN-08008: channel ch00: starting incremental level 0 datafile

backupset

  RMAN-08502: set_count=17 set_stamp=503258612 creation_time=28-AUG-03 RMAN-08010: channel ch00: specifying datafile(s) in backupset   RMAN-08522: input datafile fno=00004
name=/se3510/ORA_DATA/dbs/TSDATAGF4_0_4.dbf   RMAN-08522: input datafile fno=00001
name=/se3510/ORA_DATA/dbs/dbsGF4_0_4.dbf   RMAN-08011: including current controlfile in backupset   RMAN-08008: channel ch01: starting incremental level 0 datafile

backupset

  RMAN-08502: set_count=18 set_stamp=503258612 creation_time=28-AUG-03
  RMAN-08010: channel ch01: specifying datafile(s) in backupset
  RMAN-08522: input datafile fno=00002

name=/se3510/ORA_DATA/dbs/rollbackGF4_0_4.dbf RMAN-08522: input datafile fno=00005
name=/se3510/ORA_DATA/dbs/TSINDEXGF4_0_4.dbf RMAN-08522: input datafile fno=00003
name=/se3510/ORA_DATA/dbs/tempGF4_0_4.dbf

  RMAN-00571: ===========================================================
  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  RMAN-00571: ===========================================================
  RMAN-03007: retryable error occurred during execution of command: backup

RMAN-07004: unhandled exception during command execution on channel ch00 RMAN-10035: exception raised in RPC:

ORA-19506: failed to create sequential file, name="bk_u0hevu7fk_s17_p1_t503258612", parms=""

              ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: sbtbackup: Failed to open for backup.   RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
  RMAN>
  RMAN-08031: released channel: ch00
  RMAN-08031: released channel: ch01

Recovery Manager complete.

Installation of Veritas, was successfully. Manual of Veritas have troubleshooting part, in this part says: if you get this log (see is higher) you not make properly linked library $ORACLE_HOME/lib/libobk.so. (ln -s $VERITAS_INSTALL_PATH/bin/libobk.so.1 $ORACLE_HOME/lib/libobk.so) But this procedure (linking library) I'am make proper! Somebody resolve this problem?
Please, help...

With best regard,
Eddy
e-mail: eddyv_at_udm.net Received on Mon Sep 01 2003 - 10:06:31 CDT