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 reusedatafile 1 auxiliary format"/DBSoft/oracle/oradata/woo/system01.dbf" datafile2 auxiliary format"/DBSoft/oracle/oradata/woo/sysaux01.dbf" datafile3 auxiliary format"/DBSoft/oracle/oradata/woo/undotbs01.dbf" datafile4 auxiliary format"/DBSoft/oracle/oradata/woo/users01.dbf" ;sql 'alter system archive log current';}executing Memory Scriptsql statement: alter database flashback offexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEStarting backup at 03-JUN-15using channel ORA_DISK_1channel ORA_DISK_1: starting datafile copyinput datafile file number=00001 name=/DBSoft/oracle/oradata/woo/system01.dbfoutput file name=/DBSoft/oracle/oradata/woo/system01.dbf tag=TAG20150603T194019channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:47channel ORA_DISK_1: starting datafile copyinput datafile file number=00002 name=/DBSoft/oracle/oradata/woo/sysaux01.dbfoutput file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf tag=TAG20150603T194019channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:07channel ORA_DISK_1: starting datafile copyinput datafile file number=00003 name=/DBSoft/oracle/oradata/woo/undotbs01.dbfoutput file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf tag=TAG20150603T194019channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15channel ORA_DISK_1: starting datafile copyinput datafile file number=00004 name=/DBSoft/oracle/oradata/woo/users01.dbfoutput file name=/DBSoft/oracle/oradata/woo/users01.dbf tag=TAG20150603T194019channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03Finished backup at 03-JUN-15sd
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/25199068/viewspace-2123242/ ,如需转载,请注明出处,否则将追究法律责任。