ADG主库上归档丢失恢复备库测试模拟了下在主库上丢失归档导致备库出现gap,无需重建恢复备库的情况1制造gap主库ALTER system SET log_archive_dest_state_2 = 'defer';一些dml操作alter system switch logfile;备库此时的mrp是等待log状态SQL> select process,client_process
检查Data Guard 主库,发现log有如下信息: Wed Oct 13 17:05:11 2010 RFS: Possible network disconnect with primary database RFS: Destination database mount ID mismatch [0x4b1b0155:0x4b1b40c1] RFS: client in
文章目录 1.主从复制集群正常状态信息2.从库状态信息中重要参数的含义 1.主从复制集群正常状态信息 通过以下命令查看主库的状态信息。 mysql> show processlist; 在主库中查询当前数据库中的进程,看到Master has sent all binlog to slave; waiting for more updates这个信息时,就表示主库一切正常
为了测试pg模拟down机,可使用插件pg_kaboom:GitHub - pgguru/pg_kaboom: Devious SQL-based SQL tools to crash your PostgreSQL server $ git clone git@github.com:CrunchyData/pg_kaboom.git$ cd pg_kaboom$ make PG_C
做MYCAT实验时候,从master主库删掉一行数据,然后又把从库数据也手动删掉了。发现主从同步失效了。在从库看了下状态 mysql> show slave status \G 其中比较关键的三行: Slave_IO_Running: Yes Slave_SQL_Running: No Last_Error: Could not execute Delete_rows even
1) On the standby database, 关闭 (MRP) SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; 2) On the STANDBY DATABASE, 获取备库最小scn值,用作主库增量备份点 : col MIN(CHECKPOINT_CHANGE#) for 999999
8.3.5 Adding or Dropping Online Redo Log Files 8.3.5 添加或删除现在重做日志文件 Changing the size and number of the online redo log files is sometimes done to tune the database. You can add or drop online
8.3.4 Renaming a Datafile in the Primary Database 8.3.4 在主库中重命令数据文件(即手动在备库修改相等的变化) When you rename one or more datafiles in the primary database, the change is not propagated to the standby d
8.3.2 Dropping Tablespaces and Deleting Datafiles 8.3.2 删除表空间和删除数据文件 When you delete one or more datafiles or drop one or more tablespaces in the primary database, you also need to delete the
8.3 Managing Primary Database Events That Affect the Standby Database 8.3 管理主库能影响备库的事件 To prevent possible problems, you must be aware of events on the primary database that affect a standby