Solved

rman duplication using channel tape instead of disk...

Posted on 2011-03-10
5
1,719 Views
Last Modified: 2012-05-11
I took a cold backup yesterday and transferred to destination. Daily source db goes to tape, i changed to disk and took a bakup.

After giving rman duplicaiton, its still using the TABE instead of disk.

Here is the rman config

 rman target sys/erpbfsys@ERPBF auxiliary sys/erpvissys@ERPVIS

Recovery Manager: Release 11.1.0.7.0 - Production on Thu Mar 10 16:19:38 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ERPBF (DBID=284703557)
connected to auxiliary database: ERPVIS (not mounted)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ERPBF are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'DISK';
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/u01/erpbf_backup/%U';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 3 TIMES TO 'DISK';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/db/tech_st/11.1.0/dbs/snapcf_ERPBF.f'; # default

The backup is saved at '/u01/erpbf_backup/%U';
0
Comment
Question by:Dba_Oracledb2
  • 2
  • 2
5 Comments
 

Author Comment

by:Dba_Oracledb2
ID: 35099878
RMAN> CONFIGURE CHANNEL DEVICE TYPE SBT_TAPE clear;

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1';
old RMAN configuration parameters are successfully deleted
released channel: ORA_AUX_SBT_TAPE_1
released channel: ORA_AUX_SBT_TAPE_2
released channel: ORA_AUX_SBT_TAPE_3
released channel: ORA_AUX_DISK_1
released channel: ORA_AUX_DISK_2
released channel: ORA_AUX_DISK_3

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT = '/u01/erpbf_backup/%U';

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/u01/erpbf_backup/%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/u01/erpbf_backup/%U';
new RMAN configuration parameters are successfully stored

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored

0
 

Author Comment

by:Dba_Oracledb2
ID: 35099884

RMAN> duplicate target database to ERPVIS;

Starting Duplicate Db at 10-MAR-11
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/10/2011 16:26:38
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2
0
 
LVL 4

Expert Comment

by:pinkuray
ID: 35106533
You error is similar to posted in other webpages:
Try to check these links:

http://www.orafaq.com/forum/m/328289/0/?srch=rman+clear#msg_328289

check this link: http://www.orafaq.com/forum/t/50239/2/

0
 
LVL 4

Accepted Solution

by:
pinkuray earned 250 total points
ID: 35106538
I think you need to do a show all; under in RMAN and then config SBT_TAPE device which will solve your problem.

0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 35108620
pinukuray,

They have already tried CLEAR of SBT_TAPE.  It was posted in http:#a35099878

Dba_Oracledb2,

I've never done a live duplication so most of what I'm posting is from research in the docs.



http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#i1008564


Step 1: Choosing a Duplication Technique

¿The DUPLICATE command requires at least one auxiliary channel to perform the work of the duplication on the auxiliary instance.


That get's you to:
http://download.oracle.com/docs/cd/E11882_01/backup.112/e10643/rcmsynta004.htm#RCMRF89996

Example 2-9 Allocating an Auxiliary Channel for Database Duplication

Just use disk instead of tape.

0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question