rman duplicate创建adg备库时报错

tangjiangdong

rman duplicate创建adg备库时：
duplicate target database for standby from active database nofilenamecheck;
报错如下：

1. RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/30/2018 18:17:06
   
2. ORA-17628: Oracle error 19505 returned by remote Oracle server
   
3. continuing other job steps, job failed will not be re-run
   
4. channel ORA_DISK_1: starting datafile copy
   
5. input datafile file number=00121 name=+ORADAT/crds3db/datafile/tsp_zongheshuju2018_idx_02.dbf
   
6. RMAN-00571: ===========================================================
   
7. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
   
8. RMAN-00571: ===========================================================
   
9. RMAN-03002: failure of Duplicate Db command at 05/30/2018 18:17:07
   
10. RMAN-05501: aborting duplication of target database
    
11. RMAN-03015: error occurred in stored script Memory Script
    
12. RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/30/2018 18:17:07
    
13. ORA-17628: Oracle error 19505 returned by remote Oracle server

复制代码

主库参数：

1. alter system set db_unique_name='crds3db'  scope=spfile sid='*';
   
2. alter system set log_archive_config='dg_config=(crds3db,crds3dbdg)'   scope=spfile sid='*';
   
3. alter system set log_archive_dest_1='location=+oraarc valid_for=(all_logfiles,all_roles) db_unique_name=crds3db'  scope=spfile sid='*';
   
4. alter system set log_archive_dest_2='service=crds3dbdg valid_for=(online_logfiles,primary_role) db_unique_name=crds3dbdg'   scope=spfile sid='*';
   
5. alter system set log_archive_dest_state_1=enable   scope=spfile sid='*';
   
6. alter system set log_archive_dest_state_2=enable   scope=spfile sid='*';
   
7. alter system set standby_file_management='auto'   scope=spfile sid='*';
   
8. alter system set fal_server='crds3dbdg'   scope=spfile sid='*';
   
9. alter system set db_file_name_convert='/oradata/oradata/crds3dbdg/datafile','+oradat/crds3db/datafile','/oradata/oradata/crds3dbdg/tempfile','+oradat/crds3db/tempfile' scope=spfile sid='*';
   
10. alter system set log_file_name_convert='/oradata/oradata/crds3dbdg/onlinelog','+oradat/crds3db/onlinelog' scope=spfile sid='*';
    
11. alter system set log_archive_format='%t_%s_%r.arch' scope=spfile sid='*';
    

复制代码

备库参数：

1. *.audit_file_dest='/oradata/admin/crds3dbdg/adump'
   
2. *.audit_trail='db'
   
3. *.compatible='11.2.0.4.0'
   
4. *.control_files='/oradata/oradata/crds3dbdg/control01.ctl','/oradata/fast_recovery_area/crds3dbdg/control02.ctl'
   
5. *.db_block_size=16384
   
6. *.db_domain=''
   
7. *.db_name='crds3db'
   
8. *.memory_target=16106127360
   
9. *.open_cursors=300
   
10. *.processes=1500
    
11. *.db_unique_name='crds3dbdg'
    
12. *.service_names='crds3dbdg'
    
13. *.diagnostic_dest='/app/oracle'
    
14. *.dispatchers='(PROTOCOL=TCP) (SERVICE=crds3dbXDB)'
    
15. *.fal_server='crds3dbdg'
    
16. *.log_archive_config='dg_config=(crds3db,crds3dbdg)'
    
17. *.log_archive_dest_1='location=/oradata/fast_recovery_area/crds3dbdg valid_for=(all_logfiles,all_roles) db_unique_name=crds3dbdg'
    
18. *.log_archive_dest_2='service=crds3db valid_for=(online_logfiles,primary_role) db_unique_name=crds3db'
    
19. *.log_archive_dest_state_1='ENABLE'
    
20. *.log_archive_dest_state_2='ENABLE'
    
21. *.log_archive_format='%t_%s_%r.arch'
    
22. *.log_file_name_convert='+oradat/crds3db/onlinelog','/oradata/oradata/crds3dbdg/onlinelog
    
23. *.db_file_name_convert='+oradat/crds3db/datafile','/oradata/oradata/crds3dbdg/datafile','+oradat/crds3db/tempfile','/oradata/oradata/crds3dbdg/tempfile'
    
24. *.remote_login_passwordfile='exclusive'
    
25. *.sessions=1655
    
26. *.standby_file_management='auto'
    
27. *.undo_tablespace='UNDOTBS1'
    
28. *.db_recovery_file_dest='/oradata/fast_recovery_area'
    
29. *.db_recovery_file_dest_size=4621074432
    
30. *.fal_server='crds3db'
    

复制代码

这问题好像是备库目录没有创建，但是看过了有创建。这个是怎么回事呢？

tangjiangdong

*.log_file_name_convert='+oradat/crds3db/onlinelog','/oradata/oradata/crds3dbdg/onlinelog
目前发现这个conver参数的最后一个没有单引号，等明天去备库查验一下，再回复帖子

tangjiangdong

结帖，就是因为这个参数没有配置正确导致的

botang

tangjiangdong 发表于 2018-5-31 15:15
结帖，就是因为这个参数没有配置正确导致的

这就是要动手做，对吧。