六、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
archive log list
九、Oracle Recover Manager Overview and Configuration
1、RMAN Components
2、RMAN COMMAND
rman target sys/sunlin@st 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 neet backup;
3、Auto Channel Allocation