Bo's Oracle Station

查看: 2190|回复: 0

课程第39/40次:2016-06-24星期五,2016-06-27星期一

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2016-6-25 12:11:19 | 显示全部楼层 |阅读模式
本帖最后由 botang 于 2016-6-28 23:41 编辑

2016-06-24:
【上完1Z0-053的第20章】:克隆数据库
【1Z0-051】:共10章(0 1 2 3 4 5 6 7 8 9)
【1Z0-052】:共12章(0 1 2 3 4 5 6 9 10 14 15 16)
【1Z0-053】:共12章(0 1 2 3 4 5 6 7 10 11 12 20)

2016-06-27:
跨平台迁移,网格基础架构升级,4K存储和传送表空间
视频】网格基础架构升级:https://www.botangdb.com/mytec/mytec_basicadmin/201606/00900022.html
视频传送表空间视频:https://www.botangdb.com/mytec/mytec_implementdw/201606/00900023.html


pengbo.rcv:
  1. run {
  2. duplicate target database to pengbo
  3. from active database
  4. nofilenamecheck
  5. spfile
  6. set
  7. control_files='+DATA','+FRA'
  8. set
  9. db_file_name_convert='+DATA/orcl/','+DATA/pengbo'
  10. set
  11. log_file_name_convert='+DATA/orcl','+DATA/pengbo','+FRA/orcl','+FRA/pengbo'
  12. set
  13. audit_file_dest='/u01/app/oracle/admin/pengbo/adump';
  14. }
复制代码

orclbackup.rcv:
  1. run {
  2. allocate channel  c1 device type disk format '/home/oracle/backup/%U';
  3. allocate channel  c2 device type disk format '/home/oracle/backup/%U';
  4. allocate channel  c3 device type disk format '/home/oracle/backup/%U';
  5. allocate channel  c4 device type disk format '/home/oracle/backup/%U';
  6. allocate channel  c5 device type disk format '/home/oracle/backup/%U';
  7. allocate channel  c6 device type disk format '/home/oracle/backup/%U';
  8. allocate channel  c7 device type disk format '/home/oracle/backup/%U';
  9. allocate channel  c8 device type disk format '/home/oracle/backup/%U';
  10. backup database plus archivelog force;
  11. backup spfile;
  12. backup current controlfile;
  13. }
复制代码

mydb.rcv:
  1. run{
  2. duplicate target database to mydb
  3. backup location '/home/oracle/backup2'
  4. nofilenamecheck
  5. spfile
  6. set
  7. control_files='/u01/app/oracle/oradata/mydb/control01.ctl','/u01/app/oracle/oradata/mydb/control02.ctl','/u01/app/oracle/oradata/mydb/control03.ctl'
  8. set
  9. db_file_name_convert='+DATA/orcl/datafile/example.265.816169651','/u01/app/oracle/oradata/mydb/example01.dbf','+DATA/orcl/datafile/users.259.816169553','/u01/app/oracle/oradata/mydb/users01.dbf','+DATA/orcl/datafile/undotbs1.258.816169553','/u01/app/oracle/oradata/mydb/undotbs01.dbf','+DATA/orcl/datafile/sysaux.257.816169553','/u01/app/oracle/oradata/mydb/sysaux01.dbf','+DATA/orcl/datafile/system.256.816169553','/u01/app/oracle/oradata/mydb/system01.dbf'
  10. set
  11. log_file_name_convert='+DATA/orcl/onlinelog/group_1.261.816169635','/u01/app/oracle/oradata/mydb/redo01a.log','+FRA/orcl/onlinelog/group_1.257.816169637','/u01/app/oracle/oradata/mydb/redo01b.log','+DATA/orcl/onlinelog/group_3.263.816169641','/u01/app/oracle/oradata/mydb/redo03a.log','+FRA/orcl/onlinelog/group_3.259.816169641','/u01/app/oracle/oradata/mydb/redo03b.log','+DATA/orcl/onlinelog/group_2.262.816169639','/u01/app/oracle/oradata/mydb/redo02a.log','+FRA/orcl/onlinelog/group_2.258.816169639','/u01/app/oracle/oradata/mydb/redo02b.log'
  12. set
  13. audit_file_dest='/u01/app/oracle/admin/mydb/adump'
  14. set
  15. db_create_file_dest=''
  16. set
  17. db_recovery_file_dest='/u01/app/oracle/flash_recovery_area';
  18. }
复制代码



回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-12-5 10:20 , Processed in 0.041662 second(s), 24 queries .

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