Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Oracle RMAN

Posted on 2012-08-30
5
Medium Priority
?
884 Views
Last Modified: 2012-08-31
O.S. Linux
Oracle Version:  10g

Hi,
I've newbie with Oracle RMAN and in particular I did not understand the concept of channels (ALLOCATE CHANNEL TYPE disk......).
I think it is the way to call side RMAN server processes that physically write the backup.
RMAN can improve backup performance by parallelizing operations using multiple channels.

What steps do I need to use RMAN and understand the ALLOCATE CHANNEL?

Can I allocate multiple channels simultaneously?

Thanks in advance!
0
Comment
Question by:ralph_rea
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:geiar99
ID: 38349466
Hi,

by ALLOCATE CHANNEL to tell RMAN which kind of device you're going to use.
You can see all the default settings, including that one, by 'SHOW ALL' command. The default is DISK. You can allocate a few channel to speed up the procedure, but it depends also from the hardware. For example, i f you use a Tape drive, you should check first its capability in writing, and then decide how many channels to allocate. At the end of the procedure you will deallocate all of the channels.

If you need further information please specify RMAN and Oracle version and hardware you're going to use.

Kind regards
0
 

Author Comment

by:ralph_rea
ID: 38349651
O.S.  Linux version 2.6.18-308.4.1.el5(Red Hat 4.1.2-52))

Oracle version: 10.2

In attach hardware list


I need a few scripts (step-by-step) for allocate channel on tape drive or other (sbt????), if possible with allocate channels manually within a RUN block.

I found this example:
RMAN> RUN
{
  ALLOCATE CHANNEL c1 DEVICE TYPE DISK FORMAT = '/backup/df/%U';
  ALLOCATE CHANNEL c2 DEVICE TYPE DISK FORMAT = '/backup/cf/%U';
  ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
  BACKUP AS BACKUPSET # all output files are in backup sets
    # channel c1 backs up datafiles to /backup/df directory
    DATAFILE 1,2,3,4
    CHANNEL c1
    # channel c2 backs up control file copy to /backup/cf directory
    CONTROLFILECOPY '/tmp/control01.ctl'
    CHANNEL c2;
  BACKUP AS BACKUPSET
    # channel c3 backs up archived redo logs to tape
    ARCHIVELOG FROM TIME 'SYSDATE-14'
    CHANNEL c3;
}

Can I make a single backup set across multiple channels or/and Can I make a multiple backup on single channel?

What steps should I take to write a script like this?
hardware.txt
0
 
LVL 3

Accepted Solution

by:
geiar99 earned 2000 total points
ID: 38349929
First you need to check if for your hardware there's a release of Oracle libraries compatible to. This you can check even on the hardware producer site (usually).
If this is the case you can simply create your own scripts (no scripts is ready-to-go as it is).
Something like:

run {

set command id to 'Fulldb';

allocate channel c1 type 'SBT_TAPE';

allocate channel c2 type 'SBT_TAPE';

send '<proper string for your hardware and tape configuration>';

backup full filesperset 4

format '/FULL_%d_%u/'
(database);

sql 'alter system archive log current';

release channel c1;

release channel c2;}  

Open in new window


No need to specify "Backup as backupset" and "controlfilecopy" if you've specified this settings in the RMAN general configuration.

Oracle will take care of the best way to backup you single/multiple backupset across 1 or more channels. By 11g you can even specify the size of the pieces of the backupset you send to the disk/tape drive.

The best way would be to find the string you need for your hardware and tape configuration, then try to make a simple database backup directly from RMAN and see the output. You certainly need to build a special configuration for the Tape drive (depends which one you use) as well.

Hope it helps
0
 

Author Comment

by:ralph_rea
ID: 38350357
How Can I found the proper string for my hardware and tape configuration?
0
 
LVL 3

Expert Comment

by:geiar99
ID: 38350463
Usually is delivered from the tape manufacture or just search on any search engine. You can look for "oracle libraries for tape drives <brand>". Good luck!

Regards
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This article will show you step-by-step instructions to build your own NTP CentOS server.  The network diagram shows the best practice to setup the NTP server farm for redundancy.  This article also serves as your NTP server documentation.
Via a live example, show how to take different types of Oracle backups using RMAN.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses

564 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