Home » RDBMS Server » Server Utilities » Consistent backup using data pump (Oracle 11.2.0.3.0 , linux 2.6)  () 1 Vote
Consistent backup using data pump [message #619899] Fri, 25 July 2014 15:40 Go to next message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
Hi,

I want to take schema level consistent backup using data pump (expdp).

Can you confirm the following command is correct ?
expdp system/passwd directory=flsh dumpfile=schema_user001_2.dmp logfile =schema_user001_2.log schemas=usr001 flashback_time=systimestamp

Thanks,
Srikanth
Re: Consistent backup using data pump [message #619918 is a reply to message #619899] Sat, 26 July 2014 00:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It seems correct as long as you have a flsh directory and have the access rights on it and a schema named usr001 and... you trust something you get from a forum without testing it.



Re: Consistent backup using data pump [message #619942 is a reply to message #619918] Sat, 26 July 2014 08:11 Go to previous messageGo to next message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
Hi Michel,

Thanks for your confirmation.

Can you tell me how to test a consistent schema level backup using datapump ?

Regards,
Srikanth
Re: Consistent backup using data pump [message #619946 is a reply to message #619942] Sat, 26 July 2014 08:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
consistent for what point in time?
Re: Consistent backup using data pump [message #619951 is a reply to message #619942] Sat, 26 July 2014 09:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It's easy:
  • Create a big table (cross join all_objects with itself)
  • Export it with flashback_time=systimestamp
  • Modify some/many rows in it, don't forget to commit from time to time and before the export is done
  • When export is done, truncate the table
  • Import it
  • Verify the imported rows don't contain the modifications you did
Re: Consistent backup using data pump [message #619956 is a reply to message #619946] Sat, 26 July 2014 10:48 Go to previous messageGo to next message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
Hi Srikanth ,
Quote:
consistent for what point in time?

My client want to take full consistent schema backup for some databases.
They have not mention the time and all.

Michel,
Thanks for the steps.
Quote:
Create a big table (cross join all_objects with itself)

Can you define a big table ?what table size is consider as big table ?
how to cross join all_objects with itself ?

Regards,
Srikanth.
Re: Consistent backup using data pump [message #619959 is a reply to message #619956] Sat, 26 July 2014 11:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
how to cross join all_objects with itself ?


select * from all_objects, all_objects;

Quote:
Can you define a big table ?


A table large enough so that you have time to update it during the export.

Re: Consistent backup using data pump [message #619964 is a reply to message #619959] Sat, 26 July 2014 11:37 Go to previous message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
Michel,
Thanks for your reply.
Based upon the steps,i will test it and come back if i face any issue.

Regards,
Srikanth
Previous Topic: ORA-31655: no data or metadata objects selected for job
Next Topic: TAB DELIMETER IS CONSIDERING TWO TABS AS ONE TAB
Goto Forum:
  


Current Time: Thu Mar 28 05:52:17 CDT 2024