视频1 视频21 视频41 视频61 视频文章1 视频文章21 视频文章41 视频文章61 推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37 推荐39 推荐41 推荐43 推荐45 推荐47 推荐49 关键词1 关键词101 关键词201 关键词301 关键词401 关键词501 关键词601 关键词701 关键词801 关键词901 关键词1001 关键词1101 关键词1201 关键词1301 关键词1401 关键词1501 关键词1601 关键词1701 关键词1801 关键词1901 视频扩展1 视频扩展6 视频扩展11 视频扩展16 文章1 文章201 文章401 文章601 文章801 文章1001 资讯1 资讯501 资讯1001 资讯1501 标签1 标签501 标签1001 关键词1 关键词501 关键词1001 关键词1501 专题2001
OracleRMAN增量备份完整恢复测试
2020-11-09 11:58:33 责编:小采
文档


增量备份等级0:相当于full backup,备份整个datafile blocks,可以作为增量备份的起点;1-4:该等级有2个备份模式差异性增量备份

测试环境:

Linux 5.4-32位,,Oracle 11.2

创建测试表空间:

SQL> create tablespace tablespace1

2 datafile '/db/app/oracle/oradata/orcl/tablespace1.dbf'

3 size 10m;

Tablespace created.

SQL>

创建测试用户并指定为默认表空间:

SQL> create user user1 identified by oracle default tablespace tablespace1;

User created.

SQL>

设置该测试用户权限:

SQL> grant create session,create table,unlimited tablespace to user1;

Grant succeeded.

SQL>

用新创建的用户登录:

SQL> conn user1/

Enter password:

Connected.

SQL>

建表并写入数据:

SQL> create table table1 (id int,name varchar2(30));

Table created.

SQL> insert into table1 values(0001,'Tian');

1 row created.

SQL> insert into table1 values(0002,'zhong');

1 row created.

SQL> select * from table1;

ID NAME

---------- ------------------------------

1 Tian

2 zhong

SQL> commit;

Commit complete.

配置RMAN环境变量

切换sys用户作0级备份:

利用configure命令配置RMAN环境:

RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;#开启归档日志自动备份

RMAN>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/db/bak/ctf/%d_ctf_bak_%F';#指定归档日志备份位置

RMAN>CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;#采用并行度为2且压缩备份集的方式备份到磁盘。

RMAN>CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/db/bak/disk1/%d_datafile_bak_%U';

RMAN>CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/db/bak/disk2/%d_datafile_bak_%U';

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/db/bak/ctf/%d_ctf_bak_%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;

CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/db/bak/disk1/%d_datafile_bak_%U';

CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/db/bak/disk2/%d_datafile_bak_%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/db/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

备份全库(包括归档日志及启动参数文件等):

RMAN>

RMAN> backup incremental level 0 database plus archivelog;

Starting backup at 06-MAY-11

current log archived

using channel ORA_DISK_1

….

….(省略过程)

提示备份成功。可以再通过RMAN>list backup;查看已有备份确认(注意LV 字段全为0,为0级增量备份)。

继续往测试表中插入新数据:

SQL> insert into table1 values(3,'wang');

1 row created.

SQL> insert into table1 values(4,'newtest');

1 row created.

SQL> select * from table1;

ID NAME

---------- ------------------------------

1 Tian

2 zhong

3 wang

4 newtest

SQL> commit;

Commit complete.插入成功,并提交。

1级增量备份全库:

RMAN> backup incremental level 1 database plus archivelog;

省略备份过程细节。

提示备份成功。可以再通过RMAN>list backup;查看已有备份确认(此时LV字段包含0和1,表示目前备份中已包含有0级和1级增量备份)。

下载本文
显示全文
专题