今天重新做了一次rman duplicate操作

[oracle@ora02 ~]$ rman target / auxiliary sys/oracle@PROD


Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jan 11 15:32:10 2016


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


connected to target database: ORCL (DBID=1427785672)

connected to auxiliary database: PROD (not mounted)


RMAN> DUPLICATE TARGET DATABASE TO PROD FROM ACTIVE DATABASE

2> spfile PARAMETER_VALUE_CONVERT 'ORCL','PROD'

3> set CONTROL_FILES='/u01/app/oracle/oradata/PROD/control01.ctl','/u01/app/oracle/fast_recovery_area/PROD/control02.ctl'

4> set DB_FILE_NAME_CONVERT='ORCL','PROD'

5> set LOG_FILE_NAME_CONVERT='ORCL','PROD';

执行最后报错

Oracle instance shut down

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

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

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

RMAN-03002: failure of Duplicate Db command at 01/11/2016 15:33:46

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/11/2016 15:33:37

ORA-17628: Oracle error 19505 returned by remote Oracle server


查看备库的时候，发现在备库，参数文件和控制文件都已经复制过去了。这时检查备库，发现备库的实例处于关闭状态。手动启动备库的实例，报错，参数文件和控制文件中的db_name不一致，可以断定，rman修改控制文件的这一步就没完成。

该创建的目录应该都创建了呀！oracle网络通的，静态监听处于启动状态，要不然文件也复制不过来呀！主库的归档也开了，并且最起码有一个归档。检查一下各种文件吧！

RMAN> report schema;


Report of database schema for database with db_unique_name ORCL


List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

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

1    740      SYSTEM               ***     /u02/app/oracle/oradata/ORCL/system01.dbf

2    520      SYSAUX               ***     /u02/app/oracle/oradata/ORCL/sysaux01.dbf

3    70       UNDOTBS1             ***     /u02/app/oracle/oradata/ORCL/undotbs01.dbf

4    5        USERS                ***     /u02/app/oracle/oradata/ORCL/users01.dbf


List of Temporary Files

=======================

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

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

1    20       TEMP                 32767       /u01/app/oracle/oradata/ORCL/temp01.dbf


然后就发现了问题，怎么数据文件没有在它通常的位置？突然想起，前几天还做了一些改路径的操作。再回头看rman报出的日志

Starting backup at 2016-01-11 15:33:33

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=/u02/app/oracle/oradata/ORCL/system01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/11/2016 15:33:34

ORA-17628: Oracle error 19505 returned by remote Oracle server

continuing other job steps, job failed will not be re-run

channel ORA_DISK_1: starting datafile copy

input datafile file number=00002 name=/u02/app/oracle/oradata/ORCL/sysaux01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/11/2016 15:33:35

ORA-17628: Oracle error 19505 returned by remote Oracle server

continuing other job steps, job failed will not be re-run

channel ORA_DISK_1: starting datafile copy

input datafile file number=00003 name=/u02/app/oracle/oradata/O