Performing Oracle User-Managed Database Recoveries - OCP: Oracle Database 12c Administrator Certified Professional - page 92

LOGFILE
GROUP 1 (
'/oracle01/oradata/orcl/redo01.log',
'/oracle01/oradata/orcl/redo01a.log'
) SIZE 100M,
GROUP 2 (
'/oracle01/oradata/orcl/redo02.log',
'/oracle01/oradata/orcl/redo02a.log'
) SIZE 50M,
GROUP 3 (
'/oracle01/oradata/orcl/redo03.log',
'/oracle01/oradata/orcl/redo03a.log'
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'/oracle01/oradata/orcl/system01.dbf',
'/oracle01/oradata/orcl/sysaux01.dbf',
'/oracle01/oradata/orcl/undotbs01.dbf',
'/oracle01/oradata/orcl/users01.dbf',
'/oracle01/oradata/orcl/example01.dbf',
'/oracle01/oradata/orcl/retention_archives_01.dbf',
'/oracle01/oradata/orcl/my_secure_tbs_01.dbf',
'/oracle01/oradata/orcl/my_second_secure_tbs_01.dbf'
CHARACTER SET WE8MSWIN1252
;
-- Configure RMAN configuration record 1
VARIABLE RECNO NUMBER;
EXECUTE :RECNO :=
SYS.DBMS_BACKUP_RESTORE.SETCONFIG('COMPRESSION ALGORITHM','''BZIP2''');
-- Configure RMAN configuration record 2
VARIABLE RECNO NUMBER;
EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE
AUTOBACKUP','ON');
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- ALTER DATABASE REGISTER LOGFILE
'/oracle01/fast_recovery_area/ORCL/archivelog/2013_08_16/o1_mf_1_1_%u_.arc';
-- ALTER DATABASE REGISTER LOGFILE
'/oracle01/fast_recovery_area/ORCL/archivelog/2013_08_16/o1_mf_1_1_%u_.arc';