_____________________________________________________________________________________

Managing Archived Redo Logs
http://docs.oracle.com/cd/E11882_01/server.112/e25494/archredo.htm#ADMIN008

ALTER SYSTEM SWITCH LOGFILE vs ALTER SYSTEM ARCHIVE LOG CURRENT
http://www.dba-oracle.com/t_alter_system_switch_logfile_vs_alter_system_archivelog_current.htm

_____________________________________________________________________________________

ENABLE/DISABLE ARCHIVE LOG MODE
===============================
shutdown immediate
startup mount
alter database archivelog;      -- alter database noarchivelog;
alter database open;
alter system switch logfile;
alter system archive log current;



USE FAST RECOVERY AREA
======================
alter system set db_recovery_file_dest_size=10g scope=both;
alter system set db_recovery_file_dest='<FILE_SYSTEM>' scope=both;
alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=<DB_UNIQUE_NAME>' scope=both;


CLASSIC
=======
alter system set log_archive_dest_1='location=/home/oracle/archivelog' scope=spfile;
alter system set log_archive_format = 'log%t_%s_%r.arc' scope=spfile;

/*
LOG_ARCHIVE_FORMAT is applicable only if you are using the redo log in ARCHIVELOG mode. Use a text string and variables to specify the default filename format when archiving redo log files. The string generated from this format is appended to the string specified in the LOG_ARCHIVE_DEST parameter.

The following variables can be used in the format:

 %s log sequence number
 %S log sequence number, zero filled
 %t thread number
 %T thread number, zero filled
 %a activation ID
 %d database ID
 %r resetlogs ID that ensures unique names are constructed for the archived log files across multiple incarnations of the database

Using uppercase letters for the variables (for example, %S) causes the value to be fixed length and padded to the left with zeros.
*/
_____________________________________________________________________________________

GENERAL INFO
============
archive log list;

show parameter db_recovery_file_dest
show parameter db_recovery_file_dest_size

select name, log_mode from v$database;

column member format a60
select l.group#, l.members, l.archived, l.status, f.type, f.member, l.bytes/1024/1024 "MB"
from v$log l, v$logfile f
where l.group# = f.group#
order by 1, 6;

_____________________________________________________________________________________