OraFAQ Forum: Backup & Recovery » RMAN Backup on Multiple Filesystems

Home » RDBMS Server » Backup & Recovery » RMAN Backup on Multiple Filesystems (Oracle Database 10.2.0.4 on IBM AIX5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN Backup on Multiple Filesystems [message #440160]

Thu, 21 January 2010 07:29

fkhalid
Messages: 2
Registered: April 2007
Location: Islamabad

Junior Member

HI,
I want to place my RMAN backup on two mount points.
/backup1/rman_bkp/
/backup2/rman_bkp/

Both mount points are SAN based (having fibre disks).

I want to put RMAN level 0 backup on both mount points.
Currently I am taking backup on one filesystem and have set following in RMAN:

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 8;

This way I am able to have 8 parallel channels during backup.
Can you please tell me how to configure RMAN for:
1. Pointing backup to both locations(i.e if one mount point filled then the backup continue on second)
2. Use 8 parallel channels for one file system and 8 channels for second.

I have found following configuration for multiple disks: but i dont think it will allow multiple channels like i used 8 for single filesystem.

RUN
{
ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT /backup1/rman_bkp/%U';
ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '/backup2/rman_bkp/%U';
# AS COPY is default when backing up to disk
BACKUP DATABASE PLUS ARCHIVELOG;
}

[Updated on: Thu, 21 January 2010 08:08]

Report message to a moderator

Re: RMAN Backup on Multiple Filesystems [message #440201 is a reply to message #440160]

Thu, 21 January 2010 09:51

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

The example you give is using multiple channels: two of them. You could allocate another 6 if you want, writing to the same destinations. Is this not exactly what you want?
When you run the script, you'll see them being launched in the RMAN interface, or you can query v$session and v$session_longops, and see them there too.

Report message to a moderator

Re: RMAN Backup on Multiple Filesystems [message #440203 is a reply to message #440160]

Thu, 21 January 2010 10:10

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

Try this:

CONFIGURE DEVICE TYPE DISK PARALLELISM 8;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/backup1/rman_bkp/ch1_%U'; 
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/backup1/rman_bkp/ch2_%U';
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT '/backup1/rman_bkp/ch3_%U';
CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT '/backup1/rman_bkp/ch4_%U';
CONFIGURE CHANNEL 5 DEVICE TYPE DISK FORMAT '/backup2/rman_bkp/ch5_%U';
CONFIGURE CHANNEL 6 DEVICE TYPE DISK FORMAT '/backup2/rman_bkp/ch6_%U';
CONFIGURE CHANNEL 7 DEVICE TYPE DISK FORMAT '/backup2/rman_bkp/ch7_%U';
CONFIGURE CHANNEL 8 DEVICE TYPE DISK FORMAT '/backup2/rman_bkp/ch8_%U';

PS: Once you configure the channels, you do not need to use the 'ALLOCATE' command:

RUN
{
BACKUP DATABASE PLUS ARCHIVELOG;
}

[Updated on: Thu, 21 January 2010 10:33] by Moderator

Report message to a moderator

Re: RMAN Backup on Multiple Filesystems [message #440274 is a reply to message #440203]

Thu, 21 January 2010 23:37

fkhalid
Messages: 2
Registered: April 2007
Location: Islamabad

Junior Member

Hi,
thanks for the reply. Yes that's exactly I want. I was in doubt if we can use configure multiple channel command for same filesystem.
One more point need to be clear. Can I specify the backup_set names like for single file system i was using following settings:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/ORA_BKP/RMAN_BKP/RMAN_BKP_LVL0_%t_%s_%p' MAXPIECESIZE 4096 M;

So can we use the same 'RMAN_BKP_LVL0_%t_%s_%p' setting for all channels?

Report message to a moderator