OCP 11gR2: Administration II 練習筆記 (一)

Lession 01:

================================================================

1. Find FRA location

show parameter db_recovery_file_dest

2. Try RMAN simply backup function

run {

sql 'alter system archive log current;

allocate channel ch1 device type disk format '/tmp/db_%U';

backup as backupset database;

}

3. Find database log mode and archive log location

select name, log_mode from v$database;

archive log list;

show parameter log_archive_dest

4. config archive log location & guarantee archive log success

alter system set log_archive_dest_1='LOCATION=/tmp' scope=both;

alter system set log_archive_min_succeed_dest=2;
or
specify archive mandatory <-- it will ignore log_archive_min_succeed_dest parameter.

5. RMAN retention policy { recovery window | redundancy }
The retention policy should longer than full backup, otherwise, the restore may failed.
The keep days depend on backup policy without recovery catalog max 30 days.
ps: if configure retention policy to none, = no obsolete mark only.

6. Check RMAN backup history
parameter control_file_record_keep

7. Configure archvielog deletion policy
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;

8. Monitoring FRA history
EM -> All Metrics -> RECOVERY AREA -> RECOVERY AREA

OCP 11gR2: Administration II 練習筆記 (二)