Manually Create Standby Database from Hotbackup (9i)
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