Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Eric LO
Occasional Contributor

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


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
16 REPLIES
Steven E. Protter
Exalted Contributor

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

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
T G Manikandan
Honored Contributor

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

HI,

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


malay boy
Trusted Contributor
Solution

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

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

see the attachment.

Good luck

regards
mB
There are three person in my team-Me ,myself and I.
Eric LO
Occasional Contributor

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

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
Honored Contributor

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

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Eric LO
Occasional Contributor

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

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
Honored Contributor

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


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
Honored Contributor

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

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
Honored Contributor

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

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
Occasional Contributor

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

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
Trusted Contributor

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

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
There are three person in my team-Me ,myself and I.
T G Manikandan
Honored Contributor

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

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
Occasional Contributor

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

Dear all,

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

Best regards,
Eric
Yogeeraj_1
Honored Contributor

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

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

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Murat SULUHAN
Honored Contributor

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

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
Murat Suluhan
John Hall
Frequent Advisor

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

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;
}