standby database
practise and test following scenario:
A table have a trigger, with column c3 are updated or inserted timestamp.
the standby database delay apply redo/sql .
compare the value of c3 between primary db and physical/logical db.
[@more@]standby prerequisite:
1, hardware: maby be different.
2, OS ,the same classic, can be different release.
3, Oracle, same version. Same compatible parameter.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/350519/viewspace-1034472/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- Performing a Failover to a Physical Standby DatabaseORMAIDatabase
- Setup Standby Database on One PC(轉)Database
- Oracle DG Standby Database型別OracleDatabase型別
- Oracle DG建立Physical Standby DatabaseOracleDatabase
- Oracle DG建立Logical Standby DatabaseOracleDatabase
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- [20230110]sql profile run standby database.txtSQLDatabase
- 4 Creating a Logical Standby Database 建立邏輯備庫Database
- 在Oracle DG Standby庫上啟用flashback database功能OracleDatabase
- 透過RMAN備份standby database成功恢復還原Database
- oracle12.2 adg ORA-46952: standby database format mismatch for password fileOracleDatabaseORM
- Oracle 19c透過recover standby database from service修復GAP案例OracleDatabase
- Oracle 12c DG備庫啟動報錯standby database requires recoveryOracleDatabaseUI
- [20230425]注意snapshot standby與activate standby的區別.txt
- Oracle的快照standbyOracle
- 2 新增standby masterAST
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- 邏輯STANDBY建立中碰到ORA-16146: standby destination control file enqueue unavailableENQAI
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Error querying database. XXXXXXXXXXXXX, No database selected。ErrorDatabase
- 主庫到standby報錯解決:Error 12154 received logging on to the standby ORA-12154Error
- 【DG】Data Guard搭建(physical standby)
- 【等待事件】standby query scn advance事件
- Database TimeoutDatabase
- Database OverallDatabase
- database no shardingDatabase
- [20181113]Logical Standby建立2.txt
- ORACLE database vaultOracleDatabase
- Relationship Database DesignDatabase
- 3.4 Quiescing a DatabaseUIDatabase
- idea--DatabaseIdeaDatabase
- Oracle clone databaseOracleDatabase
- database的connectDatabase
- Password is required when adding a database to AG group if the database has a master keyUIDatabaseAST
- ORA-16649: possible failover to another database prevents this database from beiAIDatabase
- 判斷standby日誌是否同步primary
- DATAGUARD手記(PRIMARY+2STANDBY)(一)
- DG -- READ ONLY模式開啟物理Standby模式