Data Guard中MRP无法启动的问题分析和解决(2)

对于这个问题,如果有一个sql语句能够一针见血的解决问题就好了,自己在反复尝试之后发现还是有的,问题的解决思路就是先解决ORA-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/archivelog/1_129_880742847.dbf
 Sat Jun 27 23:25:29 2015

比较有意思的是查看日志可以看到,数据文件被反复创建删除了很多次。最后还是以drop终止。
 然后就开始使用一大堆的归档文件做数据恢复了。

Sat Jun 27 23:28:30 2015
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_172_880742847.dbf
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_173_880742847.dbf
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_174_880742847.dbf
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_175_880742847.dbf
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_176_880742847.dbf
 Sat Jun 27 23:28:40 2015
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_177_880742847.dbf
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_178_880742847.dbf
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_179_880742847.dbf
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_180_880742847.dbf
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_181_880742847.dbf
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_182_880742847.dbf
 Sat Jun 27 23:28:52 2015
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_183_880742847.dbf
 Media Recovery Log /u02/dg11g/flash_recovery_area/DG11G/archivelog/1_184_880742847.dbf

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/0d63b5ebcde29e276e4cbcd9dc9cd5b8.html