How to use RMAN backup database to tape device on HP-UX?

[Eric LO]

Hi all,
My OS is HP-UX11.00, Oracle version is 8.1.7. I have one tape device that name is "/dev/rmt/0m". How do I use RMAN to backup database to tape device without 3-party backup software?
Now I only can backup to disk with type "SBT_TAPE", following as detail output from RMAN while I do backup process. Thanks very much for your support.

Part 1, With error

RMAN> run {
2> allocate channel c1 type 'sbt_tape'
3> parms="ENV=(BACKUP_DIR=/dev/rmt/0m)";
4> backup tablespace system;
5> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=12 devtype=SBT_TAPE
RMAN-08526: channel c1: WARNING: Oracle Test Disk API

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel c1: starting full datafile backupset
RMAN-08502: set_count=1 set_stamp=494673366 creation_time=22-MAY-03
RMAN-08010: channel c1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00001 name=/home/st205/DATA/DISK1/system01.dbf
RMAN-08011: including current controlfile in backupset
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 c1
RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential file, name="01eno7em_1_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: sbtpvt_catalog_open: File /dev/rmt/0m/Oracle_Disk_SBT_Catalog, open error, errno = 20
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Part 2, Normal

RMAN> run {
2> allocate channel c1 type 'sbt_tape'
3> parms="ENV=(BACKUP_DIR=/home/st205/catalogs)";
4> backup database;
5> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=12 devtype=SBT_TAPE
RMAN-08526: channel c1: WARNING: Oracle Test Disk API

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel c1: starting full datafile backupset
RMAN-08502: set_count=5 set_stamp=494674506 creation_time=22-MAY-03
RMAN-08010: channel c1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00001 name=/home/st205/DATA/DISK1/system01.dbf
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00005 name=/home/st205/DATA/DISK3/data01.dbf
RMAN-08522: input datafile fno=00007 name=/home/st205/DATA/DISK2/rbs01.dbf
RMAN-08522: input datafile fno=00002 name=/home/st205/DATA/DISK2/temp01.dbf
RMAN-08522: input datafile fno=00003 name=/home/st205/DATA/DISK2/indx01.dbf
RMAN-08522: input datafile fno=00004 name=/home/st205/DATA/DISK3/oemrep01.dbf
RMAN-08522: input datafile fno=00006 name=/home/st205/DATA/DISK1/query01.dbf
RMAN-08013: channel c1: piece 1 created
RMAN-08503: piece handle=05eno8ia_1_1 comment=API Version 2.0,MMS Version 8.1.3.
0
RMAN-08525: backup set complete, elapsed time: 00:00:26
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-08031: released channel: c1

[Steven E. Protter]

The way we did it was first write to disk.

Then we made a tarball with the tar command.

Then we gzipped the file.

Then we let omniback or Veritas transfer the file to tape.

If you search itrc you will probably find a working script that goes directly to tape, but that will run slower and fail if the tape's write tab is wrong or its not in the drive or library on time.

The disk will always be there, we keep a filesystem called /backups.

The reason its better to go to disk for cold backups is that it lessens downtime.

SEP

[T G Manikandan]

HI,

Looking at your errors,
you need to definitely link RMAN with the third party media management software.

[malay boy · Accepted solution]

Hi ,
Master TG is correct.Below are the note from Metalink : Note:1061742.6 .

see the attachment.

Good luck

regards
mB

[Eric LO]

Hi Steven,

Thanks for your reply. I just want to know, does RMAN backup the database to tape device directly without third-party software? I don't want to backup it to file system and then use tar or fbackup or cpio write to tape. If RMAN can write data to tape like as to disk, how to implement it?

[Yogeeraj_1]

hi,

you will definitely need the Management software as TG mentioned above.

By default, I think Legato Networker is installed with Oracle 8.1.7

Me too prefer to backup to disk then send the files to tape.

regards
Yogeeraj

[Eric LO]

Hi TG & MB,
Thanks for your reply.

But I can't get /usr/lib/libobk.a, and # ll libobk.sl
lrwxrwxr-x 1 oracle oinstall 13 Mar 17 13:39 libobk.sl -> libdsbtsh
8.sl
# what libdsbtsh8.sl
libdsbtsh8.sl:

How can I get the /usr/lib/libobk.a ?

[T G Manikandan]

libobk.sl should get installed with the media management software.
OR
it should be linked with that specific shared library of
the backup software installed.


Thanks

[T G Manikandan]

For example on my system I have

$ORACLE_HOME/lib64/libobk.sl -> liblsm.sl

libobk.sl is linked to lsm
liblsm.sl--is for Legato Storage manager(LSM).

Thanks

[Brian Crabtree]

Eric,

You will have to use a Media Management Library (Omniback Oracle integration, Legato, etc) to be able to backup an Oracle database directly to tape with rman.

Also, you might want to change your allocate statement to use a "disk" rather than "sbt_tape". I don't know if it makes a difference for it, but it would bring it into the recommended examples.

Brian