- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How to use RMAN backup database to tape device...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 09:46 PM
тАО05-21-2003 09:46 PM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 09:53 PM
тАО05-21-2003 09:53 PM
Re: How to use RMAN backup database to tape device on HP-UX?
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 10:02 PM
тАО05-21-2003 10:02 PM
Re: How to use RMAN backup database to tape device on HP-UX?
Looking at your errors,
you need to definitely link RMAN with the third party media management software.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 10:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 10:12 PM
тАО05-21-2003 10:12 PM
Re: How to use RMAN backup database to tape device on HP-UX?
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 10:27 PM
тАО05-21-2003 10:27 PM
Re: How to use RMAN backup database to tape device on HP-UX?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 10:27 PM
тАО05-21-2003 10:27 PM
Re: How to use RMAN backup database to tape device on HP-UX?
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 10:38 PM
тАО05-21-2003 10:38 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 10:46 PM
тАО05-21-2003 10:46 PM
Re: How to use RMAN backup database to tape device on HP-UX?
$ORACLE_HOME/lib64/libobk.sl -> liblsm.sl
libobk.sl is linked to lsm
liblsm.sl--is for Legato Storage manager(LSM).
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 10:47 PM
тАО05-21-2003 10:47 PM
Re: How to use RMAN backup database to tape device on HP-UX?
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