[askdba] Re: LOGGING Feature in database

  • From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>
  • Date: Thu, 11 Nov 2004 10:12:55 -0700

A database-level FORCE LOGGING setting will always take precedence. =20

Justin Cave  <jcave@xxxxxxxxxxx>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
On Behalf Of Rajesh Puneyani
Sent: Thursday, November 11, 2004 11:35 AM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: LOGGING Feature in database

Thanks Justin,

But if any object has been created with NOLOGGING Option (before
Standby was created) then what will be the impact of this table level
setting on DMLs on that table and ultimately on Standby ?

I assume that DB Level LOGGING takes the precedence again...Right ?

Regards
Rajesh

On Thu, 11 Nov 2004 09:13:29 -0700, Justin Cave (DDBC)
<jcave@xxxxxxxxxxx> wrote:
> A database-level FORCE LOGGING setting will override any NOLOGGING
> command.  FORCE LOGGING is designed to ensure, for example, that a
> developer cannot compromise a standby database by doing a NOLOGGING
> operation.
>=20
> Justin Cave  <jcave@xxxxxxxxxxx>
> Distributed Database Consulting, Inc.
> http://www.ddbcinc.com/askDDBC
>=20
>=20
>=20
> -----Original Message-----
> From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
> On Behalf Of Rajesh Puneyani
> Sent: Thursday, November 11, 2004 10:55 AM
> To: askdba@xxxxxxxxxxxxx
> Subject: [askdba] LOGGING Feature in database
>=20
> Hi guys,
>=20
> This is just to confirm -=3D20
>=20
> If I have FORCE LOGGING enabled at the database level then every DDL
> command I execute (without specifying LOGGING/NOLOGGING option) would
> be executed using LOGGING option.
>=20
> IF I specifically say NOLOGGING in ALTER TABLE ...MODIFY (for example)
> then NOLOGGING has the priority.
>=20
> Pls confirm or clarify.
> Thanks
> Rajesh
>=20
>


Other related posts: