My Oracle Support Banner

RDBPROD: Consequences Of Using NOLOGGING On CREATE INDEX (Doc ID 2679048.1)

Last updated on APRIL 14, 2022

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.3.3.1 and later
Information in this document applies to any platform.

Goal

Question 1: What are Oracle's recommendations for the use of the NOLOGGING clause on the CREATE INDEX? Does the NOLOGGING only indicate that minimal information is logged to the AIJ and RUJ file solely on the index creation?
 
Question 2: When I use the NOLOGGING on a CREATE INDEX, I get these warnings prompting me to do a full backup afterward to ensure recoverability.

%RDB-W-META_WARN, metadata successfully updated with the reported warning
-RDMS-W-DATACMIT, unjournaled changes made; database may not be recoverable
-RDMS-W-DOFULLBCK, full database backup should be done to ensure future recovery

So, it would appear that a ramification of using the NOLOGGING option is that it must be followed with a full database backup to avoid potential trouble down the road?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.