I think you mean
ALTER DATABASE FORCE LOGGING
you can use this command where database is mounted or open
This command take precedence over Logging | Nologging seting on tablespace
or individual objects
This command will NOT LOGGED from temporary tablespaces or temporary objects

Best Regards
Krystian Zieja / mob
> Hi Gurus,
>
>
>
> To ensure that logging is done i have set ALTER SYSTEM FORCE LOGGING
> this due to avoid gaps in rman.
>
> Nou I find some tables that indicate that logging is off and force
> logging also off.
>
>
>
> Does the ALTER SYSTEM FORCE LOGGING overwrite this?
>
>
>
> Tonny de Groot
> DienstenCentrum van:
> College voor zorgverzekeringen / College Toezicht Zorgverzekeringen
> Eekholt 4
> 1112 XH Diemen
> Tel: + 31 20 - 7978240
> Fax: + 31 20 - 7978300
> Mob: + 31 6 - 52044711
> Email: [Email address protected] <BLOCKED::mailto:[Email address
> protected]
> Postadres:
> Postbus 326
> 1110 AH Diemen
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>



Oracle LazyDBA home page