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

Last updated on AUGUST 01, 2024

Applies to:

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

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