RMAN异机duplicate复制数据库(三)
ice type=DISK
allocated channel: a4
channel a4: SID=21 device type=DISK
Starting restore at 22-OCT-13
channel a2: starting datafile backup set restore
channel a2: restoring control file
channel a2: reading from backup piece /orabackup/ctl_22_37_1_20131022
channel a2: piece handle=/orabackup/ctl_22_37_1_20131022 tag=TAG20131022T140831
channel a2: restored backup piece 1
channel a2: restore complete, elapsed time: 00:00:03
output file name=/oradata/orcl2/datafiles/control01.ctl
output file name=/oradata/orcl2/datafiles/control02.ctl
Finished restore at 22-OCT-13
database mounted
contents of Memory Script:
{
set until scn 883198;
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";
restore
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 22-OCT-13
channel a2: starting datafile backup set restore
channel a2: specifying datafile(s) to restore from backup set
channel a2: restoring datafile 00001 to /oradata/orcl2/datafilessystem01.dbf
channel a2: restoring datafile 00004 to /oradata/orcl2/datafilesusers01.dbf
channel a2: reading from backup piece /orabackup/full_22_33_1_20131022
channel a3: starting datafile backup set restore
channel a3: specifying datafile(s) to restore from backup set
channel a3: restoring datafile 00002 to /oradata/orcl2/datafilessysaux01.dbf
channel a3: restoring datafile 00003 to /oradata/orcl2/datafilesundotbs01.dbf
channel a3: restoring datafile 00005 to /oradata/orcl2/datafilesexample01.dbf
channel a3: reading from backup piece /orabackup/full_22_34_1_20131022
channel a3: piece handle=/orabackup/full_22_34_1_20131022 tag=TAG20131022T140657
channel a3: restored backup piece 1
channel a3: restore complete, elapsed time: 00:01:09
channel a2: piece handle=/orabackup/full_22_33_1_20131022 tag=TAG20131022T140657
channel a2: restored backup piece 1
channel a2: restore complete, elapsed time: 00:01:21
Finished restore at 22-OCT-13
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=5 STAMP=829493590 file name=/oradata/orcl2/datafilessystem01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=829493590 file name=/oradata/orcl2/datafilessysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=829493590 file name=/oradata/orcl2/datafilesundotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=829493590 file name=/oradata/orcl2/datafilesusers01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=9 STAMP=829493590 file name=/o