rman_backup as copy_copy datafile

查看数据文件

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/oracle10g/oradata/first/system01.dbf

/oracle10g/oradata/first/undotbs01.dbf

/oracle10g/oradata/first/sysaux01.dbf

/oracle10g/oradata/first/users01.dbf

/oracle10g/oradata/first/undotbs01_secondnewly.dbf

/oracle10g/oradata/first/tbs_test.dbf

6 rows selected.

查看表空间

SQL> select name from v$tablespace;

NAME

------------------------------

SYSTEM

UNDOTBS1

SYSAUX

USERS

TEMP

TBS_TEST

6 rows selected.

---镜像备份数据库所有表空间的数据文件

backup as copy db_file_name_convert=('/oracle10g/oradata/first','/oracle10g/oradata/second')

tablespace system,undotbs1,sysaux,users,temp,tbs_test

--临时表空间不能使用rman copy进行拷贝

RMAN> backup as copy db_file_name_convert=('/oracle10g/oradata/first','/oracle10g/oradata/second')

2> tablespace system,undotbs1,sysaux,users,temp,tbs_test;

Starting backup at 12-JUL-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=142 devtype=DISK

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

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

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

RMAN-03002: failure of backup command at 07/12/2013 15:00:41

RMAN-20202: tablespace not found in the recovery catalog

RMAN-06019: could not translate tablespace name "TEMP"

---移除临时表空间

backup as copy db_file_name_convert=('/oracle10g/oradata/first','/oracle10g/oradata/second')

tablespace system,undotbs1,sysaux,users,tbs_test

RMAN> backup as copy db_file_name_convert=('/oracle10g/oradata/first','/oracle10g/oradata/second')

2> tablespace system,undotbs1,sysaux,users,tbs_test;

Starting backup at 12-JUL-13

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile fno=00003 name=/oracle10g/oradata/first/sysaux01.dbf

output filename=/oracle10g/oradata/second/sysaux01.dbf tag=TAG20130712T150125 recid=18 stamp=820594915

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35

channel ORA_DISK_1: starting datafile copy

input datafile fno=00001 name=/oracle10g/oradata/first/system01.dbf

output filename=/oracle10g/oradata/second/system01.dbf tag=TAG20130712T150125 recid=19 stamp=820594958

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45

channel ORA_DISK_1: starting datafile copy

input datafile fno=00002 name=/oracle10g/oradata/first/undotbs01.dbf

output filename=/oracle10g/oradata/second/undotbs01.dbf tag=TAG20130712T150125 recid=20 stamp=820594976

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15

channel ORA_DISK_1: starting datafile copy

input datafile fno=00006 name=/oracle10g/oradata/first/tbs_test.dbf

output filename=/oracle10g/oradata/second/tbs_test.dbf tag=TAG20130712T150125 recid=21 stamp=820594987

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07

channel ORA_DISK_1: starting datafile copy

input datafile fno=00005 name=/oracle10g/oradata/first/undotbs01_secondnewly.dbf

output filename=/oracle10g/oradata/second/undotbs01_secondnewly.dbf tag=TAG20130712T150125 recid=22 stamp=820594989

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting datafile copy

input datafile fno=00004 name=/oracle10g/oradata/first/users01.dbf

output filename=/oracle10g/oradata/second/users01.dbf tag=TAG20130712T150125 recid=23 stamp=820594994

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting datafile copy

copying current control file

output filename=/oracle10g/flash_recovery_area/FIRST/controlfile/o1_mf_TAG20130712T150125_8xzbkm2s_.ctl tag=TAG20130712T150125 recid=24 stamp=820594995

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current SPFILE in backupset

channel ORA_DISK_1: starting piece 1 at 12-JUL-13

channel ORA_DISK_1: finished piece 1 at 12-JUL-13

piece handle=/oracle10g/flash_recovery_area/FIRST/backupset/2013_07_12/o1_mf_nnsnf_TAG20130712T150125_8xzbkp76_.bkp tag=TAG20130712T150125 comment=NONE

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

Finished backup at 12-JUL-13

小结：1，如果数据文件路径基本一致，可采用此db_file_name_convert参数，减少rman脚本的代码量

            2,backup as copy datafile与copy data datafile基本相同，但测试发现前者会自动备份控制文件与spfile

            3,copy只能指定datafile,而backup as copy即可指定datafile也可指定tablespace

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-766143/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-766143/