Home » RDBMS Server » Backup & Recovery » RMAN Backup on Multiple Filesystems (Oracle Database 10.2.0.4 on IBM AIX5.3)
RMAN Backup on Multiple Filesystems [message #440160] Thu, 21 January 2010 07:29 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 6401
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.
Re: RMAN Backup on Multiple Filesystems [message #440203 is a reply to message #440160] Thu, 21 January 2010 10:10 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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?
Re: RMAN Backup on Multiple Filesystems [message #440275 is a reply to message #440274] Thu, 21 January 2010 23:41 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
>So can we use the same 'RMAN_BKP_LVL0_%t_%s_%p' setting for all channels?

Please do & report results!
icon12.gif  Re: RMAN Backup on Multiple Filesystems [message #440328 is a reply to message #440274] Fri, 22 January 2010 07:53 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Yes you can use same format spec as long as it forms unique file name.

[Updated on: Fri, 22 January 2010 08:11] by Moderator

Report message to a moderator

Previous Topic: Point-in-time recovery
Next Topic: Backup Offline
Goto Forum:
  


Current Time: Wed Sep 28 17:44:42 CDT 2016

Total time taken to generate the page: 0.05784 seconds