Create physical standby from backup
Before building out your standby, ensure that the database has force logging enabled in your primary database. ALTER DATABASE FORCE LOGGING; 1. Ensure that your TNS_ADMIN is pointing to the proper location (typically this will be the Oracle Home where your database will utilize). echo $TNS_ADMIN export TNS_ADMIN=$ORACLE_HOME/network/admin 2. Modify tnsnames.ora in $TNS_ADMIN on both primary and standby locations to include both your standby database TNS entry and the primary database TNS entry. (example) stbydb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1525)) ) (CONNECT_DATA = (SERVICE_NAME = stbydb) ) ) prmrydb = (DESCRIPTION = ...