Home » RDBMS Server » Backup & Recovery » Incremental backup type (Oracle 11gr2,Linux 6.4)
Incremental backup type [message #604149] Wed, 25 December 2013 00:14 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Can you tell me the difference between differential incremental and cumulative incremental backup in RMAN ?

Thanks,
Jack
Re: Incremental backup type [message #604150 is a reply to message #604149] Wed, 25 December 2013 00:22 Go to previous messageGo to next message
BlackSwan
Messages: 22555
Registered: January 2009
Senior Member
one takes more time & resources to produce; but less effort to restore.
the other takes less effort to produce; but more effort to restore.

which is better for you?
Re: Incremental backup type [message #604153 is a reply to message #604150] Wed, 25 December 2013 01:43 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi Blackswan,

<one takes more time & resources to produce; but less effort to restore.
the other takes less effort to produce; but more effort to restore.>

Can you tell me which one takes more time and which one takes less time ?

Thanks,
Jack
Re: Incremental backup type [message #604154 is a reply to message #604153] Wed, 25 December 2013 02:26 Go to previous messageGo to next message
Michel Cadot
Messages: 58641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is your opinion about this?

Re: Incremental backup type [message #604161 is a reply to message #604154] Wed, 25 December 2013 07:04 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi Michel,

Differential incremental backup takes more time & resources to produce; but less effort to restore.
Cumulative incremental backup takes less effort to produce; but more effort to restore.

Request you to correct my understanding if it is wrong.

Thanks,
Jack
Re: Incremental backup type [message #604173 is a reply to message #604161] Wed, 25 December 2013 08:20 Go to previous messageGo to next message
BlackSwan
Messages: 22555
Registered: January 2009
Senior Member
>Request you to correct my understanding if it is wrong.
it is wrong
Re: Incremental backup type [message #604181 is a reply to message #604173] Wed, 25 December 2013 11:31 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Can you correct me then ?

[Updated on: Wed, 25 December 2013 14:05]

Report message to a moderator

Re: Incremental backup type [message #604227 is a reply to message #604149] Thu, 26 December 2013 08:04 Go to previous messageGo to next message
EdStevens
Messages: 231
Registered: September 2013
Senior Member
Jack14 wrote on Wed, 25 December 2013 00:14
Hi,

Can you tell me the difference between differential incremental and cumulative incremental backup in RMAN ?

Thanks,
Jack



Gee, if only Oracle would publish documentation ...

Oh, wait! See http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmquick.htm#BRADV122
Re: Incremental backup type [message #604325 is a reply to message #604227] Sat, 28 December 2013 11:21 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thanks Stevens.The given documentation is useful for my query.

Re: Incremental backup type [message #604326 is a reply to message #604325] Sat, 28 December 2013 11:31 Go to previous messageGo to next message
Michel Cadot
Messages: 58641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Haven't we already give it to you many times?

Re: Incremental backup type [message #604739 is a reply to message #604149] Fri, 03 January 2014 10:41 Go to previous messageGo to next message
EdStevens
Messages: 231
Registered: September 2013
Senior Member
As of Thursday, January 2, the first message of this thread showed up vebatim at http://www.dbametrix.net/viewtopic.php?f=16&t=1599
On Friday, January 3, it was observed that the second message in this thread was add, verbatim, to the thread at dbametrix.

I have observed quite a number of threads at dbametrix that are verbatim copies of threads from orafaq, OTN forums, and others.

This one I seem to have caught 'in progress'. I full expect to see a few more messages from this thread to start showing up at http://www.dbametrix.net/viewtopic.php?f=16&t=1599

I have already been banned from the forum at dbametrix, apparently for pointing out this plagiarism.

It will be interesting to note if they copy any more from this thread before they see this posting ...

for the curious, other 'matched pairs'

https://community.oracle.com/thread/2615768
http://www.dbametrix.net/viewtopic.php?f=15&t=1595

http://www.orafaq.com/forum/?t=msg&goto=600323&
http://www.dbametrix.net/viewtopic.php?f=15&t=1584

http://www.orafaq.com/forum/t/189550/
http://www.dbametrix.net/viewtopic.php?f=15&t=1562

http://www.dbametrix.net/viewtopic.php?f=15&t=1467
http://www.dbasupport.com/forums/showthread.php?62893-Why-does-Oracle-prefer-CPU-cost-to-less-I-O-while-generating-execution-plans

http://www.dbametrix.net/viewtopic.php?f=15&t=1537
http://www.orafaq.com/forum/t/185163/





Re: Incremental backup type [message #604909 is a reply to message #604739] Mon, 06 January 2014 01:30 Go to previous messageGo to next message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
Shocked
Ed,

Your latest post listing a number of duplicate threads doesn't seem to have got duplicated.


Hemant K Chitale
Shocked
Re: Incremental backup type [message #604913 is a reply to message #604909] Mon, 06 January 2014 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 58641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

which ones?

Re: Incremental backup type [message #605113 is a reply to message #604739] Tue, 07 January 2014 07:56 Go to previous messageGo to next message
EdStevens
Messages: 231
Registered: September 2013
Senior Member
heh, heh, heh

Just now, I see a third addition to the above mentioned thread on dbametrix ...

"kimipatel" has essentially copied msg 604513. Just enough change to indicate they are doing the copy by hand, but not enough to hide what they are doing.

And apparently not reading the full thread before copying .. to see that they have been exposed. Or maybe they have so little shame they really don't care.
Re: Incremental backup type [message #605307 is a reply to message #604149] Wed, 08 January 2014 10:12 Go to previous message
EdStevens
Messages: 231
Registered: September 2013
Senior Member
A 'smithdba' just posted Michel's message # 604154

see http://www.dbametrix.net/viewtopic.php?f=16&t=1599
Previous Topic: Running Script for duplicate Sending Error
Next Topic: Recreate control files
Goto Forum:
  


Current Time: Fri Aug 01 10:10:03 CDT 2014

Total time taken to generate the page: 0.11319 seconds