Manually Create Standby Database from Hotbackup (9i)

From NazimWIKI
Jump to navigation Jump to search

This is basically a "Note-To-Self".


High Level Steps for Reference, are:


  • Copy Datafiles across.
  • On Target, set up env variables, password file, oratab entry etc.
  • In the init.ora, pay particular attention to parameters:
    • db_name -> Same as the Primary Database to match the Controlfile
    • log_archive_format
    • log_archive_dest
    • log_file_name_convert
    • db_file_name_convert
    • fal_client
    • fal_server
  • Use a standby controlfile from the hotbackup, or create one manually