Home » RDBMS Server » Backup & Recovery » rman backup (11gR2 RHEL 5)
rman backup [message #619485] Tue, 22 July 2014 19:37 Go to next message
smunir362
Messages: 252
Registered: September 2007
Senior Member
My company wants to retain 1 year backup to tape and 1 month backup to disk,,,
I write script level 0 on Sun and incr level 1 on rest of days for tape..Scripts include DB.Archives,Control.spfile
Even I taking daily backup of archives... But how can I backup of archives on tape to ensure 0 data loss
For example I backup archives at 10pm and at next day before 10pm DB crashed....
If I backup archives hourly,,,then between hours how to ensure 0 data loss
Re: rman backup [message #619486 is a reply to message #619485] Tue, 22 July 2014 19:57 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
when all else fails Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/server.112/e25494/archredo.htm#ADMIN13277
Re: rman backup [message #621925 is a reply to message #619486] Tue, 19 August 2014 13:23 Go to previous messageGo to next message
smunir362
Messages: 252
Registered: September 2007
Senior Member
Ok I go through it but I need to the point information....
Moreover
1- Is there any way to use parallelism and generate single backuppiece....
2- If parallelism used the error occure file already exists....
Re: rman backup [message #621928 is a reply to message #619485] Tue, 19 August 2014 13:51 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
then between hours how to ensure 0 data loss


Against what failure?

Re: rman backup [message #621929 is a reply to message #621925] Tue, 19 August 2014 13:52 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
smunir362 wrote on Tue, 19 August 2014 20:23
Ok I go through it but I need to the point information....
Moreover
1- Is there any way to use parallelism and generate single backuppiece....
2- If parallelism used the error occure file already exists....


1. you can't
2. Not my experience

Re: rman backup [message #622129 is a reply to message #621929] Thu, 21 August 2014 05:20 Go to previous messageGo to next message
smunir362
Messages: 252
Registered: September 2007
Senior Member
Thanks for reply..
All is well..
I have some questions
1-How can I off autobackup of controlfile. Because I write script to take backup database,archives,controlfile,spfile ON DISK...
2-If I have backupsets on DISK
i dataily_data.dbf
ii daily_archive.arc
How can I backup these backupsets on TAPE as Single backupset/file.
Re: rman backup [message #622141 is a reply to message #622129] Thu, 21 August 2014 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
2. BACKUP BACKUPSET ... (with appropriate channel allocation for tape).

Re: rman backup [message #622150 is a reply to message #622141] Thu, 21 August 2014 09:33 Go to previous messageGo to next message
tim2boles
Messages: 34
Registered: August 2008
Location: Clarksburg, WV
Member
Quote:
1- Is there any way to use parallelism and generate single backuppiece....

The answer is going to be "it depends". Depends on the type of backup you are taking, how large your datafiles are,how many datafiles you are backing up an the configuration you have setup.

I might have missed which database version you are using but in Oracle 11g and 12c there are what is called Multiplexed Backup Sets. So basically it can read in parallel from multiple datafiles simultaneiously and then combine the blocks from these datafiles into a single backup piece. So in this sense of parallelism yes. But you must set this up.

http://docs.oracle.com/cd/E11882_01/backup.112/e10642.pdf
http://docs.oracle.com/database/121/BRADV/E50658-04.pdf




Re: rman backup [message #622163 is a reply to message #622150] Thu, 21 August 2014 23:25 Go to previous messageGo to next message
smunir362
Messages: 252
Registered: September 2007
Senior Member
Moreover
1- Is there any way to use parallelism and generate single backuppiece....
2- If parallelism used the error occure file already exists....

I elaborate my question...
I have parallelism 6 set in RMAN.
Now I run backup database there are 7 backupsets (6 for each channel and 1 for controlfile autobackup)
I want to use parallelism 6 but generate 1 backupset instead of 6 backupsets........

I set controlfile autobackup off But it still backup the controlfile.... How to force off this feature....
Re: rman backup [message #622187 is a reply to message #622163] Fri, 22 August 2014 07:26 Go to previous messageGo to next message
EdStevens
Messages: 295
Registered: September 2013
Senior Member
smunir362 wrote on Thu, 21 August 2014 23:25
Moreover


I set controlfile autobackup off But it still backup the controlfile.... How to force off this feature....


rman will ALWAYS backup the control file. It has to have the control file in order to guarantee recoverability of the databse. In terms of taking the backup, the only thing 'controlfile autobackup' does is control exactly where in the sequence and which backup set gets the backup of the control file.

https://community.oracle.com/thread/3599539?sr=stream
Re: rman backup [message #622209 is a reply to message #622187] Fri, 22 August 2014 09:23 Go to previous messageGo to next message
smunir362
Messages: 252
Registered: September 2007
Senior Member
Thanks for reply.
I understand controlfile backup....
But when I run backup database there are 7 backupsets (6 for each channel and 1 for controlfile autobackup)
I want to use parallelism 6 but generate 1 backupset instead of 6 backupsets........

How can I do it.
Re: rman backup [message #622213 is a reply to message #622209] Fri, 22 August 2014 09:32 Go to previous message
John Watson
Messages: 4611
Registered: January 2010
Location: Global Village
Senior Member
Quote:
How can I do it.
You can't.
Previous Topic: Backing up 12C tables / data
Next Topic: retention policy
Goto Forum:
  


Current Time: Wed Oct 01 22:34:49 CDT 2014

Total time taken to generate the page: 0.11630 seconds