OraFAQ Forum: Server Utilities » expdp VS RMAN backup

Home » RDBMS Server » Server Utilities » expdp VS RMAN backup (10g, 10.2.0.4 window server 2008)

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

expdp VS RMAN backup [message #585733]

Wed, 29 May 2013 07:36

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Dear All,

I have one doubt on Expdp & RMAN.
Do EXPDP utilities does backup at block level as what RMAN is doing?

Which one is faster, expdp or RMAN?

Regards,
Ishika

Report message to a moderator

Re: expdp VS RMAN backup [message #585739 is a reply to message #585733]

Wed, 29 May 2013 08:02

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> Do EXPDP utilities does backup at block level as what RMAN is doing?
Exporting process is logical. Not physical.
>> Which one is faster, expdp or RMAN?
Hard to answer as there are many factors. Both vary fundamentally.
Instead of worrying about "backup", I would worry about "restore" process. In that case, RMAN is faster (restoring the whole database).

Report message to a moderator

Re: expdp VS RMAN backup [message #585740 is a reply to message #585733]

Wed, 29 May 2013 08:03

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

Senior Member
Account Moderator

Expdp expports data and metadata NOT blocks.
Expdp backs up data NOT database.
Expdp is logical backup and handles objects; RMAN is physical backup and handles files.

Quote:

Which one is faster, expdp or RMAN?

Which one is faster, a truck or a boat?

Regards
Michel

Report message to a moderator

Re: expdp VS RMAN backup [message #585742 is a reply to message #585733]

Wed, 29 May 2013 08:22

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

ishika_20 wrote on Wed, 29 May 2013 12:36

Which one is faster, expdp or RMAN?

Test it.

Report message to a moderator

Re: expdp VS RMAN backup [message #585746 is a reply to message #585742]

Wed, 29 May 2013 08:36

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

Senior Member
Account Moderator

Irrelevant.

Regards
Michel

Report message to a moderator

Re: expdp VS RMAN backup [message #585747 is a reply to message #585746]

Wed, 29 May 2013 08:43

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Michel Cadot wrote on Wed, 29 May 2013 13:36

Irrelevant.

Regards
Michel

I agree, Michel. I was merely pointing out to the OP that he is asking nothing that he can't find out for himself. But the subsequent import/restore (assuming the OP does this) may well be a relevant exercise; it will demonstrate the difference between the two procedures.

Report message to a moderator

Re: expdp VS RMAN backup [message #585749 is a reply to message #585747]

Wed, 29 May 2013 08:50

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

Senior Member
Account Moderator

The question itself is irrelevant.
When 2 things do different works, it is irrelevant to compare the times they make to do their work.
Do you compare the time to write a query and the time to go to buy bread?

Regards
Michel

Report message to a moderator

Re: expdp VS RMAN backup [message #585756 is a reply to message #585749]

Wed, 29 May 2013 09:34

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Michel Cadot wrote on Wed, 29 May 2013 13:50

The question itself is irrelevant.
When 2 things do different works, it is irrelevant to compare the times they make to do their work.
Do you compare the time to write a query and the time to go to buy bread?

Regards
Michel

Of course not. But depending on my specific requirement, I might well compare the differences between a physical and a logical backup.

Report message to a moderator

Re: expdp VS RMAN backup [message #585770 is a reply to message #585756]

Wed, 29 May 2013 11:10

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

Senior Member
Account Moderator

And? What will you get in this comparison?

Regards
Michel

Report message to a moderator

Re: expdp VS RMAN backup [message #585771 is a reply to message #585770]

Wed, 29 May 2013 11:15

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Michel Cadot wrote on Wed, 29 May 2013 16:10

And? What will you get in this comparison?

Maybe an understanding of the differences between the tools in question - the OP currently doesn't have that. That and by reading the documentation. Then asking questions from people who know better than me. That's how we learn, isn't it?

Report message to a moderator

Re: expdp VS RMAN backup [message #585772 is a reply to message #585771]

Wed, 29 May 2013 11:36

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

Senior Member
Account Moderator

I mean the comparison in time this is what we are talking about.
I remind you your post:

gazzag wrote on Wed, 29 May 2013 15:22

ishika_20 wrote on Wed, 29 May 2013 12:36

Which one is faster, expdp or RMAN?

Test it.

Regards
Michel

[Updated on: Wed, 29 May 2013 11:36]

Report message to a moderator

Re: expdp VS RMAN backup [message #585787 is a reply to message #585772]

Wed, 29 May 2013 23:42

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Dear Michel, Mahesh Rajendran,

Thanks for your reply...

I know that EXPDP is logical. I want to know whether both RMAN & EXPDP did block level backup.

For my second question, i got answer from Mahesh. Thanks

Regards,
Ishika

Report message to a moderator

Re: expdp VS RMAN backup [message #585790 is a reply to message #585787]

Thu, 30 May 2013 00:10

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

Senior Member
Account Moderator

If it is logical, it is not physical and blocks are physical stuff, isn't?
So the answer is?

Quote:

For my second question, i got answer from Mahesh.

Which is?

Regards
Michel

Report message to a moderator

Re: expdp VS RMAN backup [message #585794 is a reply to message #585790]

Thu, 30 May 2013 00:48

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Thanks Michel,

Now i am very much clear. My doubt is clear now.

Report message to a moderator

Re: expdp VS RMAN backup [message #585799 is a reply to message #585794]

Thu, 30 May 2013 01:26

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

Senior Member
Account Moderator

Please, I asked "what did you understand?" Post it for future readers.
ALWAYS post the final point you come to have a clean topic with a conclusion.

Regards
Michel

[Updated on: Thu, 30 May 2013 01:26]

Report message to a moderator

Re: expdp VS RMAN backup [message #592526 is a reply to message #585799]

Fri, 09 August 2013 07:45

8939513598$
Messages: 103
Registered: July 2013
Location: chennai

Senior Member

Generally, RMAN backups only used blocks, EXPDP also does the same thing,with RMAN corrupted blocks can be detected, where as EXPDP it's not possible.,

Report message to a moderator

Re: expdp VS RMAN backup [message #592553 is a reply to message #592526]

Fri, 09 August 2013 10:56

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

Senior Member
Account Moderator

Quote:

Generally, RMAN backups only used blocks, EXPDP also does the same thing,

This is completely wrong.
I advise you to read the first chapter of each of these tools in the documentation.

Regards
Michel

Report message to a moderator

Previous Topic:	"Message 2100 not found" Errors
Next Topic:	IMPDP struck in 11g @ VIEW

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:25:17 CST 2025