OraFAQ Forum: Server Utilities » Consistent backup using data pump

Home » RDBMS Server » Server Utilities » Consistent backup using data pump (Oracle 11.2.0.3.0 , linux 2.6) (

) 1 Vote

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

Consistent backup using data pump [message #619899]

Fri, 25 July 2014 15:40

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

Report message to a moderator

Re: Consistent backup using data pump [message #619918 is a reply to message #619899]

Sat, 26 July 2014 00:12

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

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.

Report message to a moderator

Re: Consistent backup using data pump [message #619942 is a reply to message #619918]

Sat, 26 July 2014 08:11

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

Report message to a moderator

Re: Consistent backup using data pump [message #619946 is a reply to message #619942]

Sat, 26 July 2014 08:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

consistent for what point in time?

Report message to a moderator

Re: Consistent backup using data pump [message #619951 is a reply to message #619942]

Sat, 26 July 2014 09:24

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

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

Report message to a moderator

Re: Consistent backup using data pump [message #619956 is a reply to message #619946]

Sat, 26 July 2014 10:48

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.

Report message to a moderator

Re: Consistent backup using data pump [message #619959 is a reply to message #619956]

Sat, 26 July 2014 11:14

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

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.

Report message to a moderator

Re: Consistent backup using data pump [message #619964 is a reply to message #619959]

Sat, 26 July 2014 11:37

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 18 16:36:59 CDT 2025