Re: Oracle Backup with Veritas

"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:
> 1. Shutdown database (shutdown immediate)
> 2. Mount database (database is not active mode)
> 3. 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
>
>
>

The message tells you it can't access the tape drive. Usually a specification
type 'sbt_tape'
is insufficient and you need extra parameters to address the tape.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address