OraFAQ Forum: Backup & Recovery » Incremental backup type

Home » RDBMS Server » Backup & Recovery » Incremental backup type (Oracle 11gr2,Linux 6.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Incremental backup type [message #604149]

Wed, 25 December 2013 00:14

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

Report message to a moderator

Re: Incremental backup type [message #604150 is a reply to message #604149]

Wed, 25 December 2013 00:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

Re: Incremental backup type [message #604153 is a reply to message #604150]

Wed, 25 December 2013 01:43

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

Report message to a moderator

Re: Incremental backup type [message #604154 is a reply to message #604153]

Wed, 25 December 2013 02:26

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is your opinion about this?

Report message to a moderator

Re: Incremental backup type [message #604161 is a reply to message #604154]

Wed, 25 December 2013 07:04

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

Report message to a moderator

Re: Incremental backup type [message #604173 is a reply to message #604161]

Wed, 25 December 2013 08:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Request you to correct my understanding if it is wrong.
it is wrong

Report message to a moderator

Re: Incremental backup type [message #604181 is a reply to message #604173]

Wed, 25 December 2013 11:31

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

EdStevens
Messages: 1376
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

Report message to a moderator

Re: Incremental backup type [message #604325 is a reply to message #604227]

Sat, 28 December 2013 11:21

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thanks Stevens.The given documentation is useful for my query.

Report message to a moderator

Re: Incremental backup type [message #604326 is a reply to message #604325]

Sat, 28 December 2013 11:31

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Incremental backup type [message #604739 is a reply to message #604149]

Fri, 03 January 2014 10:41

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

As of Thursday, January 2, the first message of this thread showed up vebatim at 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 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
www.dbametrix.net/viewtopic.php?f=15&t=1595

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

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

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

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

Report message to a moderator

Re: Incremental backup type [message #604909 is a reply to message #604739]

Mon, 06 January 2014 01:30

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

Ed,

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

Hemant K Chitale
Shocked

Report message to a moderator

Re: Incremental backup type [message #604913 is a reply to message #604909]

Mon, 06 January 2014 02:25

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

which ones?

Report message to a moderator

Re: Incremental backup type [message #605113 is a reply to message #604739]

Tue, 07 January 2014 07:56

EdStevens
Messages: 1376
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.

Report message to a moderator

Re: Incremental backup type [message #605307 is a reply to message #604149]

Wed, 08 January 2014 10:12

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

A 'smithdba' just posted Michel's message # 604154

see www.dbametrix.net/viewtopic.php?f=16&t=1599

Report message to a moderator

Previous Topic:	Running Script for duplicate Sending Error
Next Topic:	Recreate control files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 21:37:15 CST 2025