第32次：2015-07-23 星期四

admin

上完1Z0-053第20章        （52-19）
dup1.rcv

1. run {
   
2. duplicate target database
   
3. to aux
   
4. from active database
   
5. nofilenamecheck
   
6. spfile
   
7. set
   
8. control_files='+data','+fra';
   
9. }

复制代码

dup2.rcv

1. run{
   
2. duplicate target database to pengbo
   
3. from active database
   
4. nofilenamecheck
   
5. spfile
   
6. set
   
7. db_create_file_dest=''
   
8. set
   
9. db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
   
10. set
    
11. control_files='/u01/app/oracle/oradata/pengbo/control01.ctl','/u01/app/oracle/oradata/pengbo/control02.ctl','/u01/app/oracle/oradata/pengbo/control03.ctl'
    
12. set
    
13. db_file_name_convert='+DATA/aux/datafile/system.271.885845923','/u01/app/oracle/oradata/pengbo/system01.dbf','+DATA/aux/datafile/syspengbo.272.885845925','/u01/app/oracle/oradata/pengbo/syspengbo01.dbf','+DATA/aux/datafile/undotbs1.273.885845941','/u01/app/oracle/oradata/pengbo/undotbs1.dbf','+DATA/aux/datafile/users.275.885845997','/u01/app/oracle/oradata/pengbo/users01.dbf','+DATA/aux/datafile/example.274.885845967','/u01/app/oracle/oradata/pengbo/example01.dbf','+DATA/aux/datafile/tbs05319.276.885846023','/u01/app/oracle/oradata/pengbo/tbs05319.dbf'
    
14. set
    
15. log_file_name_convert='+DATA/aux/onlinelog/group_1.277.885846227','/u01/app/oracle/oradata/pengbo/redo01a.log','+FRA/aux/onlinelog/group_1.329.885846239','/u01/app/oracle/oradata/pengbo/redo01b.log','+DATA/aux/onlinelog/group_2.278.885846245','/u01/app/oracle/oradata/pengbo/redo02a.log','+FRA/aux/onlinelog/group_2.256.885846259','/u01/app/oracle/oradata/pengbo/redo02b.log','+DATA/aux/onlinelog/group_3.279.885846265','/u01/app/oracle/oradata/pengbo/redo03a.log','+FRA/aux/onlinelog/group_3.257.885846277','/u01/app/oracle/oradata/pengbo/redo03b.log';
    
16. }
    

复制代码

dup3.rcv

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 database to botang
   
8. backup location '/home/oracle/aux'
   
9. nofilenamecheck
   
10. spfile
    
11. set
    
12. db_create_file_dest=''
    
13. set
    
14. db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
    
15. set
    
16. control_files='/u01/app/oracle/oradata/botang/control01.ctl','/u01/app/oracle/oradata/botang/control02.ctl','/u01/app/oracle/oradata/botang/control03.ctl'
    
17. set
    
18. db_file_name_convert='+DATA/aux/datafile/system.271.885845923','/u01/app/oracle/oradata/botang/system01.dbf','+DATA/aux/datafile/sysaux.272.885845925','/u01/app/oracle/oradata/botang/sysaux01.dbf','+DATA/aux/datafile/undotbs1.273.885845941','/u01/app/oracle/oradata/botang/undotbs1.dbf','+DATA/aux/datafile/users.275.885845997','/u01/app/oracle/oradata/botang/users01.dbf','+DATA/aux/datafile/example.274.885845967','/u01/app/oracle/oradata/botang/example01.dbf','+DATA/aux/datafile/tbs05319.276.885846023','/u01/app/oracle/oradata/botang/tbs05319.dbf'
    
19. set
    
20. log_file_name_convert='+DATA/aux/onlinelog/group_1.277.885846227','/u01/app/oracle/oradata/botang/redo01a.log','+FRA/aux/onlinelog/group_1.329.885846239','/u01/app/oracle/oradata/botang/redo01b.log','+DATA/aux/onlinelog/group_2.278.885846245','/u01/app/oracle/oradata/botang/redo02a.log','+FRA/aux/onlinelog/group_2.256.885846259','/u01/app/oracle/oradata/botang/redo02b.log','+DATA/aux/onlinelog/group_3.279.885846265','/u01/app/oracle/oradata/botang/redo03a.log','+FRA/aux/onlinelog/group_3.257.885846277','/u01/app/oracle/oradata/botang/redo03b.log';
    
21. }
    

复制代码