hello everyone
i have installed windows server 2008r2 in both system in primary and standby
and installed database in primary and install software only in standby
i have set all physical standby related parameter in pfile etc.
when i startup in physical standby database error and database not open
error is;
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01245: offline file 1 will be lost if RESETLOGS is done
ORA-01110: data file 1: 'C:\APP\ADMINISTRATOR\ORADATA\STND\SYSTEM01.DBF'
standby initfile.ora
stnd.__db_cache_size=226492416
stnd.__java_pool_size=4194304
stnd.__large_pool_size=4194304
stnd.__oracle_base='C:\app\Administrator'#ORACLE_BASE set from environment
stnd.__pga_aggregate_target=222298112
stnd.__sga_target=423624704
stnd.__shared_io_pool_size=0
stnd.__shared_pool_size=176160768
stnd.__streams_pool_size=4194304
*.audit_file_dest='C:\app\Administrator\admin\prim\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='C:\app\Administrator\oradata\stnd\control01.ctl','C:\app\Administrator\flash_recovery_area\stnd\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='prim'
*.db_recovery_file_dest='C:\app\Administrator\flash_recovery_area'
*.db_recovery_file_dest_size=4102029312
*.db_unique_name='stnd'
*.diagnostic_dest='C:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=primXDB)'
*.local_listener='LISTENER_STND'
*.log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=stnd'
*.LOG_ARCHIVE_DEST_2='service=prim valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prim'
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=defer
*.db_file_name_convert='C:\app\Administrator\oradata\prim\','C:\app\Administrator\oradata\stnd\'
*.log_file_name_convert='C:\app\Administrator\oradata\prim\','C:\app\Administrator\oradata\stnd\'
*.standby_file_management=AUTO
*.FAL_SERVER='prim'
*.FAL_CLIENT='stnd'
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=643825664
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
primary database pfile/spfile
prim.__db_cache_size=226492416
prim.__java_pool_size=4194304
prim.__large_pool_size=4194304
prim.__oracle_base='C:\app\Administrator'#ORACLE_BASE set from environment
prim.__pga_aggregate_target=222298112
prim.__sga_target=423624704
prim.__shared_io_pool_size=0
prim.__shared_pool_size=176160768
prim.__streams_pool_size=4194304
*.audit_file_dest='C:\app\Administrator\admin\prim\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='C:\app\Administrator\oradata\prim\control01.ctl','C:\app\Administrator\flash_recovery_area\prim\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='prim'
*.service_names=prim
*.log_archive_format=%t_%s_%r.arc
*.db_recovery_file_dest='C:\app\Administrator\flash_recovery_area'
*.db_recovery_file_dest_size=4102029312
*.diagnostic_dest='C:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=primXDB)'
*.local_listener='LISTENER_PRIM'
*.memory_target=643825664
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
*.db_unique_name='prim'
*.log_archive_config='DG_CONFIG=(prim,stnd)
*.log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=prim'
*.LOG_ARCHIVE_DEST_2='service=stnd valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=stnd'
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.fal_server=stnd
*.fal_client=prim
*.db_file_name_convert='stnd','prim'
*.log_file_name_convert='C:\app\Administrator\oradata\prim','C:\app\Administrator\oradata\stnd'
thanks in advance