Standby DB Parameters

# Changing Protection Mode:-  

alter database set standby database to maximum {availability|performance|protection};

# Status of protection mode on standby database:-

select protection_mode from v$database;

Availability	AFFIRM/NOAFFIRM	SYNC	DB_UNIQUE_NAME
Performance (default)	NOAFFIRM	ASYNC	DB_UNIQUE_NAME
Protection	AFFIRM	SYNC	DB_UNIQUE_NAME

1. With LGWR, default is sync used.
2. With ARCH , only SYNC is valid.
3. SYNC attribute is used for no data loss. It ensure that redo is transmitted successfully at destination before continue.

compatible=release_number

control_file_record_keep_time=no of days (0-365) 

control_files='/path/to/control_file.ctl','/path/to/control_file.ctl';

db_file_name_convert='location_primary_datafile','location_standby_datafile';

db_unique_name=unique_name_for_standby

fal_client=server_self_name  ( no longer recommend can skip)

fal_server=server_source_name (no longer recommend can skip)

instance_name=standby_db_unique_name

# for standby 

log_archive_config='DG_CONFIG=(db_unqiue_name_standby,db_unique_name_primary)'   (highly recommended)

# for primary 

log_archive_config='DG_CONFIG=(db_unqiue_name_primary,db_unique_name_standby)'   (highly recommended)

log_archive_dest_n={LOCATION=path_name | SERVICE=service_name, attribute,attribute,...} ...req

log_archive_dest_state_n={ENABLE|DEFER|ALTERNATE} ....required

log_archive_format=log_%d_%t_%s_%r.arc ----req

log_archive_max_processes=integer      .-----max arcn process (1-30) default 4 

log_file_name_convert='location_redo_logs_primary','location_redo_log_standby'; --------------req

standby_file_management={auto|manual}  ----req

To create standby db:

SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/u02/app/oracle/dbs/stbycf.ctl';

Copy the standby control file.
Copy the backup datafiles.
Copy all available archived redo logs to the standby site.
Copy the online redo logs. This is recommended for switchover and failover operations.