Bo's Oracle Station

查看: 2895|回复: 0

第51次-55次 2015-05-23上午下午 星期六, 2015-05-26星期二

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2015-5-25 09:08:31 | 显示全部楼层 |阅读模式
本帖最后由 botang 于 2015-5-29 09:36 编辑

第51次:2015-05-19 星期二
第52次:2015-05-21星期四
第53-54次:2015-05-23上午下午 星期六
第55次:2015-05-26星期二
目的地传送表空间
http://124.16.180.178:8080/bigendian.tgz
64位-32位
  1. RMAN> run {
  2. 2> allocate channel  c1 device type disk format '/home/oracle/backup/%U';
  3. 3> allocate channel  c2 device type disk format '/home/oracle/backup/%U';
  4. 4> allocate channel  c3 device type disk format '/home/oracle/backup/%U';
  5. 5> allocate channel  c4 device type disk format '/home/oracle/backup/%U';
  6. 6> allocate channel  c5 device type disk format '/home/oracle/backup/%U';
  7. 7> backup database plus archivelog  force;
  8. 8> backup spfile;
  9. 9> backup current controlfile;
复制代码
dup.rcv32
  1. run{
  2. duplicate target database to db11g
  3. from active database
  4. nofilenamecheck
  5. spfile
  6. set control_files='/u01/app/oracle/oradata/db11g/control01.ctl','/u01/app/oracle/oradata/db11g/control02.ctl','/u01/app/oracle/oradata/db11g/control03.ctl'
  7. set db_file_name_convert='+DATA/orcl/datafile/example.265.832197353','/u01/app/oracle/oradata/db11g/example01.dbf','+DATA/orcl/datafile/users.259.832197065','/u01/app/oracle/oradata/db11g/users01.dbf','+DATA/orcl/datafile/undotbs1.258.832197065','/u01/app/oracle/oradata/db11g/undotbs01.dbf','+DATA/orcl/datafile/sysaux.257.832197065','/u01/app/oracle/oradata/db11g/sysaux01.dbf','+DATA/orcl/datafile/system.256.832197063','/u01/app/oracle/oradata/db11g/system01.dbf'
  8. set log_file_name_convert='+DATA/orcl/onlinelog/group_1.261.832197287','/u01/app/oracle/oradata/db11g/redo01a.log','+FRA/orcl/onlinelog/group_1.257.832197291','/u01/app/oracle/oradata/db11g/redo01b.log','+DATA/orcl/onlinelog/group_3.263.832197301','/u01/app/oracle/oradata/db11g/redo03a.log','+FRA/orcl/onlinelog/group_3.259.832197305','/u01/app/oracle/oradata/db11g/redo03b.log','+DATA/orcl/onlinelog/group_2.262.832197293','/u01/app/oracle/oradata/db11g/redo02a.log','+FRA/orcl/onlinelog/group_2.258.832197299','/u01/app/oracle/oradata/db11g/redo02b.log';
  9. }
复制代码

dup.rcv64
  1. run{
  2. allocate  auxiliary channel c1 device type disk;
  3. allocate  auxiliary channel c2 device type disk;
  4. allocate  auxiliary channel c3 device type disk;
  5. allocate  auxiliary channel c4 device type disk;
  6. allocate  auxiliary channel c5 device type disk;
  7. duplicate target database to db11g
  8. backup location '/home/oracle/backup'
  9. nofilenamecheck
  10. spfile
  11. set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
  12. set control_files='/u01/app/oracle/oradata/db11g/control01.ctl','/u01/app/oracle/oradata/db11g/control02.ctl','/u01/app/oracle/oradata/db11g/control03.ctl'
  13. set db_file_name_convert='+DATA/orcl/datafile/example.258.880451611','/u01/app/oracle/oradata/db11g/example01.dbf','+DATA/orcl/datafile/users.259.880451615','/u01/app/oracle/oradata/db11g/users01.dbf','+DATA/orcl/datafile/undotbs1.256.880451607','/u01/app/oracle/oradata/db11g/undotbs01.dbf','+DATA/orcl/datafile/sysaux.257.880451605','/u01/app/oracle/oradata/db11g/sysaux01.dbf','+DATA/orcl/datafile/system.265.880451605','/u01/app/oracle/oradata/db11g/system01.dbf'
  14. set log_file_name_convert='+DATA/orcl/onlinelog/group_1.270.880453135','/u01/app/oracle/oradata/db11g/redo01a.log','+FRA/orcl/onlinelog/group_1.276.880453137','/u01/app/oracle/oradata/db11g/redo01b.log','+DATA/orcl/onlinelog/group_3.272.880453141','/u01/app/oracle/oradata/db11g/redo03a.log','+FRA/orcl/onlinelog/group_3.274.880453141','/u01/app/oracle/oradata/db11g/redo03b.log','+DATA/orcl/onlinelog/group_2.271.880453137','/u01/app/oracle/oradata/db11g/redo02a.log','+FRA/orcl/onlinelog/group_2.275.880453139','/u01/app/oracle/oradata/db11g/redo02b.log';
  15. }
复制代码




回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 22:31 , Processed in 0.040341 second(s), 24 queries .

快速回复 返回顶部 返回列表