[20180412]手工拷贝文件到另外主机.txt

--//讨论链接:http://www.itpub.net/thread-2101193-1-1.html
--//自己测试是否可以拷贝成功.
--//理论讲很难实现,主库一个路径如何放到dataguard2个目录路径,我的观点仅仅保留一个.

1.环境:
SCOTT@book> @ ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

2.测试:
rlwrap rman target sys/oracle@book auxiliary sys/oracle@bookdg

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;

using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored

--//执行如下:
RMAN>

backup as copy reuse
datafile  5 auxiliary format "/tmp/example01.dbf" 
datafile  6 auxiliary format "/home/oracle/tea01.dbf"   ;

Starting backup at 2018-04-12 09:34:07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=67 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=80 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=94 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf
channel ORA_DISK_2: starting datafile copy
input datafile file number=00006 name=/mnt/ramdisk/book/tea01.dbf
output file name=/home/oracle/tea01.dbf tag=TAG20180412T093408
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:03
output file name=/tmp/example01.dbf tag=TAG20180412T093408
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
Finished backup at 2018-04-12 09:34:24

--//在备库检查:
# ls -l /tmp/example01.dbf /home/oracle/tea01.dbf
-rw-r-----  1 oracle oinstall  41951232 2018-04-12 09:34:10 /home/oracle/tea01.dbf
-rw-r-----  1 oracle oinstall 363077632 2018-04-12 09:34:14 /tmp/example01.dbf

--//可以发现文件已经拷贝过来.检查:
$ dbv file=/tmp/example01.dbf
DBVERIFY: Release 11.2.0.4.0 - Production on Thu Apr 12 09:35:49 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
DBVERIFY - Verification starting : FILE = /tmp/example01.dbf
DBVERIFY - Verification complete
Total Pages Examined         : 44320
Total Pages Processed (Data) : 6603
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 1149
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 2844
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 33724
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 392059041 (3.392059041)

--//在备库检查:
RMAN> list copy of database;
specification does not match any datafile copy in the repository

--//在备库控制文件没有记录.
--//补充我想到一个变通的方法:

我想到一种变通的方法,就是通过链接ln
在主库那边建立:
ln -s /oradata/orcl  /oradata/orcl2

这样备库db_file_name_convert参数可以写成:
'/oradata/orcl','/data1','/oradata/orcl2','/data2'

这样就不需要一一对应了.以后建立数据文件使用/oradata/orcl,就放在/data1,
而建立数据文件使用/oradata/orcl2,就放在/data2.