| RMAN Backup [message #646392] |
Tue, 29 December 2015 12:47  |
smunir362
Messages: 310
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  |
John Watson
Messages: 8964
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 #646432 is a reply to message #646395] |
Wed, 30 December 2015 06:20 |
smunir362
Messages: 310
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 #646438 is a reply to message #646436] |
Wed, 30 December 2015 07:08 |
smunir362
Messages: 310
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 #646441 is a reply to message #646440] |
Wed, 30 December 2015 08:14 |
smunir362
Messages: 310
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 #646447 is a reply to message #646441] |
Wed, 30 December 2015 11:54 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
smunir362 wrote on Wed, 30 December 2015 14:14As 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 |
smunir362
Messages: 310
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 #646507 is a reply to message #646501] |
Sun, 03 January 2016 06:40 |
smunir362
Messages: 310
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 |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
smunir362
Messages: 310
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 #646782 is a reply to message #646781] |
Fri, 08 January 2016 10:33 |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
Sorry I did not understand...
Actually I understand Optimization OFF mean at parameter level..
Thanks for explaining..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
