Database Administration (MOSC)

MOSC Banner

How to get the information if PDB is in forcelogging mode or noforcelogging mode

Hi,

in the cdb is forcelogging deactivatd. I can switch this in the PDBs. Where can i find this information in a view or table.

SQL> ALTER PLUGGABLE DATABASE ENABLE FORCE LOGGING;

Pluggable database altered.

Command to disable force logging:

SQL> alter pluggable database disable force logging;

Pluggable database altered.

Command to enable force nologging:

SQL> alter pluggable database enable force nologging;

Pluggable database altered.

Command to disable force nologging:

SQL> alter pluggable database disable force nologging;

Pluggable database altered.

Regards Thomas

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center