Physical Standby database Configuration By coping Datafile from production to standby

1.. CREATE  PFILE OF PRIMARY DATABASE   WHICH CONTAINS  NECESSARY PARAMETERS  FOR PRIMAY DATABASE ENVIRONMENT

DB_UNIQUE_NAME=PRIMARY

SERVICE_NAMES=PRIMARY

LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIMARY,STANDBY)'

LOG_ARCHIVE_DEST_1='LOCATION=F:\oracle\product\10.2.0\flash_recovery_area\ORCL\ARCHIVELOG  VALID_FOR=(ALL_LOGFILES,ALL_ROLES) 

DB_UNIQUE_NAME=PRIMARY'

LOG_ARCHIVE_DEST_2='SERVICE=STANDBY LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc 

LOG_ARCHIVE_MAX_PROCESSES=30

FAL_SERVER=STANDBY

FAL_CLIENT=PRIMARY

DB_FILE_NAME_CONVERT='STANDBY','PRIMARY'

LOG_FILE_NAME_CONVERT='G:\oracle\product\10.2.0\oradata\ORCL','G:\oracle\product\10.2.0\oradata\orcl'

STANDBY_FILE_MANAGEMENT=AUTO

2. CREATE  PFILE FOR STANDBY DATABASE  

DB_UNIQUE_NAME=STANDBY

SERVICE_NAMES=STANDBY

LOG_ARCHIVE_CONFIG='DG_CONFIG=(STANDBY,PRIMARY)'

LOG_ARCHIVE_DEST_1='LOCATION=F:\oracle\product\10.2.0\flash_recovery_area\ORCL\ARCHIVELOG  VALID_FOR=(ALL_LOGFILES,ALL_ROLES) 

DB_UNIQUE_NAME=STANDBY'

LOG_ARCHIVE_DEST_2='SERVICE=PRIMARY LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIMARY'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

LOG_ARCHIVE_MAX_PROCESSES=30

FAL_SERVER=STANDBY

FAL_CLIENT=PRIMARY

DB_FILE_NAME_CONVERT='STANDBY','PRIMARY'

LOG_FILE_NAME_CONVERT='G:\oracle\product\10.2.0\oradata\ORCL','G:\oracle\product\10.2.0\oradata\orcl'

STANDBY_FILE_MANAGEMENT=AUTO

2.  CREATE SPFILE AND PWD FILE FOR PRIMARY DATABASE AND   PUT THE PRIMARY DATABASE IN  MOUNT MODE .

3. CREATE  STAND BY DATABASE CONTROLFILE USING  PRIMARY DATABASE CONTROLFILE  BY ISSUEING FOLLOWING COMMAND

ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/boston.ctl';

4. CREATE SERVICE FOR STANDBY DATABASE USING ORADIM AND ALSO CREATE NECESSARY DIRECTORY STRUCTURES . CREATE SPFILE AND PWD FILE FOR STANDBY DATABASE

5. COPY STANDBY DATABASE CONTROLFILE CREATED USING PRIMARY DB AND ALL DATAFILES  AND REDO LOG FILES TO STNAND BY DATABASE SERVER

6. create listener and add database services in listener.ora and host string in tnsnames.ora in both databases

7. MOUNT THE STANDBY DATABASE

8. create temporary tablespace for standby database

9. START REDO APPLYING BY ISSUEING FOLLOWING COMMAND

 ALTER DATABASE RECOVER STANDBY DATABASE DISCONNECT FROM SESSION