ITPub博客

首页 > 数据库 > Oracle > ceshi 3

ceshi 3

Oracle 作者:wrx0815 时间:2016-08-09 23:42:19 0 删除 编辑
wo jiushi ceshiyixa
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  
  
  

sd

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/25199068/viewspace-2123242/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: ceshi
下一篇: 测试4了啊
请登录后发表评论 登录
全部评论

注册时间:2011-04-11

  • 博文量
    3
  • 访问量
    7067