NOLOGGING Database Objects

Contents:- Nologging Database Objects, Recovery of a NOLOGGING Database Objects

NOLOGGING

When you use NOLOGGING keyword with any transaction at that time no redo data is generated during that particular transactions.

i.e

SQL> create table demo_stc logging;

SQL> insert /* + APPEND */ into demo_stc (select * from stc);

Recovery of Nologging Objects

We cannot recover nologging database objects. So take backup of whatever tables you populate in this way.

If You perform media recovery and there are NOLOGGING Objects involved, they will be marked logically corrupt during the recovery process. In this case drop nologging objects and re-create them.

Use the following command to list the names of any tablespace that contain one or more objects for which a NOLOGGING operation has been performed since the most recent backup of the tablespace.

SQL> Report unrecoverable;