rac + adg

1.
alter database archivelog ;
alter database force logging;
2.
alter database add standby logfile thread 1 group 11 size 50M;
alter database add standby logfile thread 1 group 12 size 50M;
alter database add standby logfile thread 1 group 13 size 50M; 

alter database add standby logfile thread 2 group 21 size 50M; 
alter database add standby logfile thread 2 group 22 size 50M; 
alter database add standby logfile thread 2 group 23 size 50M; 
3.
db_file_name_convert
+DATA/racsfx, /oradata/

log_file_name_convert
+DATA/racsfx/, /oradata/, +FLASH/racsfx/, /oradata/

log_archive_dest_1
LOCATION=+FLASH VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=racsfx


NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
log_archive_dest_2
SERVICE=dg ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dg

log_archive_dest_state_1
enable

log_archive_dest_state_2
ENABLE


NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
fal_server
DG

log_archive_config
DG_CONFIG=(racsfx,dg)

log_archive_format
%t_%s_%r.dbf


NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
log_archive_max_processes
4

standby_file_management
AUTO

remote_login_passwordfile
EXCLUSIVE


NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
db_name
racsfx

db_unique_name
racsfx
4.
*.compatible='11.2.0.4'
*.db_file_name_convert='+DATA/racsfx','/oradata/'
*.db_name='racsfx'
*.db_unique_name='dg'
*.fal_client='dg'
*.fal_server='scan'
*.log_archive_config='DG_CONFIG=(racsfx,dg)'
*.log_archive_dest_1='LOCATION=/oradata/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dg'
*.log_archive_dest_2='SERVICE=scan LGWR SYNC db_unique_name=racsfx valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'
*.log_file_name_convert='+DATA/racsfx/','/oradata/','+FLASH/racsfx/','/oradata/'
*.standby_file_management='AUTO'
5.
rman target / auxiliary sys/password@dg 

duplicate target database for standby from active database dorecover nofilenamecheck
6
alter database recover managed standby database using current logfile disconnect;
alter database recover managed standby database cancel;