_____________________________________________________________________________________

set pages 1000
set lines 200
_____________________________________________________________________________________

DATABASE
========
alter database add logfile ('') size 50m;

alter database clear logfile group <NO>;

alter database create standby controlfile as '/tmp/orcl_stdby.ctl';


SESSION
=======
alter session set current_schema=SCOTT;

alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';


SYSTEM
======
alter system flush shared_pool;

alter system set db_file_name_convert='ORCL_STDBY','ORCL' scope=spfile;   -- show parameter db_file_name_convert

alter system set db_recovery_file_dest='<PATH>' scope=both;   -- show parameter db_recovery_file_dest
alter system set db_recovery_file_dest_size=50G scope=both;   -- show parameter db_recovery_file_dest_size

alter system set fal_server=orcl_stdby;   -- show parameter fal_server

alter system set log_file_name_convert='ORCL_STDBY','ORCL'  scope=spfile;   -- show parameter log_file_name_convert

alter system set service_names = 'orcl.oracle.com' scope=both;   -- show parameter service_names

alter system set standby_file_management=auto;   -- show parameter standby_file_management
_____________________________________________________________________________________

http://www.dba-oracle.com/t_alter_system_switch_logfile_vs_alter_system_archivelog_current.htm
_____________________________________________________________________________________