rman duplicate创建adg备库时报错
rman duplicate创建adg备库时：duplicate target database for standby from active database nofilenamecheck;
报错如下：
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/30/2018 18:17:06
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting datafile copy
input datafile file number=00121 name=+ORADAT/crds3db/datafile/tsp_zongheshuju2018_idx_02.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/30/2018 18:17:07
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/30/2018 18:17:07
ORA-17628: Oracle error 19505 returned by remote Oracle server
主库参数：
alter system set db_unique_name='crds3db'scope=spfile sid='*';
alter system set log_archive_config='dg_config=(crds3db,crds3dbdg)' scope=spfile sid='*';
alter system set log_archive_dest_1='location=+oraarc valid_for=(all_logfiles,all_roles) db_unique_name=crds3db'scope=spfile sid='*';
alter system set log_archive_dest_2='service=crds3dbdg valid_for=(online_logfiles,primary_role) db_unique_name=crds3dbdg' scope=spfile sid='*';
alter system set log_archive_dest_state_1=enable scope=spfile sid='*';
alter system set log_archive_dest_state_2=enable scope=spfile sid='*';
alter system set standby_file_management='auto' scope=spfile sid='*';
alter system set fal_server='crds3dbdg' scope=spfile sid='*';
alter system set db_file_name_convert='/oradata/oradata/crds3dbdg/datafile','+oradat/crds3db/datafile','/oradata/oradata/crds3dbdg/tempfile','+oradat/crds3db/tempfile' scope=spfile sid='*';
alter system set log_file_name_convert='/oradata/oradata/crds3dbdg/onlinelog','+oradat/crds3db/onlinelog' scope=spfile sid='*';
alter system set log_archive_format='%t_%s_%r.arch' scope=spfile sid='*';
备库参数：
*.audit_file_dest='/oradata/admin/crds3dbdg/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/oradata/oradata/crds3dbdg/control01.ctl','/oradata/fast_recovery_area/crds3dbdg/control02.ctl'
*.db_block_size=16384
*.db_domain=''
*.db_name='crds3db'
*.memory_target=16106127360
*.open_cursors=300
*.processes=1500
*.db_unique_name='crds3dbdg'
*.service_names='crds3dbdg'
*.diagnostic_dest='/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=crds3dbXDB)'
*.fal_server='crds3dbdg'
*.log_archive_config='dg_config=(crds3db,crds3dbdg)'
*.log_archive_dest_1='location=/oradata/fast_recovery_area/crds3dbdg valid_for=(all_logfiles,all_roles) db_unique_name=crds3dbdg'
*.log_archive_dest_2='service=crds3db valid_for=(online_logfiles,primary_role) db_unique_name=crds3db'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arch'
*.log_file_name_convert='+oradat/crds3db/onlinelog','/oradata/oradata/crds3dbdg/onlinelog
*.db_file_name_convert='+oradat/crds3db/datafile','/oradata/oradata/crds3dbdg/datafile','+oradat/crds3db/tempfile','/oradata/oradata/crds3dbdg/tempfile'
*.remote_login_passwordfile='exclusive'
*.sessions=1655
*.standby_file_management='auto'
*.undo_tablespace='UNDOTBS1'
*.db_recovery_file_dest='/oradata/fast_recovery_area'
*.db_recovery_file_dest_size=4621074432
*.fal_server='crds3db'
这问题好像是备库目录没有创建，但是看过了有创建。这个是怎么回事呢？
*.log_file_name_convert='+oradat/crds3db/onlinelog','/oradata/oradata/crds3dbdg/onlinelog
目前发现这个conver参数的最后一个没有单引号，等明天去备库查验一下，再回复帖子 结帖，就是因为这个参数没有配置正确导致的 tangjiangdong 发表于 2018-5-31 15:15
结帖，就是因为这个参数没有配置正确导致的
这就是要动手做，对吧。
页:
[1]