dataguard恢复备库后需先同步再启动到read only

 时间:2025-01-04 09:10:44

1、1:srvctl start database -d orcl_standby -o 'read only' 一致卡住[oracle@qidongbk1 dbs]$ srvctl start database -d orcl_standby -o 'read only'

2、2:查看数据库alert日志发现日志文件缺失Completed: ALTER DATABASE MOUNT /* db agent *//* {1:3056:3070} */ALTER DATABASE OPEN READ ONLY /* db agent *//* {1:3056:3070} */AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only accessThis instance was first to openBeginning Standby Crash Recovery.Errors in file /u01/app/oracle/diag/rdbms/orcl_standby/orcl_standby2/trace/orcl_standby2_lgwr_31115.trc:ORA-00313: open failed for members of log group 5 of thread 1ORA-00312: online log 5 thread 1: '+DATADG/orcl_standby/onlinelog/group_5'ORA-17503: ksfdopn:2 Failed to open file +DATADG/orcl_standby/onlinelog/group_5查看+DATADG/orcl_standby/onlinelog中没有日志文件。

dataguard恢复备库后需先同步再启动到read only

6、6:进程杀掉后备库关闭正常

dataguard恢复备库后需先同步再启动到read only

8、8:apply进程apply data完之后日志自动创建查看开启apply进程的备库节点的alert日志,发现media recovery正在等待thread2(也就是主库节点2)的日志序列:18949到主库节点2 archive log list查看节点2的实例日志序列号就是18949说明apply进程apply data完成并等待主库的归档。这时候asmcmd查看日志文件时发现日志文件已经自动创建

dataguard恢复备库后需先同步再启动到read onlydataguard恢复备库后需先同步再启动到read onlydataguard恢复备库后需先同步再启动到read only
  • Linux 添加新硬盘 LVM操作
  • vmware vsphere6.0之分布式交换机配置(vds)
  • win7 如何设置电脑hosts
  • Windows Server 2012如何禁用任务计划程序
  • Centos7 如何减少/home分区,扩大/root分区
  • 热门搜索
    旅游四级 国内旅游线路 大连海岛旅游网 株洲旅游景点大全 北京旅游年票网 额济纳旗旅游攻略 齐齐哈尔旅游景点大全 扬州旅游地图 郑州市旅游景点 韩国旅游局