Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1974878
  • 博文数量: 346
  • 博客积分: 10221
  • 博客等级: 上将
  • 技术积分: 4079
  • 用 户 组: 普通用户
  • 注册时间: 2009-06-01 19:43
文章分类

全部博文(346)

文章存档

2012年(1)

2011年(102)

2010年(116)

2009年(127)

我的朋友

分类: Oracle

2011-06-07 15:54:23

 resotre control file
restore controlfile from  '/oraclebak/statbk/data/ctl_223_1_728030888'

-- rman script.
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
set newname for datafile  1 to '+DG1/';
set newname for datafile  2 to '+DG1/';
set newname for datafile  3 to '+DG1/';
set newname for datafile  4 to '+DG1/';
set newname for datafile  5 to '+DG1/';
set newname for datafile  6 to '+DG1/';
set newname for datafile  7 to '+DG1/';
set newname for datafile  8 to '+DG1/';
set newname for datafile  9 to '+DG1/';
set newname for datafile 10 to '+DG1/';
set newname for datafile 11 to '+DG1/';
set newname for datafile 12 to '+DG1/';
set newname for datafile 13 to '+DG1/';
set newname for datafile 14 to '+DG1/';
set newname for datafile 15 to '+DG1/';
set newname for datafile 16 to '+DG1/';
set newname for datafile 20 to '+DG1/';
set newname for datafile 21 to '+DG1/';
set newname for datafile 22 to '+DG1/';
set newname for datafile 23 to '+DG1/';
set newname for datafile 24 to '+DG1/';
set newname for datafile 25 to '+DG1/';
set newname for datafile 26 to '+DG1/';
set newname for datafile 27 to '+DG1/';
set newname for datafile 28 to '+DG1/';
set newname for datafile 29 to '+DG1/';
set newname for datafile 30 to '+DG1/';
set newname for datafile 31 to '+DG1/';
set newname for datafile 32 to '+DG1/';
set newname for datafile 35 to '+DG1/';
set newname for datafile 36 to '+DG1/';
set newname for datafile 37 to '+DG1/';
set newname for datafile 38 to '+DG1/';
set newname for datafile 48 to '+DG1/';
set newname for datafile 49 to '+DG1/';
set newname for datafile 50 to '+DG1/';
set newname for datafile 51 to '+DG1/';
set newname for datafile 52 to '+DG1/';
set newname for datafile 53 to '+DG1/';
set newname for datafile 54 to '+DG1/';
set newname for datafile 55 to '+DG1/';
set newname for datafile 56 to '+DG1/';
set newname for datafile 57 to '+DG1/';
set newname for datafile 58 to '+DG1/';
set newname for datafile 59 to '+DG1/';
set newname for datafile 60 to '+DG1/';
set newname for datafile 61 to '+DG1/';
set newname for datafile 62 to '+DG1/';
set newname for datafile 63 to '+DG1/';
set newname for datafile 64 to '+DG1/';
set newname for datafile 65 to '+DG1/';
set newname for datafile 66 to '+DG1/';
set newname for datafile 67 to '+DG1/';
set newname for datafile 68 to '+DG1/';
set newname for datafile 69 to '+DG1/';
set newname for datafile 70 to '+DG1/';
set newname for datafile 71 to '+DG1/';
set newname for datafile 72 to '+DG1/';
set newname for datafile 73 to '+DG1/';
set newname for datafile 74 to '+DG1/';
set newname for datafile 75 to '+DG1/';
set newname for datafile 76 to '+DG1/';
set newname for datafile 77 to '+DG1/';
set newname for datafile 78 to '+DG1/';
set newname for datafile 79 to '+DG1/';
set newname for datafile 80 to '+DG1/';
set newname for datafile 81 to '+DG1/';
set newname for datafile 82 to '+DG1/';
set newname for datafile 83 to '+DG1/';
set newname for datafile 84 to '+DG1/';
set newname for datafile 85 to '+DG1/';
set newname for datafile 86 to '+DG1/';
set newname for datafile 87 to '+DG1/';
set newname for datafile 88 to '+DG1/';
set newname for datafile 89 to '+DG1/';
set newname for datafile 90 to '+DG1/';
set newname for datafile 91 to '+DG1/';
set newname for datafile 92 to '+DG1/';
set newname for datafile 93 to '+DG1/';
set newname for datafile 94 to '+DG1/';
set newname for datafile 95 to '+DG1/';
set newname for datafile 96 to '+DG1/';
restore database;
switch datafile all;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
阅读(1675) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~