Primary database Primary Server: willsys(192.168.100.59)
   
1.Create Control File which should be used to start the standby server
----command--
alter database create standby controlfile as '/oracle/cntrlW05.dbf' 
copy this control file to standby server and copy it into locations specified in initSID.ora(control_files)

2.set up the parameters in initsid.ora 

LOG_ARCHIVE_DEST_1='LOCATION=/oracle/W05/oraarch MANDATORY REOPEN=30'
LOG_ARCHIVE_DEST_2='SERVICE=STDBY LGWR ASYNC AFFIRM'
LOG_ARCHIVE_DEST_STATE_1=enable
LOG_ARCHIVE_DEST_STATE_2=enable
LOG_ARCHIVE_FORMAT=arc%t_%s_%r.arc
REMOTE_ARCHIVE_ENABLE=true

---LOG_ARCHIVE_DEST_2,DEst_3 upto dest_31 Standby servers can be configured

3.Rename the init file and spfile.create initfile with above parameters and recreate spfile.
----command--
create spfile from pfile; (so that new parameters will effective)

4.Entry into tnsnames.ora to identify the servicenames

    STDBY.WORLD=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = WILLSYS60)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = W05)
    )
  )  
--Standby Server---Secondary Server:willsys60(192.168.100.58

5.  provide the following entries in stdby initSID.ora

*.log_archive_dest_1='location=/oracle/W05/oraarch'
*.log_archive_dest_state_1=enable
*.log_archive_format=arc%t_%s_%r.arc
*.service_names = stdby
*.fal_server=W05
*.fal_client=W05
*.standby_archive_dest='/oracle/W05/oraarch'
*.standby_file_management=AUTO
*.remote_archive_enable=true                 

6.Rename the init file and spfile.
create initfile with above parameters and recreate spfile.
----command--
create spfile from pfile; (so that new parameters will effective)

7.tnsnames.ora

stdby.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = WISSERVER16)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = W05)
    )
  )
note a. ecc5 their is no file in tnsnames.ora in this path(/usr/sap/SID/SYS/profile/oracle)
     b.ecc6 their is a file in tnsnames.ora in this path(/usr/sap/SID/SYS/profile/oracle),wih SIDADM chownership
8.listener.ora

(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = WISSERVER16)(PORT = 1521))
)

STANDBY_LISTENER = (ADDRESS_LIST=
 (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=WISSERVER16))
)
----------------------
9.shutdown primary server and copy sapdata1---data..n ,origlogA and B,mirorlog A and B from Primary to Secondary Server
Copy the standby Control file generated in step 1 to standby server control file locations

10.start the primary as usual and check for any errors in alter<Sid>.log

11.Now Start the standby database in nomount mode,
---command---
startup nomount

12.start database in standby mount mode.

---command---
alter database mount standby database

13.Start the managed recovery operation:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION

14.check the recovery operation by using the following commands

sqlplus> SELECT PROCESS,STATUS FROM V$MANAGED_STANDBY;
sqlplus>SELECT SEQUENCE#,FIRST_TIME,NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;


15.Cancel managed recovery operations.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL>Alter database read only
SQL>Shutdown immeidate----to restart again in standby mode

16.ALTER SYSTEM ARCHIVE LOG CURRENT;--to switch logfile--

NOte: Do not open the database,if it is opened then the 9 the step has to be repeated again


17.Activating Standby Server

sql>ALTER DATABASE ACTIVATE STANDBY DATABASE;
     shut immediate
     startup

note:a.11,12,13,15,17 these point do only standby server
     b.14(do in both standbyand primary)
     c.16(do only in pimary)