7.验证备份
RMAN> list backup of database
2> ;

using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 573.44M DISK 00:00:53 26-FEB-14
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20140226T035256
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_02_26/o1_mf_nnndf_TAG20140226T035256_9jvodwgh_.bkp
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 500685 26-FEB-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 500685 26-FEB-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
3 Full 500685 26-FEB-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
4 Full 500685 26-FEB-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 500685 26-FEB-14 /u01/app/oracle/oradata/orcl/example01.dbf
8.RMAN连接目标库和辅助实例，正式环境根据实际分配通道
[oracle@linux5 admin]$ rman target sys/oracle@orcl_local auxiliary sys/safe@orcl_dup

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 17 05:54:44 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1368292794)
connected to auxiliary database: ORCLDUP (not mounted)

RMAN> duplicate target database to orcldup
2> ;

Starting Duplicate Db at 17-APR-14
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=35 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/17/2014 05:57:23
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/orcl/redo03.log conflicts with a file used by the target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/orcl/redo02.log conflicts with a file used by the target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/orcl/redo01.log conflicts with a file used by the target database

RMAN> duplicate target database to orcldup //先要创建/u01/app/oracle/oradata/orcldup
2> logfile
3> '/u01/app/oracle/oradata/orcldup/redo01.log' size 20m,
4> '/u01/app/oracle/oradata/orcldup/redo02.log' size 20m,
5> '/u01/app/oracle/oradata/orcldup/redo03.log' size 20m
6> ;

Starting Duplicate Db at 17-APR-14
using channel ORA_AUX_DISK_1

contents of Memory Script:
{
set until scn 500750;
set newname for datafile 1 to
"/u01/dup_test/orcldup/system01.dbf";
set newname for datafile 2 to
"/u01/dup_test/orcldup/undotbs01.dbf";
set newname for datafile 3 to
"/u01/dup_test/orcldup/sysaux01.dbf";
set newname for datafile 4 to
"/u01/dup_test/orcldup/users01.dbf";
set newname for datafile 5 to
"/u01/dup_test/orcldup/example01.dbf";
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 17-APR-14
using channel ORA_AUX_DISK_1