Home » RDBMS Server » Server Utilities » Services restart during datapump expdp and impdp (Oracle 11gr2,Linux 6)
Services restart during datapump expdp and impdp [message #601427] Wed, 20 November 2013 17:25 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,
Is it necessary to stop application server services before export and start services after export is taken ?
Could you please clarify ? Thanks


[MERGED by LF]

[Updated on: Sun, 01 December 2013 10:09] by Moderator

Report message to a moderator

Re: Services restart during datapump expdp and impdp [message #601430 is a reply to message #601427] Wed, 20 November 2013 17:31 Go to previous messageGo to next message
BlackSwan
Messages: 22905
Registered: January 2009
Senior Member
>Is it necessary to stop application server services before export and start services after export is taken ?
HUH?

How does application server know anything about export occurring or not?
Why would application care if export occurs or not?
export is just a separate session accessing data within the database; not different than any other client session.
Re: Services restart during datapump expdp and impdp [message #601480 is a reply to message #601430] Thu, 21 November 2013 07:31 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Blackswan,

So it means no need to restart services during logical backup. Thanks for your clarification and quick response.

[Updated on: Thu, 21 November 2013 07:32]

Report message to a moderator

Re: Services restart during datapump expdp and impdp [message #602178 is a reply to message #601480] Sat, 30 November 2013 21:37 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Can we take export backup of a schema when users are active and inactive in same database ? If not,
what would be the impact to users and backup ? Could you explain ?

Thanks,
Jack
Re: Services restart during datapump expdp and impdp [message #602179 is a reply to message #602178] Sat, 30 November 2013 21:49 Go to previous messageGo to next message
BlackSwan
Messages: 22905
Registered: January 2009
Senior Member
>Can we take export backup of a schema when users are active and inactive in same database ?

I give up.
Can you?

Can you Read The Fine Manual yourself?
http://docs.oracle.com/cd/E16655_01/server.121/e17633/consist.htm#CNCPT221

data that is changed after any "backup" is taken will not be restored since the data does not exist within the file.
Can any other session "see" uncommitted data?
Can any session "see" data that is changed after transaction starts?
Re: Services restart during datapump expdp and impdp [message #602182 is a reply to message #602179] Sat, 30 November 2013 22:55 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Blackswan,

<data that is changed after any "backup" is taken will not be restored since the data does not exist within the file.

I am talking about backup data that is taken during the backup.Because when users exist in database during the export backup will that be inconsistent or not advisable to take export backup when users are active ? could you please clarify ?

Thanks
Export backup [message #602191 is a reply to message #601427] Sun, 01 December 2013 02:59 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Is it advisable to take export backup when users are active and inactive in same database ?If no, what will be the impact
to users and export backup?Could you please clarify ?

Backup used -- datapump

Thanks
Re: Export backup [message #602197 is a reply to message #602191] Sun, 01 December 2013 05:48 Go to previous message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

BlackSwan already answered your question in your previous topic, you just have to read her link and try to understand it.

Previous Topic: data from M$ SQL into Oracle DB
Next Topic: importing tables....
Goto Forum:
  


Current Time: Thu Oct 23 06:58:43 CDT 2014

Total time taken to generate the page: 0.05677 seconds