六、Backup and Recovery Overview
1、Categories of Failures
(1) Statement failure
(2) User process failure
(3) User error
(4) Network failure
(5) Instance failure
(6) Media failure
七、Instance and Media Recovery Structures
1、Dynamic Views
--v$sga
--v$sgastat
--v$instance
--v$process
--v$bgprocess
--v$database
--v$datafile
2、
Mean-Time-Between-Failures: MTBF
Mean-Time-To-Recover: MTTR
3、 parameters
--fast_start_mttr_target
--log_checkpoint_interval
--log_checkpoint_timeout
--v$instance_recovery
Tuning the RFP(roll forward phase)
--recovery_parallelism
Tuning the RBP(rollback phase)
Monitoring Parallel Rollback
--v$fast_start_servers
--v$fast_start_transactions
八、Configuring the Database Archiving Mode
1、自动归档
archive log list;
alter database archivelog;
Enable After Instance Startup
show parameter log_archive_start;
alter system set log_archive_start=true scope=spfile;
alter system archive log start to '/home/oracle/admin/TS/archdest';
alter system archive log start;
2、Manually Archiving
alter system archive log current;
3、
alter system set log_archive_dest_1="location=/home/oracle/admin/TS/archdest" scope=both;
alter system set log_archive_format="%$ORACLE_SID%t_%s_%r.arc" scope=spfile;
4、Dynamic views
--v$archived_log
--v$archive_dest
--v$log_history
--v$database
--v$archive_processes
九、Oracle Recover Manager Overview and Configuration
1、RMAN Components
2、RMAN COMMAND
rman target sys/odps@kevin nocatalog;
configure controlfile autobackup on;
configure channel device type disk format '/tmp/backup/%U';
configure controlfile autobackup clear; --恢复到默认值
list backup of database;
list backup of datafile '/home/oracle/oradata/TS/system01.dbf';
list backup of tablespace 'SYSTEM';
list copy of tablespace 'SYSTEM';
report schema;
report need backup;
3、Auto Channel Allocation