Oracle cascading standby Parameters
Primary Database
DB_UNIQUE_NAME=boston FAL_SERVER=boston2 LOG_ARCHIVE_CONFIG='DG_CONFIG=(boston,boston2,denver)' LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=boston' LOG_ARCHIVE_DEST_2='SERVICE=boston2 SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston2'
Cascading Physical Standby Database
DB_UNIQUE_NAME=boston2 FAL_SERVER=boston LOG_ARCHIVE_CONFIG= 'DG_CONFIG=(boston,boston2,denver)' LOG_ARCHIVE_DEST_1='LOCATION= USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=boston2' LOG_ARCHIVE_DEST_2= 'SERVICE=denver VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=denver'
Cascaded Physical Standby Database
DB_UNIQUE_NAME=denver FAL_SERVER=boston2 LOG_ARCHIVE_CONFIG='DG_CONFIG=(boston,boston2,denver)' LOG_ARCHIVE_DEST_1='LOCATION= USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=denver'
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25583515/viewspace-2147411/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle的快照standbyOracle
- Oracle DG Standby Database型別OracleDatabase型別
- Oracle DG建立Physical Standby DatabaseOracleDatabase
- Oracle DG建立Logical Standby DatabaseOracleDatabase
- Oracle dataguard報錯:Error 1017 received logging on to the standbyOracleError
- CSS( Cascading Style Sheets )簡書CSS
- Oracle 12.2 How to Generate AWRs in Active Data Guard Standby DatabasesOracleDatabase
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- Oracle 12.2 physical standby備庫收集AWR報告Oracle
- Oracle RAC+DG 調整redo/standby log fileOracle
- 在Oracle DG Standby庫上啟用flashback database功能OracleDatabase
- 【mos 1265700.1】Oracle Patch Assurance - Data Guard Standby-First Patch ApplyOracleAPP
- dataguard 搭建 oracle_sid相同 2節點 primary+standbyOracle
- dataguard 搭建 oracle_sid不同 2節點 primary+standbyOracle
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- TypeError: object() takes no parametersErrorObject
- oracle12.2 adg ORA-46952: standby database format mismatch for password fileOracleDatabaseORM
- 搭建windows到linux的oracle 12c physical standby備庫WindowsLinuxOracle
- Oracle 12C RAC的單機Standby returning error ORA-16191OracleError
- Oracle 19C Data Guard基礎運維-01安裝物理standbyOracle運維
- Oracle 19c透過recover standby database from service修復GAP案例OracleDatabase
- Oracle 12c DG備庫啟動報錯standby database requires recoveryOracleDatabaseUI
- Oracle 19c standby 建立資料檔案報錯ORA-01111Oracle
- Oracle 18C,19C standby CHECKPOINT_CHANGE# 不更新問題Oracle
- Android Audio HAL 介面介紹之 adev_set_parameters()和out_set_parameters()Androiddev
- [20230425]注意snapshot standby與activate standby的區別.txt
- Oracle 19C CBD Active DataGuard Standby passwd file 注意事項 ORA-01017Oracle
- Oracle standby的ORA-01578 ORA-01110 ORA-26040 坑爹的NOLOGGINGOracle
- 2 新增standby masterAST
- SAP Spartacus 中的 HTTP URL parametersHTTP
- CSS Cascading Style Sheets 層疊樣式表:CSS瞭解 (一)CSS
- Performing a Failover to a Physical Standby DatabaseORMAIDatabase
- 邏輯STANDBY建立中碰到ORA-16146: standby destination control file enqueue unavailableENQAI
- 主庫到standby報錯解決:Error 12154 received logging on to the standby ORA-12154Error
- c++ 模板模板引數("Template Template Parameters")C++
- Dynamics CRM Xrm.Utility.openEntityForm passing lookup parametersORM
- 【DG】Data Guard搭建(physical standby)
- Setup Standby Database on One PC(轉)Database
- 【等待事件】standby query scn advance事件