OracleDG
文章平均质量分 82
renfengjun
这个作者很懒,什么都没留下…
展开
-
DG丢失归档,使用增量备份恢复一例
发生了这种错误,主库丢失了归档,而备库无法同步日志Media RecoveryWaiting for thread 1 sequence 70Fetching gapsequence in thread 1, gap sequence 70-72Completed: ALTERDATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FR原创 2012-03-07 21:47:43 · 4945 阅读 · 0 评论 -
DataGuard角色切换
Step 1 Verify that the primary database can be switched to the standby role.验证主库能够切换到备用角色。SELECT SWITCHOVER_STATUS FROM V$DATABASE;idle>:wqSWITCHOVER_STATUS--------------------TO原创 2012-03-08 09:19:14 · 1865 阅读 · 0 评论 -
搭建DataGuard环境
1. 确保源数据库在归档模式,并且是强制logging模式。shutdown immediate ;startup mount ;alter database archivelog ;alter database force logging ;alter database open ;2. 确保已经建立的密码文件。(确保能够远程登录(@xxx as sysdba)cd原创 2012-03-08 09:17:44 · 1976 阅读 · 0 评论