dg
xixi艾
这个作者很懒,什么都没留下…
展开
-
dg之主备切换
主备切换前,一定要注意日志全都应用 主备切换报错,如何切换回去? 现备库(原主库)切回主库 QL> select database_role,switchover_status from v$database; DATABASE_ROLE SWITCHOVER_STATUS PHYSICAL STANDBY SESSIONS ACTIVE SQL> alter database commit to switchover to primary with session shutdown; Da原创 2021-10-14 17:21:46 · 415 阅读 · 0 评论 -
dg搭建问题
1.在经过主库rman duplicate 复制后,备库启动时报错 ERROR at line 1: ORA-10458: standby database requires recovery ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: ‘/opt/oracle/oradata/yoon/system01.dbf’ 此情况多为tnsname.ora配置问题;或者主库重启即可原创 2021-09-20 17:43:07 · 193 阅读 · 0 评论