rman复制数据库 - 墨天轮问答

主流小五

这是我的微信号码18753133056，很希望可以加一下，向您请教

有用 0

主流小五

下面这个是归档路径ip地址是231的为主库，237是备库

有用 0

张磊

这个不是 datafile 5不可以复制，你检查下 asm 里面的路径没有没有创建

有用 0

张磊

你的参数设置错误了

有用 0

JiekeXu

DB_FILE_NAME_CONVERT 有问题，如果主备库的数据文件目录结构一致，这两个参数可以不用配置。

如果不一致非要配置，写 db_unique_name 或者写数据文件相对路径即可。例如主库 RAC + ASM 备库单实例 + 文件系统。
主库参数： DB_FILE_NAME_CONVERT=‘std’,‘pri’
或者
DB_FILE_NAME_CONVERT=’/u01/app/oracle/oradata/std’,’+DATA/pri’
总之，要一一对应，一备一主模式，并不是所有数据文件目录都列出来，当然临时文件目录肯定是不需要的，主备库不会同步临时文件目录。

如还有问题，可加我微信 xxq1426321293

有用 0

张磊

alter system set db_file_name_convert =’+DATA/OA12CDB2’,’/u01’,’+FRA/OA12CDB2’,’/u01’ scope=spfile sid=’’;
alter system set log_file_name_convert=’+DATA/OA12CDB2’,’/u01’,’+FRA/OA12CDB2’,’/u01’ scope=spfile sid=’’;

两个实例的参数路径要求一致，你要复制的实例这个参数路径被你颠倒了

有用 0

主流小五

我备库的db_unique_name=dg，是不是我在映射路径的时候将这里GKPTTJ换成dg才可以

有用 0

周伟

你把问题在说清楚一点，从你的截图来看：restoring datafile 00005 to +DATA ;failed to create file +DATA, 似乎是你的备库是一个RAC，而主库是一个filesystem的？如果是这样的话，你的convert参数设置反了。convert参数的设置原则是，主库上面，convert的路径是备库在前，主库在后，备库上面，则是主库在前，备库灾后。

把你rman的连接命令也发出来看看。

有用 0

主流小五

rman target sys/123456@gkpttj auxiliary sys/123456@dg
登录成功后再主库端：
duplicate target database for standby from active database nofilenamecheck dorecover;

有用 0

周伟

