两种方式克隆12c数据库

botang

1. From Active Database:

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. allocate auxiliary channel c6 device type disk;
   
8. allocate auxiliary channel c7 device type disk;
   
9. allocate auxiliary channel c8 device type disk;
   
10. duplicate target database to  activedb
    
11. from active database
    
12. USING BACKUPSET
    
13. SECTION SIZE  1000M
    
14. SKIP TABLESPACE  'TBS4K','TBSSMALL'
    
15. nofilenamecheck
    
16. spfile
    
17. set
    
18. control_files='+DATA','+FRA'
    
19. set
    
20. db_file_name_convert='+DATA/ORCL/','+DATA/ACTIVEDB/'
    
21. set
    
22. log_file_name_convert='+DATA/ORCL/','+DATA/ACTIVEDB/','+FRA/ORCL/','+FRA/ACTIVEDB/'
    
23. set
    
24. audit_file_dest='/u01/app/oracle/admin/activedb/adump'
    
25. set
    
26. memory_target='2600M'
    
27. set
    
28. memory_max_target='2600M'
    
29. set
    
30. local_listener='LISTENER_ACTIVEDB';
    
31. }
    
32. 
    

复制代码

2. From Backup Location:

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. allocate auxiliary channel c6 device type disk;
   
8. allocate auxiliary channel c7 device type disk;
   
9. allocate auxiliary channel c8 device type disk;
   
10. allocate channel c9 device type disk;
    
11. allocate channel c10 device type disk;
    
12. allocate channel c11 device type disk;
    
13. allocate channel c12 device type disk;
    
14. allocate channel c13 device type disk;
    
15. allocate channel c14 device type disk;
    
16. allocate channel c15 device type disk;
    
17. allocate channel c16 device type disk;
    
18. duplicate target database to  'backupdb'
    
19. backup location '/home/oracle/backupdb'
    
20. nofilenamecheck
    
21. SKIP TABLESPACE  'TBS4K','TBSSMALL'
    
22. spfile
    
23. set
    
24. control_files='+DATA','+FRA'
    
25. set
    
26. db_file_name_convert='+DATA/ORCL/','+DATA/BACKUPDB/'
    
27. set
    
28. log_file_name_convert='+DATA/ORCL/','+DATA/BACKUPDB/','+FRA/ORCL/','+FRA/BACKUPDB/'
    
29. set
    
30. audit_file_dest='/u01/app/oracle/admin/backupdb/adump'
    
31. set
    
32. memory_target='2600M'
    
33. set
    
34. memory_max_target='2600M'
    
35. set
    
36. local_listener='LISTENER_BACKUPDB';
    
37. }
    
38. 
    

复制代码