OraFAQ Forum: Backup & Recovery » Want to Export User of 24x7 database... do i have to shutdown my database for it?

Home » RDBMS Server » Backup & Recovery » Want to Export User of 24x7 database... do i have to shutdown my database for it?

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

Want to Export User of 24x7 database... do i have to shutdown my database for it? [message #119066]

Tue, 10 May 2005 08:48

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

My database is 24x7 and i want to do export of all the user scehma with their all object and data.... Now can any one tell me as my database is 24x7 i have to shutdown my database to take export...

Thank you
Sunil

Report message to a moderator

Re: Want to Export User of 24x7 database... do i have to shutdown my database for it? [message #119069 is a reply to message #119066]

Tue, 10 May 2005 08:52

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

Senior Member
Account Moderator

If you shutdown your database, You cannot take the export.

Report message to a moderator

Re: Want to Export User of 24x7 database... do i have to shutdown my database for it? [message #119073 is a reply to message #119069]

Tue, 10 May 2005 09:18

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

thank you maheshji

Report message to a moderator

Re: Want to Export User of 24x7 database... do i have to shutdown my database for it? [message #119109 is a reply to message #119073]

Tue, 10 May 2005 11:33

DaljitSingh
Messages: 4
Registered: May 2005

Junior Member

Hi,

You can take a consistent export upto a particular time by using CONSISTENT=Y parameter, but be aware of ROLLBACK segments issue too.

Daljit Singh

Report message to a moderator

Previous Topic:	RMAN backup hangs !!!!
Next Topic:	how to set RMAN backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 06:16:22 CST 2024