When running nightly exports include a ROWS=N and FULL=Y job.
When recovering from a failure, this export file can accelerate the rebuild process. It contains a copy of ALL the metadata, and can be used to re-create the complete infrastructure that supports your database. Without a metadata-only export, this infrastructure can be built from a full database export (using ROWS=N on import), but it takes much longer to read a full database export with data. Remember, time-to-market for recovery is crucial.
If you have migrated to 10g and Oracle data pump, the equivalent is FULL=Y and CONTENTS=METADATA_ONLY.
Have a question you would like to ask our expert?
