Oracle Technologies Blog

By ASKM

RMAN DATABASE BACKUPS TO TAPE

Posted by Srikrishna Murthy Annam on May 30, 2011

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.

Hope it helps

SRI

Advertisements

32 Responses to “RMAN DATABASE BACKUPS TO TAPE”

  1. Kamal Ahmed Mohammed said

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

    THanks
    Kamal

  2. learnwithme11g said

    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

  3. Suad Adrovic said

    Can you please give me access to the video.

  4. learnwithme11g said

    you are given access to this video now.

  5. Suad Adrovic said

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

    Thank you.

  6. samz said

    Hi Sri

    Could you please give me the access of this video?

  7. ansar said

    plz send the access of this video

  8. learnwithme11g said

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

  9. Mirza said

    please provide me with an access to view this video.

  10. Sabareesh. V said

    Hi Sri,

    Kindly give access to this video pls.

  11. learnwithme11g said

    Hi Sabareesh, you are given access to this video.

  12. Shahzad said

    Hello SRI
    I also want to access this video

  13. Sanjay said

    Please provide access

  14. Sharif said

    please let me the access

  15. Mark said

    please give me accesd to video

  16. Samik said

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

  17. Gayathri said

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

  18. Srikrishna Murthy Annam said

    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

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

  20. Srikrishna Murthy Annam said

    Hi You are given access to the video. Thanks

  21. Srikrishna Murthy Annam said

    Hi You are given access to the video.
    Thanks

  22. Sujith said

    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

  23. rakesh said

    can you please give access to these video

  24. yatin said

    hi
    can you please give me access to the video

  25. gopalmadi said

    Can you please give me access to this video

  26. sanga reddy said

    Hi sri,

    Please give me access to this video.

  27. Toby said

    Please give me access to the video

  28. Emir said

    very nice! I love it ….. awesome job

  29. ayyappan said

    please grant access to ayyappandba@gmail.com

  30. jaffar said

    I also need access to view this video – jafdbasg@gmail.com

  31. Claura Tam said

    can you please give me access to this video

  32. kamesh said

    Hi sri,,

    Please give me the acess to the above videos

    Thanks inadvance

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: