Posts

Showing posts from January 27, 2014

Configuring standby R12 application/database server using RMAN

Oracle Application R12.1.3 Database 11.2.0.3 Os OEL 5.7 vmprod-primary - Primary Database vmprod-standby - Standby Database Installation base (Both Application and Database) /u02/oracle/ERPDG 1. Prepare Primary Database Server Check if force logging is enabled SYS@ERPDG*vmprod-primar$ select force_logging from v$database; If not enabled enable it with following command SYS@ERPDG*vmprod-primar$ alter database force logging ; Create Oracle Net service names and Listener Modification required to for net connfiguration to setup standby database will be done using ifiles As autoconfig overwrites changes made to tnsnames and listener files, configuration changes required for net configuration files to setup standby database will be done using ifiles. Create/Modify ifiles Go to TNS_DMIN cd $TNS_ADMIN Ifile names listener = listener_ifile.ora tsnames = ERPDG_vmprod-primary_ifile.ora Note: Check th