1

问题:

RMAN> backup as backupset copies 2 tablespace users;

Starting backup at 04-APR-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00004 name=/u01/app/oracle/oradata/prod1/users01.dbf

channel ORA_DISK_1: starting piece 1 at 04-APR-16

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/04/2016 11:09:18

ORA-19806: cannot make duplex backups in recovery area

2

原因：

ORA-19806: cannot make duplex backups in recovery area-----------------双重备份不能存储在快速恢复区中

3

解决办法：

双重备份user表空间，指定路径

RMAN> backup as backupset copies 2 tablespace users format '/home/oracle/ts_user_%U.dbf';

Starting backup at 04-APR-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00004 name=/u01/app/oracle/oradata/prod1/users01.dbf

channel ORA_DISK_1: starting piece 1 at 04-APR-16

channel ORA_DISK_1: finished piece 1 at 04-APR-16 with 2 copies and tag TAG20160404T111312

piece handle=/home/oracle/ts_user_1jr26de8_1_1.dbf comment=NONE

piece handle=/home/oracle/ts_user_1jr26de8_1_2.dbf comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 04-APR-16

Starting Control File and SPFILE Autobackup at 04-APR-16

piece handle=/u01/app/oracle/fast_recovery_area/PROD1/autobackup/2016_04_04/o1_mf_s_908275702_cj3py9hq_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 04-APR-16

4         

验证双重备份

[oracle@prod1 ~]$ pwd

/home/oracle

[oracle@prod1 ~]$ ll

total 3935292

-rw-r-----. 1 oracle oinstall      98304 Apr  4 10:52 cp_system_0dr26c7e_1_1

-rw-r-----. 1 oracle oinstall    9748480 Apr  4 10:52 cp_system_cf_D-PROD1_id-2128946428_0cr26c7d

-rw-r-----. 1 oracle oinstall  786440192 Apr  4 10:52 cp_system_data_D-PROD1_I-2128946428_TS-SYSTEM_FNO-1_0br26c76

drwxr-xr-x. 7 oracle oinstall       4096 Aug 27  2013 database

-rwxrw-rw-. 1 root   root     1395582860 Oct 19  2013 p13390677_112040_Linux-x86-64_1of7.zip

-rwxrw-rw-. 1 root   root     1151304589 Oct 19  2013 p13390677_112040_Linux-x86-64_2of7.zip

-rw-r-----. 1 oracle oinstall  669794304 Apr  4 10:50 ts_system_07r26c3o_1_1

-rw-r-----. 1 oracle oinstall    9830400 Apr  4 10:50 ts_system_08r26c47_1_1

-rw-r-----. 1 oracle oinstall    3457024 Apr  4 11:13 ts_user_1jr26de8_1_1.dbf

-rw-r-----. 1 oracle oinstall    3457024 Apr  4 11:13 ts_user_1jr26de8_1_2.dbf

5

小结：

双重备份只适用于备份集，不能用映像副本，也就是说映像副本会忽略backup  copies的永久设置

双重备份不能使用与快速恢复区，必须得指定路径；