Oracle 11gR2使用RMAN duplicate from active database复制数据库(三)
REUSE,
GROUP 2 ( '/oradata/orcl2/datafiles/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/oradata/orcl2/datafiles/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/oradata/orcl2/datafilessystem01.dbf'
CHARACTER SET ZHS16GBK
contents of Memory Script:
{
set newname for tempfile 1 to
"/oradata/orcl2/datafilestemp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/oradata/orcl2/datafilessysaux01.dbf",
"/oradata/orcl2/datafilesundotbs01.dbf",
"/oradata/orcl2/datafilesusers01.dbf",
"/oradata/orcl2/datafilesexample01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /oradata/orcl2/datafilestemp01.dbf in control file
cataloged datafile copy
datafile copy file name=/oradata/orcl2/datafilessysaux01.dbf RECID=1 STAMP=829430181
cataloged datafile copy
datafile copy file name=/oradata/orcl2/datafilesundotbs01.dbf RECID=2 STAMP=829430181
cataloged datafile copy
datafile copy file name=/oradata/orcl2/datafilesusers01.dbf RECID=3 STAMP=829430181
cataloged datafile copy
datafile copy file name=/oradata/orcl2/datafilesexample01.dbf RECID=4 STAMP=829430181
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=829430181 file name=/oradata/orcl2/datafilessysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=829430181 file name=/oradata/orcl2/datafilesundotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=829430181 file name=/oradata/orcl2/datafilesusers01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=829430181 file name=/oradata/orcl2/datafilesexample01.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 21-OCT-13
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: stby1