那么根据你的日志来看，还是convert参数的问题，如果你的主库是ASM，备库的filesystem单实例的话，为什么复制的时候会报：restoring datafile 00005 to +DATA ;failed to create file +DATA ？这个现象在我看来，你是把数据库从备库复制到主库了，所以才要restore to +DATA (到ASM存储）。如果可以的话，你把整个rman的日志都传上来看一下。

有用 0

主流小五

RMAN> duplicate target database for standby from active database nofilenamecheck dorecover;

Starting Duplicate Db at 03-APR-20
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=355 device type=DISK
current log archived

contents of Memory Script:
{
backup as copy reuse
targetfile ‘+DATA/GKPTTJ/PASSWORD/pwdgkpttj.276.1036110745’ auxiliary format
‘/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwgkpttj’ ;
}
executing Memory Script

Starting backup at 03-APR-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=258 instance=gkpttj1 device type=DISK
Finished backup at 03-APR-20

contents of Memory Script:
{
sql clone “create spfile from memory”;
shutdown clone immediate;
startup clone nomount;
restore clone from service ‘gkpttj’ standby controlfile;
}
executing Memory Script

sql statement: create spfile from memory

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 1593835520 bytes

Fixed Size 2924880 bytes
Variable Size 1006636720 bytes
Database Buffers 570425344 bytes
Redo Buffers 13848576 bytes

Starting restore at 03-APR-20
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=357 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service gkpttj
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04
output file name=/u01/app/oracle/oradata/GKPTTJ/controlfile/o1_mf_h7vbstz2_.ctl
output file name=/u01/app/oracle/fast_recovery_area/GKPTTJ/controlfile/o1_mf_h7vbsv3d_.ctl
Finished restore at 03-APR-20

contents of Memory Script:
{
sql clone ‘alter database mount standby database’;
}
executing Memory Script

sql statement: alter database mount standby database
Using previous duplicated file /u01/app/oracle/oradata/GKPTTJ/system.279.1036110869 for datafile 1 with checkpoint SCN of 2785324
Using previous duplicated file /u01/app/oracle/oradata/GKPTTJ/sysaux.280.1036110825 for datafile 3 with checkpoint SCN of 2785559
Using previous duplicated file /u01/app/oracle/oradata/GKPTTJ/undotbs1.277.1036110915 for datafile 4 with checkpoint SCN of 2785821
RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.

contents of Memory Script:
{
set newname for tempfile 1 to
“/u01/app/oracle/oradata/GKPTTJ/temp.284.1036110993”;
set newname for tempfile 2 to
“+DATA/GKPTTJ/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/pdbseed_temp012020-03-27_12-37-21-am.dbf”;
set newname for tempfile 3 to
“+DATA”;
set newname for tempfile 4 to
“+DATA”;
set newname for tempfile 5 to
“+DATA”;
set newname for tempfile 6 to
“+DATA”;
set newname for tempfile 7 to
“+DATA”;
switch clone tempfile all;
set newname for datafile 1 to
“/u01/app/oracle/oradata/GKPTTJ/system.279.1036110869”;
set newname for datafile 3 to
“/u01/app/oracle/oradata/GKPTTJ/sysaux.280.1036110825”;
set newname for datafile 4 to
“/u01/app/oracle/oradata/GKPTTJ/undotbs1.277.1036110915”;
set newname for datafile 5 to
“+DATA”;
set newname for datafile 6 to
“/u01/app/oracle/oradata/GKPTTJ/users.278.1036110915”;
set newname for datafile 7 to
“+DATA”;
set newname for datafile 8 to
“/u01/app/oracle/oradata/GKPTTJ/undotbs2.288.1036111531”;
set newname for datafile 9 to
“+DATA”;
set newname for datafile 10 to
“+DATA”;
set newname for datafile 11 to
“+DATA”;
set newname for datafile 12 to
“+DATA”;
set newname for datafile 13 to
“+DATA”;
set newname for datafile 14 to
“+DATA”;
set newname for datafile 15 to
“+DATA”;
set newname for datafile 16 to
“+DATA”;
set newname for datafile 17 to
“+DATA”;
set newname for datafile 18 to
“+DATA”;
set newname for datafile 19 to
“+DATA”;
set newname for datafile 20 to
“+DATA”;
set newname for datafile 21 to
“+DATA”;
set newname for datafile 22 to
“+DATA”;
set newname for datafile 23 to
“+DATA”;
restore
from service ‘gkpttj’ clone datafile
5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23 ;
sql ‘alter system archive log current’;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/GKPTTJ/temp.284.1036110993 in control file
renamed tempfile 2 to +DATA/GKPTTJ/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/pdbseed_temp012020-03-27_12-37-21-am.dbf in control file
renamed tempfile 3 to +DATA in control file
renamed tempfile 4 to +DATA in control file
renamed tempfile 5 to +DATA in control file
renamed tempfile 6 to +DATA in control file
renamed tempfile 7 to +DATA in control file

executing command: SET NEWNAME

Starting restore at 03-APR-20
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service gkpttj
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to +DATA
dbms_backup_restore.restoreCancel() failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/03/2020 17:58:30
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-19660: some files in the backup set could not be verified
ORA-19661: datafile 5 could not be verified
ORA-19849: error while reading backup piece from service gkpttj
ORA-19504: failed to create file “+DATA”
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup “DATA” does not exist or is not mounted
ORA-29701: unable to connect to Cluster Synchronization Service

有用 0

主流小五

231是我的主库信息，237是备库信息

主库：

备库：

有用 0

主流小五

问题已关闭: 问题已经得到解决

有用 0