Database Administration (MOSC)

MOSC Banner

Use of "nologging" option create or rebuid index

edited Jan 27, 2014 2:51PM in Database Administration (MOSC) 17 commentsAnswered
Hello.  Question regarding creating or rebuilding an index with the "nologging" option in a database in archive log mode and Rman backup are occurring.

My understanding is that using the nologging option will not generate redo and thus no archive logs.  By using the
"nologging" oiption I'm trying to avoid the generation of large quantities of archive logs as the index I'm creating
(or rebuilding) is large and I noticed large amounts of archive logs were genereated when I used the "alter index rebuild".
Is this the case?

And, if I used the "nologging" clause this won't affect my Rman backups?  Is this correct?  I'm thinking the activity generated

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