Index nologging question.
Oracle : 18.104.22.168.0
OS : HP-UX 11.0
Steps in re-building indexes.
For a particular table drop each individual index and recreate one-by-one. While rebuilding the index used the nologging option. Same for primary key index.
What would be the exposure in creating indexes (specially primary ) without nologging. No backup was taken. Regular hot backup taken at 9pm daily. Will the hot backup be sufficient to recover the indexes in case of db recovery.
ALso the column logging in user_indexes tabke is set to no.
Will changing to logging (Alter index
logging) cause problems in case of recovery?
This is the QA environment and need to implement the same steps for production. Would appreciate any help.
Thanks in advance.