OraFAQ Forum: Server Utilities » avoid archive log generation ???

Home » RDBMS Server » Server Utilities » avoid archive log generation ???

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

avoid archive log generation ??? [message #179149]

Mon, 26 June 2006 01:32

tridentadm
Messages: 142
Registered: March 2006

Senior Member

is there anyway i can stop the logs(arhive logs) being generated during exp/imp ??

Report message to a moderator

Re: avoid archive log generation ??? [message #179166 is a reply to message #179149]

Mon, 26 June 2006 02:50

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

You can always switch the database into NOARCHIVELOG before and back to ARCHIVELOG after the import.

Report message to a moderator

Re: avoid archive log generation ??? [message #179238 is a reply to message #179149]

Mon, 26 June 2006 08:05

tridentadm
Messages: 142
Registered: March 2006

Senior Member

quite interesting...
i dont know if thats in a remotest sense possible on production databases.

even if i make an attempt...my boss will tell me to bye bye.

Report message to a moderator

Re: avoid archive log generation ??? [message #179243 is a reply to message #179238]

Mon, 26 June 2006 08:16

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

Senior Member
Account Moderator

>> if thats in a remotest sense possible on production databases.
Then, would it be sensible to stop archived logging in a production database? Only possible method (with sense) is what Frank has said.
You can minimize the redo generation. But cannot stop it.
Regards~

[Updated on: Mon, 26 June 2006 08:24]

Report message to a moderator

Previous Topic:	Full database export
Next Topic:	SQLLDR Case5 Load into multiple tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 19:39:47 CDT 2024