Home » RDBMS Server » Backup & Recovery » RMAN Backup (Database11gR2 OEL6.5)
RMAN Backup [message #646392] Tue, 29 December 2015 12:47 Go to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
Sir,
I want to take rman database backup on 4 destinations(a,b,c,d). Destination a is local disk and (b,c,d) are different NAS mounts.
I want to take backup at destination a. Then backup backupset to rest of 3 destinations.
Because destination a is fast. And other destinations(b,c,d) are slow.

Regards,
Re: RMAN Backup [message #646393 is a reply to message #646392] Tue, 29 December 2015 13:04 Go to previous messageGo to next message
John Watson
Messages: 7219
Registered: January 2010
Location: Global Village
Senior Member
That is certainly feasible. I would make destination a my fast recovery area, and take it from there.
Re: RMAN Backup [message #646395 is a reply to message #646392] Tue, 29 December 2015 15:30 Go to previous messageGo to next message
EdStevens
Messages: 888
Registered: September 2013
Senior Member
You may certainly do so. What's preventing you from proceeding?
Re: RMAN Backup [message #646432 is a reply to message #646395] Wed, 30 December 2015 06:20 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
I am facing problem...
I have optimization enabled and archive backup is running every 30 minutes as well.
Now when I run backup backupset it skip and says that already have backup one time on disk.
When optimization off then it works but I do not want to optimization off.

Please help me how to deal with this scenario.

[Updated on: Wed, 30 December 2015 06:21]

Report message to a moderator

Re: RMAN Backup [message #646436 is a reply to message #646432] Wed, 30 December 2015 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is the relation with the original question?

Re: RMAN Backup [message #646438 is a reply to message #646436] Wed, 30 December 2015 07:08 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
Relation is that there is problem...
As NAS is slow and backup with copies=4 works fine but it takes too much time almost 8 hours.
Without NAS it takes 2 hours.
I want to backup on fra then backup backupset to NAS and more locations.
Re: RMAN Backup [message #646439 is a reply to message #646438] Wed, 30 December 2015 07:10 Go to previous messageGo to next message
John Watson
Messages: 7219
Registered: January 2010
Location: Global Village
Senior Member
So far, you have not shown one line of code. What are you doing? What is the result?
Re: RMAN Backup [message #646440 is a reply to message #646438] Wed, 30 December 2015 07:21 Go to previous messageGo to next message
BlackSwan
Messages: 25796
Registered: January 2009
Location: SoCal
Senior Member
smunir362 wrote on Wed, 30 December 2015 05:08
Relation is that there is problem...
As NAS is slow and backup with copies=4 works fine but it takes too much time almost 8 hours.
Without NAS it takes 2 hours.
I want to backup on fra then backup backupset to NAS and more locations.


Root cause & fix are external to Oracle, since Oracle has NO control over OS file systems
Re: RMAN Backup [message #646441 is a reply to message #646440] Wed, 30 December 2015 08:14 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
As Oracle DBA I want to take RMAN backup..
First to backup in /fra (busy database as backing up). takes 2 hours.
Second to backup from /fra (not busy database) takes just copy the backupset to rest of locations/mount points but using rman backup backupset command

it works fine in Optimization OFF mode. But not worked in Optimization ON.

As ON it says already backup so skip....

How to achieve above mentioned requirements.
Re: RMAN Backup [message #646442 is a reply to message #646441] Wed, 30 December 2015 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Use Optimization OFF.

Re: RMAN Backup [message #646443 is a reply to message #646441] Wed, 30 December 2015 08:50 Go to previous messageGo to next message
EdStevens
Messages: 888
Registered: September 2013
Senior Member
It is behaving as expected.

From the manual Database BAckup and Recovery Reference

If backup optimization is enabled when you back up a backup set, and if the identical backup set has been backed up to the same device type, then RMAN skips the backup of this backup set.

Again, you have shown no code whatsover, but I'm willing to bet ONE your three destinations is succeeding, creating the situation of "the identical backup set has been backed up to the same device type".

Your options:
1) turn optimization off
2) use os commands to copy the original backupset, instead of rman 'backup backupset'
3) rethink why you want THREE additional copies of a backupset.
Re: RMAN Backup [message #646447 is a reply to message #646441] Wed, 30 December 2015 11:54 Go to previous messageGo to next message
John Watson
Messages: 7219
Registered: January 2010
Location: Global Village
Senior Member
smunir362 wrote on Wed, 30 December 2015 14:14
As Oracle DBA I want to take RMAN backup..
First to backup in /fra (busy database as backing up). takes 2 hours.
Second to backup from /fra (not busy database) takes just copy the backupset to rest of locations/mount points but using rman backup backupset command

it works fine in Optimization OFF mode. But not worked in Optimization ON.

As ON it says already backup so skip....

How to achieve above mentioned requirements.
Is there some reason for you not showing the scripts you are running and your configuration? Without seeing this it is really difficult to debug your code. For example, if I wanted to move my backups to somewhere else, I would use BACKUP RECOVERY FILES .... DELETE ALL INPUT but for all I know you are doing that already.
Re: RMAN Backup [message #646500 is a reply to message #646447] Sat, 02 January 2016 10:58 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
I have got my answer, I want to share it..
As in my configuration optimization is enabled and I cannot disable it.
I can use force option at the end of backup backupset command.
Force option works if Optimization is enable.
Re: RMAN Backup [message #646501 is a reply to message #646500] Sat, 02 January 2016 11:12 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So you turned the optimization off.

Re: RMAN Backup [message #646507 is a reply to message #646501] Sun, 03 January 2016 06:40 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
No I did not turned off Optimization. It is still ON and I cannot OFF because other Arch backups are running.
I Only ADD Force at the end like below
RMAN > backup backupset from tag 'ABC' format 'location b' force
Re: RMAN Backup [message #646512 is a reply to message #646507] Sun, 03 January 2016 08:47 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes, this has the effect to turn off the optimization.
So, for us, for RMAN, for Oracle, this is what you have done as nowhere in your question you mention any restriction on your possible action.
I remind you "When optimization off then it works but I do not want to optimization off." but FORCE is turning off optimization so this "solution" is not a solution.

Moreover, this "solution" has nothing to do with the original question, I remind:
"I want to take rman database backup on 4 destinations(a,b,c,d). Destination a is local disk and (b,c,d) are different NAS mounts.
I want to take backup at destination a. Then backup backupset to rest of 3 destinations.
Because destination a is fast. And other destinations(b,c,d) are slow."
How FORCE answer this?

Re: RMAN Backup [message #646775 is a reply to message #646512] Fri, 08 January 2016 09:45 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
Optimization is ON because other Arch backups are running..
For example think (Arch backup run every 30 minutes using shell script take 10 minutes) and (Full backup every sunday using shell script takes 2 hours)
Now if I set Optimization OFF then it will be off at catalog level (Control file OR catalog DB) right.
And What will happen with arch backup. It will start backing up archive logs which are already been backed up.We did not want this duplication more...
---So using force command in backup backupset will backup from backupsets.
Re: RMAN Backup [message #646776 is a reply to message #646775] Fri, 08 January 2016 09:53 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Optimization is off during the backup you execute with force option.
Yes or no?

Re: RMAN Backup [message #646777 is a reply to message #646776] Fri, 08 January 2016 10:02 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
force will not Off the optimization. So No
Re: RMAN Backup [message #646778 is a reply to message #646777] Fri, 08 January 2016 10:10 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So you say the Oracle documentation is wrong and during the backup you had optimization and so did not backup the files you already backed up.

Re: RMAN Backup [message #646779 is a reply to message #646778] Fri, 08 January 2016 10:18 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
force will only ignore optimization and not set to OFF
Re: RMAN Backup [message #646781 is a reply to message #646779] Fri, 08 January 2016 10:29 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So if optimization is ignored, it is off.
You NOW talk about the parameter but you NEVER talk about the parameter in your question(s), you just said "optimization" not "optimization parameter", so those who will read the topic will not see you talk about the parameter.

I summarize:
The purpose of FORCE is to turn off/disable/ignore the settings of... (any synonym you want) the optimization during a command and backup every files.


Re: RMAN Backup [message #646782 is a reply to message #646781] Fri, 08 January 2016 10:33 Go to previous message
smunir362
Messages: 305
Registered: September 2007
Senior Member
Sorry I did not understand...
Actually I understand Optimization OFF mean at parameter level..
Thanks for explaining..
Previous Topic: Is there a way to compress an existing uncompressed backupset
Next Topic: RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archiv
Goto Forum:
  


Current Time: Fri Jan 19 18:28:53 CST 2018

Total time taken to generate the page: 0.02168 seconds