Home » RDBMS Server » Backup & Recovery » How to use RMAN backup database to tape device on HP-UX?
How to use RMAN backup database to tape device on HP-UX? [message #57126] Wed, 21 May 2003 21:54 Go to next message
Eric LO
Messages: 1
Registered: May 2003
Junior Member
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
Re: How to use RMAN backup database to tape device on HP-UX? [message #57145 is a reply to message #57126] Thu, 22 May 2003 09:04 Go to previous message
ctg
Messages: 146
Registered: July 2002
Senior Member
for rman to backup to tape, you NEED to have 3rd party tape software.
Previous Topic: RE: DLT-7000 Backup
Next Topic: taking backup & recovery of database
Goto Forum:
  


Current Time: Thu Mar 28 14:11:18 CDT 2024