1.

Steps To Create Physical Standby Database?

Answer»
  1. Take a full hot backup of Primary database
  2. CREATE standby CONTROL file
  3. Transfer full backup, init.ora, standby control file to standby node.
  4. MODIFY init.ora file on standby node.
  5. Restore database
  6. RECOVER Standby database(Alternatively, RMAN DUPLICATE DATABASE FOR STANDBY DO RECOVERY can be also used)
  7. Setup FAL_CLIENT and FAL_SERVER parameters on both sides
  8. PUT Standby database in Managed Recover mode


Discussion

No Comment Found

Related InterviewSolutions