Oracle RMAN 增量备份完整恢复测试

测试环境：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 zhongSQL> 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; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE 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; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE 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; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM "AES128"; # defaultCONFIGURE COMPRESSION ALGORITHM "BASIC" AS OF RELEASE "DEFAULT" OPTIMIZE FOR LOAD TRUE ; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE 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-11current log archivedusing 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 newtestSQL> commit;Commit complete.插入成功，并提交。 1级增量备份全库：RMAN> backup incremental level 1 database plus archivelog;……省略备份过程细节。提示备份成功。可以再通过RMAN>list backup；查看已有备份确认（此时LV字段包含0和1，表示目前备份中已包含有0级和1级增量备份）。

Oracle SQL语句分析Explain PlanOracle RMAN的不完全恢复相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

本文评论查看全部评论（0）