| rman backup [message #619485] |
Tue, 22 July 2014 19:37  |
smunir362
Messages: 306
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 #621925 is a reply to message #619486] |
Tue, 19 August 2014 13:23  |
smunir362
Messages: 306
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 #622129 is a reply to message #621929] |
Thu, 21 August 2014 05:20 |
smunir362
Messages: 306
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 #622150 is a reply to message #622141] |
Thu, 21 August 2014 09:33 |
tim2boles
Messages: 38
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 |
smunir362
Messages: 306
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 #622209 is a reply to message #622187] |
Fri, 22 August 2014 09:23 |
smunir362
Messages: 306
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.
|
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
