Rman功能测试 - 备份恢复

n 1：设置备份的并行度，使多个cpu同时工作，提高备份速度。

n 2、搞明白expired

n 3、搞明白obsolete

1、设置备份的并行度，使多个cpu同时工作，提高备份速度。

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/porduct/9.2.0/dbs/snapcf_test.f'; # default

配置了并行度为4，也就是默认开4个通道进行备份，这在多cpu的情况下可以提高备份速度。

测试一下：

Recovery Manager: Release 9.2.0.4.0 - Production

RMAN> connect target /
2> run{
3> copy
4> datafile 4 to '/share/4.dbf',
5> datafile 5 to '/share/5.dbf',
6> datafile 6 to '/share/6.dbf',
7> datafile 7 to '/share/7.dbf';
8> }
9>
connected to target database: TEST (DBID=1862890406)

Starting copy at 16-SEP-05
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=16 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=17 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=18 devtype=DISK
channel ORA_DISK_2: copied datafile 5
output filename=/share/5.dbf recid=1 stamp=569158719
channel ORA_DISK_1: copied datafile 4
output filename=/share/4.dbf recid=3 stamp=569158740
channel ORA_DISK_3: copied datafile 6
output filename=/share/6.dbf recid=2 stamp=569158737
channel ORA_DISK_4: copied datafile 7
output filename=/share/7.dbf recid=4 stamp=569158755
Finished copy at 16-SEP-05

Starting Control File and SPFILE Autobackup at 16-SEP-05
piece handle=/u01/oracle/porduct/9.2.0/dbs/c-1862890406-20050916-01 comment=NONE
Finished Control File and SPFILE Autobackup at 16-SEP-05

Recovery Manager complete.

确实是开了4个通道，而且每个文件的备份都占用了一个通道，可惜只有1个cpu，要是多个cpu，速度就应该能提高了。

改成2个并行度试试，

RMAN> configure device type disk parallelism 2;

old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
new RMAN configuration parameters are successfully stored

Recovery Manager: Release 9.2.0.4.0 - Production

RMAN> connect target /
2> run{
3> copy
4> datafile 4 to '/share/4.dbf',