You also have to make sure, in Oracle 10g and higher, that FORCE LOGGING has
not been done at the database level, or any level higher than you are
specifying.

Don't forget also that if you are running a Hot Standby - the tablespace
that the NOLOGGING operation occurs in will have to be recovered. These
operations also will not be replicated in any Logical Standby or Streams
replicas, because the data wasn't in the logs to mine them.

Hope this helps.

<<MrO>>

----- Original Message -----
From: "Geerlings Mark "
<oracledba-ezmlmshield-x95691679.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, September 06, 2007 10:51 AM
Subject: RE: Can you take a tablespace out of archive mode?


> Yes, Walter is correct, you can set "nologging" at either the tablespace
> or the individual table or index level.
>
> However, this "nologging" only applies to the restricted types of
> inserts that I described in my earlier message.
>
> -----Original Message-----
> From: Walter Hunnel
> [mailto:oracledba-ezmlmshield-x13492915.[Email address protected]
> Sent: Thursday, September 06, 2007 10:44 AM
> To: LazyDBA Discussion
> Subject: RE: Can you take a tablespace out of archive mode?
>
> As far as I know (mainly 9.2) the direct answer is 'No'.
>
> However, you can take the tablespace out of logging mode, which would
> not generate redo logs, which would not generate archive logs.
>
> Of course, you can not PIT restore/recover that tablespace either...
>
>
>
> Confidentiality Notice: This e-mail message, including any attachments,
> is for the sole use of the intended recipient(s) and may contain
> confidential and privileged information. Any unauthorized review, use,
> disclosure or distribution is prohibited. If you are not the intended
> recipient, please contact the sender by reply e-mail and destroy all
> copies of the original message.
>
>
> From: Faris Michael
> [mailto:oracledba-ezmlmshield-x9887677.[Email address protected]
> Sent: Thursday, September 06, 2007 09:26
> To: LazyDBA Discussion
> Subject: Can you take a tablespace out of archive mode?
>
> Hello,
>
> I've got a database running in archive mode that we
> eventually use to build a reporting database. We now have a few
> tablespaces in the original database that are being updated enough to
> create lot's of archive logs. The number of archive logs is starting to
> delay the 'recovery'/building of the report database. I'd like to remove
> these tablespaces from the archiving process so the number and size of
> the logs is much less, there by allowing the report database to be built
> quicker. Is it possible to remove a tablespace from the archive mode
> process? Do I have to take the tablespace out of archive mode from the
> get go or is it something I need to do with in the 'recovery'/build
> process of the report database?
>
>
>
> Thanks, any and all help is appreciated.
>
>
>
> Michael Faris
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
> dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT
FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR
THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the
intended recipient, you are hereby notified that any review, distribution,
or copying of this communication is strictly prohibited. If you have
received this communication in error, please immediately notify the sender
by return e-mail, and delete this e-mail message and any attachments from
your computer.
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


Oracle LazyDBA home page