Home » RDBMS Server » Server Utilities » expdp VS RMAN backup (10g, 10.2.0.4 window server 2008)
expdp VS RMAN backup [message #585733] Wed, 29 May 2013 07:36 Go to next message
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
Re: expdp VS RMAN backup [message #585739 is a reply to message #585733] Wed, 29 May 2013 08:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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).
Re: expdp VS RMAN backup [message #585740 is a reply to message #585733] Wed, 29 May 2013 08:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: expdp VS RMAN backup [message #585742 is a reply to message #585733] Wed, 29 May 2013 08:22 Go to previous messageGo to next message
gazzag
Messages: 1118
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.
Re: expdp VS RMAN backup [message #585746 is a reply to message #585742] Wed, 29 May 2013 08:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Irrelevant.

Regards
Michel
Re: expdp VS RMAN backup [message #585747 is a reply to message #585746] Wed, 29 May 2013 08:43 Go to previous messageGo to next message
gazzag
Messages: 1118
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.
Re: expdp VS RMAN backup [message #585749 is a reply to message #585747] Wed, 29 May 2013 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: expdp VS RMAN backup [message #585756 is a reply to message #585749] Wed, 29 May 2013 09:34 Go to previous messageGo to next message
gazzag
Messages: 1118
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.
Re: expdp VS RMAN backup [message #585770 is a reply to message #585756] Wed, 29 May 2013 11:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And? What will you get in this comparison?

Regards
Michel
Re: expdp VS RMAN backup [message #585771 is a reply to message #585770] Wed, 29 May 2013 11:15 Go to previous messageGo to next message
gazzag
Messages: 1118
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?
Re: expdp VS RMAN backup [message #585772 is a reply to message #585771] Wed, 29 May 2013 11:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: expdp VS RMAN backup [message #585790 is a reply to message #585787] Thu, 30 May 2013 00:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: expdp VS RMAN backup [message #585794 is a reply to message #585790] Thu, 30 May 2013 00:48 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Thanks Michel,

Now i am very much clear. My doubt is clear now.
Re: expdp VS RMAN backup [message #585799 is a reply to message #585794] Thu, 30 May 2013 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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.,
Re: expdp VS RMAN backup [message #592553 is a reply to message #592526] Fri, 09 August 2013 10:56 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: "Message 2100 not found" Errors
Next Topic: IMPDP struck in 11g @ VIEW
Goto Forum:
  


Current Time: Thu Mar 28 18:13:33 CDT 2024