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

[Eric LO]

Hi TG,

I need to install "Legato or Vertia or Onmi backup software to get media management library, then I can use RMAN to backup database to tape device directly. right?

[malay boy]

For big database I suggest backup to disk first then to tape.That the backup strategy we use for our production database.The reason is shorter backup time..Backup to disk save us 1 hour of backup time compared to backup to tape.

regards mB

[T G Manikandan]

Eric,
You got it!

you are right!
Another important thing is that the media management along with RMAN works great with tape like to choose the right tape for restore,etc.

Legato comes with Oracle.
Run the installer select Legato and install it with the existing components.


All the Best!

[Eric LO]

Dear all,

Thanks for your kindly support, the problem has been clearly now.
Have a nice day.

Best regards,
Eric

[Yogeeraj_1]

hi,

By default $ORACLE_HOME/lib/libobk.sl is linked to libdsbtsh8.sl

For the media management software you are installing, you should do the appropriate link. Remember to shutdown the database for performing this operation is crucial.

If you go for legato, again note that Legato Storage Manager is a media manager bundled with Oracle on HP-UX. See Legato Storage Manager Administrator???s Guide.

hope this helps too!

regards
Yogeeraj

[Murat SULUHAN]

Hi

We have 2 HPUX and diskarray with serviceguard cluster, omniback and oracle is installed with cluster integration support, omniback and oracle runs separate nodes by default

I have 2 problems

I have currently 3 instances and they are running on same node, when I configured dataprotector 5.0 for last instance, and tried to backup I am getting this error

................
...............
input datafile fno=00006 name=/oracle/OYAK/oradata/indx01.dbf
channel dev_3: starting piece 1 at 07/30/2003 [21:13:15]
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 07/30/2003 21:13:16
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-12004: unhandled exception during command execution on channel dev_0
RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential file, name="OYAK_DB_Arch<500764395:1>.dbf", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
Vendor specific error: OB2_StartObjectBackup() failed ERR(-2)
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

...............................
..................................


but the backup configurations of other instances run "correctly", I am not figured out why

the another problem, when I want to configure new Oracle backup, Dataprotector can see only cluster nodes, it could not see Oracle package on cluster,

Could you help me


Best Regards
Murat

[John Hall]

I've read other answers in other forums that talk about the "piece" being too large that is being written to tape. The piece size can be controlled by using the "filesperset" parameter:

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