Database Software

Hi all,

I'm working on a Physical data guard with Oracle 11.gR2 under linux.
I've setup a fast recovery area and archivelogs are sent there.

When I configure the standby, it does not work.

primary init:

==============================
orcl.__db_cache_size=16777216
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=272629760
orcl.__sga_target=406847488
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=142606336
orcl.__streams_pool_size=4194304
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/fast_recovery_area/orcl/control02.ctl'
*.cursor_sharing='FORCE'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_keep_cache_size=0
*.db_name='orcl'
*.db_unique_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4227858432
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.java_pool_size=12582912
*.large_pool_size=4194304
*.memory_max_target=0
*.memory_target=0
*.open_cursors=300
*.optimizer_features_enable='11.2.0.1'
*.optimizer_use_sql_plan_baselines=FALSE
*.pga_aggregate_target=195035136
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_manager_plan='FORCE:'
*.session_cached_cursors=50
*.sga_max_size=0
*.sga_target=0
*.shared_pool_size=125829120
*.undo_tablespace='UNDOTBS1'
*.LOG_ARCHIVE_MAX_PROCESSES=4
*.FAL_CLIENT='orcl'
*.FAL_SERVER='orclsb'
*.LOG_FILE_NAME_CONVERT='orcl','orcl'
*.standby_file_management='AUTO'
**.LOG_ARCHIVE_DEST_10='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'*
**.LOG_ARCHIVE_DEST_2='SERVICE=orclsb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orclsb'*
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.LOG_ARCHIVE_DEST_STATE_10=ENABLE
*.LOG_ARCHIVE_CONFIG='NORECEIVE,DG_CONFIG=(orcl,orclsb)'

==============================

Standby init:

================================
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl'
*.cursor_sharing='FORCE'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_keep_cache_size=0
*.db_name='orcl'
*.db_unique_name='orclsb'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4227858432
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.java_pool_size=12582912
*.large_pool_size=4194304
*.memory_max_target=0
*.memory_target=0
*.open_cursors=300
*.optimizer_features_enable='11.2.0.1'
*.optimizer_use_sql_plan_baselines=FALSE
*.pga_aggregate_target=195035136
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_manager_plan='FORCE:'
*.session_cached_cursors=50
*.sga_max_size=0
*.sga_target=0
*.shared_pool_size=125829120
*.undo_tablespace='UNDOTBS1'
*.LOG_ARCHIVE_MAX_PROCESSES=4
*.FAL_CLIENT='orclsb'
*.FAL_SERVER='orcl'
*.LOG_FILE_NAME_CONVERT='orcl','orcl'
*.standby_file_management='AUTO'
**.LOG_ARCHIVE_DEST_10='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orclsb*
**.LOG_ARCHIVE_DEST_2='SERVICE=orcl LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl'*
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.LOG_ARCHIVE_DEST_STATE_10=ENABLE
*.LOG_ARCHIVE_CONFIG='NORECEIVE,DG_CONFIG=(orcl,orclsb)'
================================

According to documentation, if i'm not wrong when using USE_DB_RECOVERY_FILE_DEST, LOG_ARCHIVE_DEST_10 has to be used.

In the alert of primary I see:

FAL[server, ARC2]: Error 16065 creating remote archivelog file 'orclsb'
FAL[server, ARC2]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance orcl - Archival Error. Archiver continuing.


In the trace I see:


Error 16065 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'orclsb'
*** 2011-07-12 16:00:34.264 2864 krsi.c
krsi_dst_fail: dest:2 err:16065 force:0 blast:1
kcrrwkx: unknown error:16065


Any help would be very useful.

I think the problem is I'm using USE_DB_RECOVERY_FILE_DEST for location of archivelogs, instead of a filesystem location.

Thanls in advance.