[oracle@Oracle_archive ~]$ mkdir -p /u01/app/oracle/admin/testhis_n/adump
[oracle@Oracle_archive ~]$ mkdir -p /u01/app/oracle/oradata/testhis_n/
[oracle@Oracle_archive ~]$ mkdir -p /u01/app/oracle/fast_recovery_area/testhis_n/
登入数据库创建spfile并启动实例
[oracle@Oracle_archive ~]$ echo $ORACLE_SID
testhisnew
[oracle@Oracle_archive ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Tue Jul 28 16:14:04 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile='/home/oracle/pfile.ora';
File created.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 3874926592 bytes
Fixed Size 2232368 bytes
Variable Size 2936016848 bytes
Database Buffers 922746880 bytes
Redo Buffers 13930496 bytes
源端登入两数据库，执行复制
[oracle@154-Oracle_Archive admin]$ rman target sys/******@testhis.154 auxiliary sys/******@testhis.11
Recovery Manager: Release 11.2.0.2.0 - Production on Tue Jul 28 17:46:30 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TESTHIS (DBID=1362777844)
connected to auxiliary database: TESTHISNE (not mounted)
RMAN> duplicate target database to testhisne from active database nofilenamecheck;
.
.
.
datafile 32 switched to datafile copy
input datafile copy RECID=31 STAMP=886273519 file name=/u01/app/oracle/oradata/testhisnew/test27.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=32 STAMP=886273519 file name=/u01/app/oracle/oradata/testhisnew/testdeltable01.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 28-JUL-15
.
复制完成后启动关闭目标库，验证是否复制成功，并观察alter日志是否有报错日志，确认无误后及时做全库备份。
--------------------------------------推荐阅读 --------------------------------------
--------------------------------------分割线 --------------------------------------