比较有意思的是查看日志可以看到，数据文件被反复创建删除了很多次。最后还是以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

在主库中查看，redo的序列号185,备库中的序列号是184。
sys@TEST11G> select sequence#,status from v$log;
? SEQUENCE# STATUS
?---------- ----------------
? ? ? ? 184 INACTIVE
? ? ? ? 185 CURRENT
? ? ? ? 183 INACTIVE

在备库中查看后台进程的情况，可以看到MRP已经记录在册了。
idle> select process,status,sequence# from v$managed_standby;
?PROCESS? STATUS? ? ? ? SEQUENCE#
?--------- ------------ ----------
?ARCH? ? ? CONNECTED? ? ? ? ? ? 0
?ARCH? ? ? CONNECTED? ? ? ? ? ? 0
?ARCH? ? ? CONNECTED? ? ? ? ? ? 0
?ARCH? ? ? CONNECTED? ? ? ? ? ? 0
MRP0? ? ? WAIT_FOR_LOG? ? ? ? 186