Index Nologging?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Index Nologging?

  1. #1
    Join Date
    Jul 2001
    Posts
    15

    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.

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: Index Nologging?

    Originally posted by tan_swap
    Will the hot backup be sufficient to recover the indexes in case of db recovery.
    Yes..
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width