前言

一：备份与恢复概述

二：RMAN 工具概述

1： RMAN 组件

•        1： RMAN命令执行器

1 [oracle@localhost ~]$   2   3 Recovery Manager: Release 11.2.0.3.0 - Production  Tue Mar 27 23:58:10 2018  4   5 Copyright (c) 1982, 2011, Oracle / its affiliates.   rights reserved.  6   7 connected  target : ORCL (DBID=1457025880)  8   9 RMAN>  10 2> ; 11  12  target  control  instead  recovery  13 RMAN configuration parameters    db_unique_name ORCL : 14 CONFIGURE RETENTION POLICY  REDUNDANCY 1; #  15 CONFIGURE  OPTIMIZATION ; #  16 CONFIGURE  DEVICE TYPE  ; #  17 CONFIGURE CONTROLFILE AUTOBACKUP ; #  18 CONFIGURE CONTROLFILE AUTOBACKUP FORMAT  DEVICE TYPE   '%F'; #  19 CONFIGURE DEVICE TYPE  PARALLELISM 1  TYPE  BACKUPSET; #  20 CONFIGURE DATAFILE  COPIES  DEVICE TYPE   1; #  21 CONFIGURE ARCHIVELOG  COPIES  DEVICE TYPE   1; #  22 CONFIGURE MAXSETSIZE  UNLIMITED; #  23 CONFIGURE ENCRYPTION   ; #  24 CONFIGURE ENCRYPTION ALGORITHM 'AES128'; #  25 CONFIGURE COMPRESSION ALGORITHM 'BASIC'   RELEASE 'DEFAULT' OPTIMIZE    ; #  26 CONFIGURE ARCHIVELOG DELETION POLICY  ; #  27 CONFIGURE SNAPSHOT CONTROLFILE NAME  '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl.f'; #  28  29 RMAN>

•        2：目标数据库

•        3：RMAN恢复目录

•        4：介质管理子系统

•       5：备份数据库

•       6：恢复目录数据库

2：RMAN 通道

•        1 ：手动分配通道

                   示例：手动分配一个名称为 ch_1的通道，其文件路径为：/home/oracle/oracle_system_files_back/%u_%c.bak;

1 run{  2  channel ch_1 device type   3 format = 'd:\oraclebf\%u_%c.bak';  4  tablespace system,users,tbsp_1,ts_1 channel ch_1;  5 }

•        2：自动分配通道

——————————————————————————————————————————————————————————————————————————————————