Oracle instance shut down
Oracle instance started
Total System Global Area? ? 954155008 bytes
Fixed Size? ? ? ? ? ? ? ? ? ? 1368632 bytes
Variable Size? ? ? ? ? ? ? ? 306187720 bytes
Database Buffers? ? ? ? ? ? 641728512 bytes
Redo Buffers? ? ? ? ? ? ? ? ? 4870144 bytes
Starting backup at 03-JUN-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=43 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/DBSoft/oracle/product/11.2.4/dbhome_1/dbs/snapcf_woo.f tag=TAG20150603T194000 RECID=3 STAMP=881437202
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:08
Finished backup at 03-JUN-15
Starting restore at 03-JUN-15
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 03-JUN-15
database mounted
contents of Memory Script:
{
? sql clone 'alter database flashback off';
? set newname for datafile? 1 to
?"/DBSoft/oracle/oradata/woo/system01.dbf";
? set newname for datafile? 2 to
?"/DBSoft/oracle/oradata/woo/sysaux01.dbf";
? set newname for datafile? 3 to
?"/DBSoft/oracle/oradata/woo/undotbs01.dbf";
? set newname for datafile? 4 to
?"/DBSoft/oracle/oradata/woo/users01.dbf";
? backup as copy reuse
? datafile? 1 auxiliary format
?"/DBSoft/oracle/oradata/woo/system01.dbf"? datafile
?2 auxiliary format
?"/DBSoft/oracle/oradata/woo/sysaux01.dbf"? datafile
?3 auxiliary format
?"/DBSoft/oracle/oradata/woo/undotbs01.dbf"? datafile
?4 auxiliary format
?"/DBSoft/oracle/oradata/woo/users01.dbf"? ;
? sql 'alter system archive log current';
}
executing Memory Script
sql statement: alter database flashback off
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 03-JUN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/DBSoft/oracle/oradata/woo/system01.dbf
output file name=/DBSoft/oracle/oradata/woo/system01.dbf tag=TAG20150603T194019
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:47
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/DBSoft/oracle/oradata/woo/sysaux01.dbf
output file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf tag=TAG20150603T194019
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/DBSoft/oracle/oradata/woo/undotbs01.dbf
output file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf tag=TAG20150603T194019
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/DBSoft/oracle/oradata/woo/users01.dbf
output file name=/DBSoft/oracle/oradata/woo/users01.dbf tag=TAG20150603T194019
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 03-JUN-15
sql statement: alter system archive log current
contents of Memory Script:
{
? backup as copy reuse
? archivelog like? "/DBArchive/archive/1_63_878860684.dbf" auxiliary format
?"/DBArchive2/archive/1_63_878860684.dbf"? ;
? catalog clone archivelog? "/DBArchive2/archive/1_63_878860684.dbf";
? switch clone datafile all;
}
executing Memory Script
S