oracle 笔记2（Fundamentals II）

最新推荐文章于 2021-04-08 23:52:56 发布

原创最新推荐文章于 2021-04-08 23:52:56 发布 · 500 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #archive #system #transactions #allocation #database

oracle 专栏收录该内容

34 篇文章

订阅专栏

本文介绍了Oracle数据库备份与恢复的概念，包括故障类别如语句失败、实例失败等；讨论了实例与媒体恢复结构，涉及动态视图和参数调整；详细说明了归档模式配置过程，包括自动与手动归档操作；最后概述了Oracle恢复管理器(RMAN)的使用方法及配置。

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