export checklist

  • check undo_retention and undo tablespace in source db
  • see enough space in flash_recovery_area. sometimes export genrates high archives
  • create directory if it doesn’t exist
  • start export using flashback scn
  • if performing export in outage window then stop database services and restart database in restrict mode so that ther is no contention

import checklist

  • add bigger size redologs for faster import in target db. While doing this make sure db is in archivelog mode
  • once redolog added put db in noarchivelog mode
  • shutdown target and start target db in restrict mode before import (startup restrict;)
  • drop existing users if any
  • ensure if tablespace already exist then they have enough space same as source.
  • exclude=statistics (if time is constraint)
  • EXCLUDE=PASSWORD_HISTORY (if error in expdp)
  • exclude=INDEX,CONSTRAINT (if time is constraint)
  • use PARALLEL=12 (or lower value based on configuration)

post import validation checklist

  • compare object count
  • verify invalid objects count
  • match the parameter of source and target db
  • create services on new target same as source
  • shutdown the target db and start normally (disabling restict mode)
  • check remote connection
  • gather stats
  • verify connections comming to new target db
  • verfiy scheduler jobs
  • verify mviews
  • verify refresh group
  • gather stats
  • Below steps need if you are replacing the old db with new db
  • stop source db
  • disable services of source db