内部新员工oracle培训标准手册-rman增量备份全过程-linux5.4-oracle11.2.docVIP

2011-05-06 ORACLE RMAN 增量备份完整恢复测试 创建测试表空间： 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 C