ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed
配置DG引數檔案initprod1.ora新增部分
#dg add *.DB_UNIQUE_NAME=prodpri *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(prodpri,proddg)' *.LOG_ARCHIVE_DEST_1='LOCATION=/oracle/app/oracle/oradata/prod/arch valid_for= (all_logfiles,all_roles) db_unique_name=prodpri' *.LOG_ARCHIVE_DEST_2='SERVICE=tns_standby LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=proddg' *.LOG_ARCHIVE_DEST_STATE_1=ENABLE *.LOG_ARCHIVE_DEST_STATE_2=ENABLE *.FAL_SERVER=tns_standby *.FAL_CLIENT=tns_primary *.STANDBY_FILE_MANAGEMENT=AUTO *.log_archive_max_processes=30 #*.db_create_file_dest='/oracle/app/oracle/oradata/prod/' *.db_file_name_convert='/oracle/app/oracle/oradata/prod/','/oracle/app/oracle/oradata/prod/' *.log_file_name_convert='/oracle/app/oracle/oradata/prod/','/oracle/app/oracle/oradata/prod/'
啟動示例總是報錯
SQL> startup; ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed
分析了好久,終於發現問題
*.LOG_ARCHIVE_DEST_1這一行的問題
錯誤配置
valid_for= (all_logfiles,all_roles)
正確配置
valid_for=(all_logfiles,all_roles)
等號後面不能有空格
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70004783/viewspace-2788871/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- springboot開發介面報錯Optional int parameter 'userId' is present but cannot be translated into a null v......Spring BootNull
- Required parameter $xxx follows optional parameter $yyyUI
- UNREFERENCED_PARAMETER
- v$parameter gv$parameter 檢視 DDL 與隱含引數
- LTSPICE parameter設定
- python parameter引數Python
- Caused by: org.apache.ibatis.binding.BindingException: Parameter 'parameter' not found.解決ApacheBATException
- [20200114]關於log_archive_dest_1設定.txtHive
- [20200219]log_archive_dest_1定義問題.txtHive
- Field Parameter的設定
- how to show hidden parameter(zt)
- PostgreSQL DBA(86) - Table Parameter(fillfactor)SQL
- UNREFERENCED_PARAMETER的用處
- DataTables 1.10錯誤: requested unknown parameter
- ERROR: Cannot uninstall ‘PyYAML‘. It is a distutils installed project and thus we cannot accuratelyErrorYAMLProject
- 解決cannot find module providing package或cannot find main modulePackageAI
- 矽基流動 The parameter is invalid. Please check againAI
- PostgreSQL DBA(152) - pgAdmin(log_XXX parameter:when)SQL
- PostgreSQL DBA(153) - pgAdmin(log_XXX parameter:what)SQL
- PostgreSQL DBA(151) - pgAdmin(log_XXX parameter:where)SQL
- SD 一些常用的引數(Parameter)
- cannot instantiate QtProjectEngine objectQTProjectObject
- diskgroup "DATADG" cannot be mounted
- xxx cannot be resolved to a type
- org.apache.ibatis.binding.BindingException: Parameter 'xxx' not found.ApacheBATException
- fork failed - Cannot allocate memoryAI
- ‘error: ‘‘this‘‘ cannot be implicitly captured in this context‘ErrorAPTContext
- Cannot read property ‘aDataSort‘ of undefinedUndefined
- Uncaught Error: Cannot instantiate interfaceError
- Cannot set property 'innerHTML' of nullHTMLNull
- ImportError: cannot import name parseImportError
- 【PARAMETER】Oracle引數:MAX_IDLE_BLOCKER_TIME 解釋OracleBloC
- parameter hj8828vip installed Oracle h518vip onOracleH5
- java.sql.SQLException: No value specified for parameter 1 異常分析JavaSQLException
- web應用servlet中Attribute、Parameter、InitParameter的區別WebServlet
- pyhton3解決”tuple parameter unpacking is not supported”問題
- ValueError: output parameter for reduction operation logical_and has too many dimensions ?Error
- /usr/bin/ld: cannot find -lopenblas