idxrebuild

[raviraju]

why we need idxrebuild in binary dump and load. suddenly if any error will come after idexrebuild or session got end suddenly that what to do?

 

[cj_brandt]

You need to build indexes after a binary load because the index entries are not created during the binary load process.

 

[Rob Fitzpatrick]

You should back up your database after the load and prior to the idxbuild. If the idxbuild crashes, reverting to a backup may be your only option.

 

[RealHeavyDude]

A crashed index rebuild leaves the database in an unusable state until the index rebuild completes successfully. Therefore if you encounter a crash in an index rebuild than your only options are:

• Restore your last good backup and roll the after images forward (when after image is enabled).
• Re-run the index rebuild until you succeed and fixing the problems the prevent a successful index rebuild along the way. Most common cause for an index rebuild to crash are either corruption ( ambiguous records that violate a unique index ) or insufficient disk space for the temporary sort files.

Heavy Regards, RealHeavyDude.