-
Index Nologging?
Hi,
Index nologging question.
Oracle : 8.1.7.4.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.
Tan.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|