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

botang

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. }

复制代码