--rac11.2.0.3端创建一个表空间,但DG端(dg端 是单实例+ASM)没有...

dba_fred

rac+dg,大伙帮忙看看,谢谢,
--rac11.2.0.3端创建一个表空间,但DG端(dg端 是单实例+ASM)没有生成,且DG端MRP进程挂了

rac操作如下:
create tablespace user04 datafile '+DATA' size 100m autoextend on maxsize unlimited;
--+DATA/devdb/datafile/user04.272.923310867

目标DG端的警告日志最后如下

Originally created as:
'+DATA/devdb/datafile/user04.272.923310867'
Recovery was unable to create the file as a new OMF file.
MRP0: Background Media Recovery terminated with error 1274
Errors in file /u01/app/oracle/diag/rdbms/phydb/phydb/trace/phydb_mrp0_7700.trc:
ORA-01274: cannot add datafile '+DATA/devdb/datafile/user04.272.923310867' - file could not be created
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 1271890
MRP0: Background Media Recovery process shutdown (phydb)

目标DG端用的是initphydb.ora,没有用spfile
内容如下

*.audit_file_dest='/u01/app/oracle/admin/phydb/adump'
*.audit_trail='db'
#*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA/phydb/controlfile/cont.ctl'
#*.core_dump_dest='/u01/app/oracle/diag/rdbms/phydb/cdump'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_file_name_convert='+DATA/devdb/','+DATA/phydb/'
*.db_domain=''
*.db_name='devdb'
*.db_recovery_file_dest='+FLASH'
*.db_recovery_file_dest_size=41943040000
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=phydbXDB)'
#*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=419430400
*.processes=1000
*.remote_login_passwordfile='exclusive'
*.sessions=1105
*.sga_target=1932735283

*.db_unique_name='phydb'
*.fal_client='phydb'
*.fal_server='devdb1','devdb2'
*.log_archive_config='dg_config=(devdb,phydb)'
*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles) db_unique_name=phydb'
*.log_archive_dest_2='service=devdb1 valid_for=(online_logfiles,primary_role) db_unique_name=devdb'
*.log_archive_format='ARC_%t_%S_%r.arc'
*.log_file_name_convert='+DATA/devdb/','+DATA/phydb/','+FLASH_EXT/devdb/','+FLASH/phydb/'
*.service_names='phydb'
*.standby_file_management='auto'
*.thread=1
*.undo_management='auto'
*.undo_tablespace='UNDOTBS1'



请问哪里不对么?
*.db_file_name_convert='+DATA/devdb/','+DATA/phydb/'
*.log_file_name_convert='+DATA/devdb/','+DATA/phydb/','+FLASH_EXT/devdb/','+FLASH/phydb/'
*.standby_file_management='auto'

*.log_file_name_convert这个要改么?

Liu Maclean(刘相兵

*.db_file_name_convert='+DATA/devdb/','+DATA/phydb/'

去掉

设置一个 db_create_file_dest

测试 给出 alert.log 中的结果