Standby Database Creation

http://shivanandarao-oracle.com/2012/03/10/creating-physical-standby-database-on-oracle-11g/

 alter system set log_archive_config='DG_CONFIG=(PRDB,SECDB)' scope=both; without setting this on Standby site.. Got below error

ORA 16047 DGID mismatch between destination setting and target database--> From V$archive_dest..
Since it's the error.. even RFS process didn't start which ships archives automatically to standby site..

Now..everything is fine..

Primary DB on Server Initfile

 strings -a spfileSECDB.ora
SECDB.__db_cache_size=314572800
SECDB.__java_pool_size=25165824
SECDB.__large_pool_size=4194304
SECDB.__oracle_base='/u02/app/oracle'#ORACLE_BASE set from environment
SECDB.__pga_aggregate_target=373293056
SECDB.__sga_target=700448768
SECDB.__shared_io_pool_size=0
SECDB.__shared_pool_size=339738624
SECDB.__streams_pool_size=4194304
*.audit_file_dest='/u01/app/oracle/admin/SECDB/adump'
*.audit_trail='DB'
*.compatible='11.2.0'
*.control_files='/u01/app/oracle/oradata/secdb/control01.ct
*.db_block_size=8192
*.db_domain=''
*.db_name='SECDB'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP)(SERVICE=ORA11XDB)'
*.event=''
*.fal_client='SECDB'
*.fal_server='PRDB'
*.log_archive_config='DG_CONFIG=(PRDB,SECDB)'
*.log_archive_dest_1='LOCATION=/u02/oradata/secdb/archive/'
*.log_archive_dest_2='SERVICE=PRDB ARCH ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRDB'
*.log_archive_dest_state_2='ENABLE'
*.memory_target=1073741824
*.open_cursors=30
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'

Standby DB on same server Init

[oracle@asus001n1 dbs]$  strings -a spfilePRDB.ora

PRDB.__db_cache_size=444596224

PRDB.__java_pool_size=4194304

PRDB.__large_pool_size=4194304

PRDB.__pga_aggregate_target=432013312

PRDB.__sga_target=641728512

PRDB.__shared_io_pool_size=0

PRDB.__shared_pool_size=176160768

PRDB.__streams_pool_size=0

*.audit_file_dest='/u02/app/oracle/admin/PRDB/adump'

*.audit_trail='db'

*.compatible='11.2.0'

*.control_files='/u02/app/oracle/oradata/prdb/control01.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_file_name_convert='/u01/app/oracle/oradata/s

ecdb/','/u02/app/oracle/oradata/prdb/'

*.db_name='SECDB'

*.db_unique_name='PRDB'

*.diagnostic_dest='/u02/app/oracle'

*.dispatchers='(PROTOCOL=TCP)(SERVICE=ORA11XDB)'

*.FAL_SERVER='SECDB'

*.log_archive_config='DG_CONFIG=(PRDB,SECDB)'

*.log_archive_dest_1='LOCATION=/u02/oradata/prdb/archive/'

*.log_archive_dest_2='SERVICE=SECDB ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=SECDB'

*.log_archive_dest_state_2='defer'

*.log_file_name_convert='/u01/app/oracle/oradata/secdb/'

,'/u02/app/oracle/oradata/prdb/'

*.memory_target=1G

*.open_cursors=300

*.remote_login_passwordfile='exclusive'

*.undo_tablespace='UNDOTBS1'

Password files for both instances need to have.

rman targer sys/oracle@SECDB auxiliary sys/oracle@PRDB

RMAN> duplicate target database for standby from active database nofilenamecheck;