Oracle 11gR2使用RMAN duplicate from active database复制数据库(四)
CL2'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 637537872 bytes
Database Buffers 205520896 bytes
Redo Buffers 5132288 bytes
allocated channel: stby1
channel stby1: SID=19 device type=DISK
Starting backup at 21-OCT-13
channel prmy1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl2.f tag=TAG20131021T213753 RECID=4 STAMP=829431485
channel prmy1: datafile copy complete, elapsed time: 00:00:25
Finished backup at 21-OCT-13
Starting restore at 21-OCT-13
channel stby1: copied control file copy
Finished restore at 21-OCT-13
database mounted
RMAN-05538: WARNING: implicitly using DB_FILE_NAME_CONVERT
contents of Memory Script:
{
set newname for datafile 1 to
"/oradata/orcl2/datafilessystem01.dbf";
set newname for datafile 2 to
"/oradata/orcl2/datafilessysaux01.dbf";
set newname for datafile 3 to
"/oradata/orcl2/datafilesundotbs01.dbf";
set newname for datafile 4 to
"/oradata/orcl2/datafilesusers01.dbf";
set newname for datafile 5 to
"/oradata/orcl2/datafilesexample01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/oradata/orcl2/datafilessystem01.dbf" datafile
2 auxiliary format
"/oradata/orcl2/datafilessysaux01.dbf" datafile
3 auxiliary format
"/oradata/orcl2/datafilesundotbs01.dbf" datafile
4 auxiliary format
"/oradata/orcl2/datafilesusers01.dbf" datafile
5 auxiliary forma
t
"/oradata/orcl2/datafilesexample01.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 21-OCT-13
channel prmy1: starting datafile copy
input datafile file number=00001 name=/oradata/orcl2/datafilessystem01.dbf
channel prmy2: starting datafile copy
input datafile file number=00002 name=/oradata/orcl2/datafilessysaux01.dbf
channel prmy3: starting datafile copy
input datafile file number=00005 name=/oradata/orcl2/datafilesexample01.dbf
output file name=/oradata/orcl2/datafilesexample01.dbf tag=TAG20131021T213825
channel prmy3: datafile copy complete, elapsed time: 00:00:26
channel prmy3: starting datafile copy
input datafile file number=00003 name=/oradata/orcl2/datafilesundotbs01.dbf
output file name=/oradata/orcl2/datafilessysaux01.dbf tag=TAG20131021T213825
channel prmy2: datafile copy complete, elapsed time: 00:01:03
channel prmy2: starting datafile copy
input datafile file number=00004 name=/oradata/orcl2/datafilesusers01.dbf
output file name=/oradata/orcl2/datafilesundotbs01.dbf tag=TAG20131021T213825
channel prmy3: datafile copy complete, elapsed time: 00:00:37
output file name=/oradata/orcl2/datafilesusers01.dbf tag=TAG20131021T213825
channel prmy2: datafile copy complete, elapsed time: 00:00:15
output file name=/oradata/orcl2/datafilessystem01.dbf tag=TAG20131021T213825
channel prmy1: datafile copy complete, elapsed time: 00:01:49
Finished backup at 21-OCT-13
sql statement: alter system archive log current
contents of Me