ORACLE RMAN增量備份完整恢復測試
1.創建測試環境：
1.1.創建測試表空間
SQL> create tablespace tablespace1 datafile ‘/data/u01/app/oracle/oradata/orcl/tablespace1.dbf’ size 10m;
SQL>
1.2.創建測試用戶并指定為默認表空間：
SQL> create user user1 identified by oracle default tablespace tablespace1;
SQL>
1.3.設置該測試用戶權限：
SQL> grant create session,create table,unlimited tablespace to user1;
Grant succeeded.
SQL>
1.4.用新創建的用戶登錄：
SQL> conn user1/
Enter password:
Connected.
SQL>
1.5.建表并寫入數據：
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.
2.配置RMAN環境變量
登錄rman
rman target/
切換sys用戶作0級備份：
利用configure命令配置RMAN環境:
#開啟歸檔日志自動備份
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
#指定歸檔日志備份位置
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/data/u01/bak/ctf/%d_ctf_bak_%F’;
#采用并行度為2且壓縮備份集的方式備份到磁盤
RMAN>CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
RMAN>CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT’/data/u01/bak/disk1/%d_datafile_bak_%U’;
RMAN>CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT’/data/u01/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
