oracle 笔记2（Fundamentals II）

六、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