Post-Creation steps

Oracle

Audience
Public
Technology Integrations
Oracle
Source Type
Documentation

Update the init.ora parameters on the Standby database.

Update the following parameters in the init.ora file


db_file_name_convert='/TPCH1T/','/TPCH1T_S/'
log_file_name_convert='/TPCH1T/','/TPCH1T_S/'
STANDBY_FILE_MANAGEMENT=AUTO; 

Create the spfile for the Standby database from the pfile

Restart standby database

Restart the standby database normally, i.e. without specifying the pfile option.


SQL> startup nomount
ORACLE instance started.

SQL> alter database mount standby database;

Database altered.

SQL> alter database recover managed standby database disconnect from session;

Database altered.