设为首页 加入收藏

TOP

DataGuard中MRP无法启动的问题分析和解决(二)
2015-11-10 12:16:34 来源: 作者: 【 】 浏览:1
Tags:DataGuard MRP 无法 启动 问题 分析 解决
A-01157问题,然后dataguard中的MRP问题就能引刃而解。
?对于ora-01157这个问题中的数据文件在主库中不存在,但是在备库的数据字典中存在,我们可以直接在备库中把数据字典中的问题先解决了。
idle> alter database datafile '/u02/dg11g/oradata/DG11G/test_new01.dbf' offline drop;
?Database altered.
然后dataguard的日志中就出现而来转机,在后台会去校验这个文件的问题,只是抛出了一个警告。Warning: Datafile 7 (/u02/ora11g/oradata/TEST11G/test_new01.dbf) is offline during full database recovery and will not be recovered
然后MRP就正常启动了。后台开始使用归档文件做数据恢复了。


alter database datafile '/u02/dg11g/oradata/DG11G/test_new01.dbf' offline drop
?Completed: alter database datafile '/u02/dg11g/oradata/DG11G/test_new01.dbf' offline drop
?Sat Jun 27 23:24:08 2015
?ALTER DATABASE RECOVER? managed standby database disconnect from session
?Attempt to start background Managed Standby Recovery process (DG11G)
?Sat Jun 27 23:24:08 2015
?MRP0 started with pid=25, OS id=8431
?MRP0: Background Managed Standby Recovery process started (DG11G)
? started logmerger process
?Sat Jun 27 23:24:13 2015
?Managed Standby Recovery not using Real Time Apply
?Parallel Media Recovery started with 2 slaves
?Warning: Datafile 7 (/u02/ora11g/oradata/TEST11G/test_new01.dbf) is offline during full database recovery and will not be recovered
?Waiting for all non-current ORLs to be archived...
?All non-current ORLs have been archived.
Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_121_880742847.dbf
?Completed: ALTER DATABASE RECOVER? managed standby database disconnect from session
?Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_122_880742847.dbf
?Sat Jun 27 23:24:31 2015
?Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_123_880742847.dbf
?Recovery deleting file #7:'/u02/dg11g/oradata/DG11G/test_new01.dbf' from controlfile.
?Deleted file /u02/dg11g/oradata/DG11G/test_new01.dbf
?Recovery dropped tablespace 'TEST_NEW'
?Recovery created file /u02/dg11g/oradata/DG11G/test_new01.dbf
?Successfully added datafile 7 to media recovery
?Datafile #7: '/u02/dg11g/oradata/DG11G/test_new01.dbf'
?Recovery deleting file #7:'/u02/dg11g/oradata/DG11G/test_new01.dbf' from controlfile.
?Deleted file /u02/dg11g/oradata/DG11G/test_new01.dbf
?Recovery dropped tablespace 'TEST_NEW'
?Recovery deleting file #7:'/u02/dg11g/oradata/DG11G/test_new01.dbf' from controlfile.
?Deleted file /u02/dg11g/oradata/DG11G/test_new01.dbf
?Recovery dropped tablespace 'TEST_NEW'
?Recovery deleting file #7:'/u02/dg11g/oradata/DG11G/test_new01.dbf' from controlfile.
?Deleted file /u02/dg11g/oradata/DG11G/test_new01.dbf
?Recovery dropped tablespace 'TEST_NEW'
Media Recovery Log /u02/dg11g/switchover/DG11G/archivelog/1_124_880742847.dbf
Media Recovery Log /u02/dg11g/switchover/DG11G/archivelog/1_125_880742847.dbf
?Recovery deleting file #7:'/u02/dg11g/oradata/DG11G/test_new01.dbf' from controlfile.
?Deleted file /u02/dg11g/oradata/DG11G/test_new01.dbf
?Recovery dropped tablespace 'TEST_NEW'
Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_126_880742847.dbf
Sat Jun 27 23:24:49 2015
?Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_127_880742847.dbf
?Sat Jun 27 23:25:01 2015
?Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_128_880742847.dbf
?Sat Jun 27 23:25:17 2015
?Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivel

首页 上一页 1 2 3 下一页 尾页 2/3/3
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇Linux上如何安装sqlplus客户端 下一篇由drop datafile导致的Oracle bug

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: