Home » , , , » RMAN DATABASE BACKUPS TO TAPE

RMAN DATABASE BACKUPS TO TAPE

Written By Srikrishna Murthy Annam on Monday, May 30, 2011 | 3:54 AM

In this article, i am going to show you how to backup a database using RMAN to tape. First verify the tape configuration from the following commands ...

$ tdpoconf showenvironment
$ tdpoconf showENVironment -TDPO_OPTfile=tdpo.opt
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 5, Level 2.0
(C) Copyright IBM Corporation 1997, 2009. All rights reserved.
Data Protection for Oracle Information
Version:              5
Release:              5
Level:                2
Sublevel:             0
Platform:             64bit TDPO Linux86-64
Tivoli Storage Manager Server Information
Server Name:          TDPAURORA
Server Address:       GBTSMSERVER
Server Type:          AIX-RS/6000
Server Port:          1500
Communication Method: TCP/IP
Session Information
Owner Name:           oracle
Node Name:            tdpb600e6tr01
Node Type:            TDPO Linux86-64
DSMI_DIR:             /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG:      /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE:         tdpo.opt
Password Directory:   /opt/tivoli/tsm/client/oracle/bin64
Compression:          FALSE
License Information:  License file exists and contains valid license data.
[oracle@b600e6tr01 tdpo]$

In this demo i am showing RMAN consistant backup , so shutdown the database and start it again in mount stage.

Then connect to database using rman with catalog database ...

[oracle@b600e6tr01 bkup]$ rman target / catalog rman/rman@rmancat
Recovery Manager: Release 10.2.0.4.0 - Production on Mon May 2 08:51:22 2011
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database: TESTDB (DBID=38948753088)
connected to recovery catalog database
RMAN>run
{
allocate channel t1 type 'SBT_TAPE' parms="ENV=(TDPO_OPTFILE=tdpo.opt)";
allocate channel t2 type 'SBT_TAPE' parms="ENV=(TDPO_OPTFILE=tdpo.opt)";
allocate channel t3 type 'SBT_TAPE' parms="ENV=(TDPO_OPTFILE=tdpo.opt)";
backup as compressed backupset check logical incremental level 0 database format 'backup_%d_%I_set%s_piece%p_copy%c_%T_%U' TAG=FULL_BACKUP;
backup current controlfile TAG=CURR_CTLFILE;
backup spfile TAG=CURR_SPFILE;
delete obsolete;
}

This will complete the backup of database. But in case if you get any error messages due to tape configuration problems, RMAN will not give you any useful error message. All you have to do is, go to the log file location specified in the configuration file tdpo.opt ( parameter  DSMI_LOG ) and review the logfiles. If you dont have this directory created, the default location for tape log files is $ORACLE_HOME/dbs. These log files will give you some useful error messages.

Rectify the issues  and  execute the RMAN backup script again.

Example error messages from RMAN session :

Starting restore at Apr 13 2011 07:41:20
using channel ORA_AUX_SBT_TAPE_1
using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/13/2011 07:41:22
RMAN-03015: error occurred in stored script Memory Script
ORA-27191: sbtinfo2 returned error
Additional information: 2


Follow the following video demo showing how to bakckup a database to tape. This is a private video so, send me a personal request if you need access to this video.

[youtube http://www.youtube.com/watch?v=qcF6oG9s3Gk&hl=en&fs=1]

Hope it helps

SRI
Share this article :

Related Articles By Category



+ comments + 28 comments

Kamal Ahmed Mohammed
November 1, 2011 at 4:50 AM

Please give me access to the video as i have the same issue.

THanks
Kamal

learnwithme11g
November 3, 2011 at 1:05 PM

Hi Ahmed,
You are given access to these videos. You will have this access for next three days. Thanks for your interest to this article.
Thanks
SRI

Suad Adrovic
November 24, 2011 at 11:31 AM

Can you please give me access to the video.

learnwithme11g
December 6, 2011 at 2:56 AM

you are given access to this video now.

Suad Adrovic
December 8, 2011 at 7:17 AM

I still can’t see the videos!?
Please can you give me access to the video. My mail is suadhm@gmail.com

Thank you.

samz
January 20, 2012 at 2:51 AM

Hi Sri

Could you please give me the access of this video?

ansar
February 17, 2012 at 2:40 AM

plz send the access of this video

learnwithme11g
February 19, 2012 at 3:48 AM

Hi Ansar, you are given access to this video.
Thanks
SRI

Mirza
March 24, 2012 at 4:16 PM

please provide me with an access to view this video.

Sabareesh. V
April 19, 2012 at 5:44 AM

Hi Sri,

Kindly give access to this video pls.

learnwithme11g
May 1, 2012 at 5:29 AM

Hi Sabareesh, you are given access to this video.

Shahzad
June 13, 2012 at 1:35 PM

Hello SRI
I also want to access this video

Sanjay
February 21, 2013 at 12:05 AM

Please provide access

Sharif
March 6, 2013 at 5:29 PM

please let me the access

Mark
March 15, 2013 at 3:27 PM

please give me accesd to video

Samik
March 30, 2013 at 3:11 AM

Please give me access to this video. Thanks a lot in adnvance

Gayathri
May 4, 2013 at 4:15 AM

hi,pls give me access to this video.thanks
Gayathri

Srikrishna Murthy Annam
May 4, 2013 at 2:01 PM

Hi Gayathri,
Thank you for your interest in the blog content. Unfortunately i can't add any mail other than gmail to the youtube content. Do you have gmail id so that i can give you access to the video?
Thanks
SRI

May 16, 2013 at 3:04 PM

I am interested in your video, can you give me access?

Srikrishna Murthy Annam
May 17, 2013 at 1:01 PM

Hi You are given access to the video. Thanks

Srikrishna Murthy Annam
May 17, 2013 at 1:02 PM

Hi You are given access to the video.
Thanks

Sujith
June 16, 2013 at 12:22 AM

Hi could you pls help to learn the backup to tape ,Please give me access to the video as i have the same issue.

thanks
Sujith

rakesh
June 16, 2013 at 4:52 AM

can you please give access to these video

yatin
June 24, 2013 at 10:03 PM

hi
can you please give me access to the video

August 10, 2013 at 1:56 PM

Can you please give me access to this video

sanga reddy
August 30, 2013 at 9:23 AM

Hi sri,

Please give me access to this video.

Toby
October 5, 2013 at 7:37 PM

Please give me access to the video

Emir
November 27, 2013 at 3:20 PM

very nice! I love it ..... awesome job

Post a Comment

Thank you for visiting our site and leaving your valuable comment.

 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger