Media Recovery Waiting for thread 1 sequence 177
Fetching gap sequence in thread 1, gap sequence 177-177
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_177f9q9x92z.ar
c
Media Recovery Waiting for thread 1 sequence 178
Fetching gap sequence in thread 1, gap sequence 178-178
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_178f9q9xmc8.ar
MESSAGE
c
Media Recovery Waiting for thread 1 sequence 179
Fetching gap sequence in thread 1, gap sequence 179-179
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_179f9q9xxgx.ar
c
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_112f9q9qmwy.ar
c
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_113f9q9qmyd.ar
MESSAGE
c
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_114f9q9qncn.ar
c
Media Recovery Waiting for thread 1 sequence 180
Fetching gap sequence in thread 1, gap sequence 180-180
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_180f9q9y7sn.ar
c
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_115f9q9qncr.ar
MESSAGE
c
Media Recovery Waiting for thread 1 sequence 181
Fetching gap sequence in thread 1, gap sequence 181-181
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_181f9q9ykrr.ar
c
Media Recovery Waiting for thread 1 sequence 182
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_182f9q9ywg8.ar
c
MESSAGE
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_116f9q9qnl3.ar
c
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_117f9q9qnl7.ar
c
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_118f9q9qnt2.ar
c
Media Recovery Waiting for thread 1 sequence 183
115 rows selected.
SQL>
7、查看日志中发现有大量的归档日志传输过来，详细的内容如下：
alter database recover managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process (strac)
Sun Mar 04 15:51:20 2018
MRP0 started with pid=22, OS id=10584
MRP0: Background Managed Standby Recovery process started (strac)
Serial Media Recovery started
Managed Standby Recovery not using Real Time Apply
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Waiting for thread 1 sequence 161
Fetching gap sequence in thread 1, gap sequence 161-161
Completed: alter database recover managed standby database disconnect from session
Sun Mar 04 15:52:58 2018
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
RFS[1]: Assigned to RFS process 10600
RFS[1]: Opened log for thread 1 sequence 161 dbid -1759711868 branch 947273412
Archived Log entry 48 added for thread 1 sequence 161 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:06 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_161f9q9gtp0.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_99f9kzzhq2.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_100f9l00mnz.arc
Media Recovery Waiting for thread 1 sequence 162
Fetching gap sequence in thread 1, gap sequence 162-162
Sun Mar 04 15:53:07 2018
RFS[2]: Assigned to RFS process 10604
RFS[2]: Opened log for thread 1 sequence 162 dbid -1759711868 branch 947273412
Archived Log entry 49 added for thread 1 sequence 162 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:16 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_162f9q9h3vb.arc
Media Recovery Waiting for thread 1 sequence 163
Fetching gap sequence in thread 1, gap sequence 163-163
RFS[2]: Opened log for thread 1 sequence 163 dbid -1759711868 branch 947273412
Archived Log entry 50 added for thread 1 sequence 163 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:26 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_163f9q9hdxv.arc
Media Recovery Waiting for thread 1 sequence 164
Fetching gap sequence in thread 1, gap sequence 164-164
Sun Mar 04 15:53:28 2018
RFS[2]: Opened log for thread 1 sequence 164 dbid -1759711868 branch 947273412
Archived Log entry 51 added for thread 1 sequence 164 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:37 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_164f9q9hr44.arc
Media Recovery Waiting for thread 1 sequence 165
Fetching gap sequence in thread 1, gap sequence 165-165
Sun Mar 04 15:53:38 2018
RFS[2]: Opened log for thread 1 sequence 165 dbid -1759711868 branch 947273412
Archived Log entry 52 added for thread 1 sequence 165 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:47 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_165f9q9j27p.arc
Media Recovery Waiting for thread 1 sequence 166
Fetching gap sequence in thread 1, gap sequence 166-166
Sun Mar 04 15:53:48 2018
RFS[2]: Opened log for thread 1 sequence 166 dbid -1759711868 branch 947273412
Archived Log entry 53 added for thread 1 sequence 166 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:57 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_166f9q9jdoq.arc
Media Recovery Waiting for thread 1 sequence 167
Fetching gap sequence in thread 1, gap sequence 167-167
RFS[2]: Opened log for thread 1 sequence 167 dbid -1759711868 branch 947273412
Archived Log entry 54 added for thread 1 sequence 167 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:54:07 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_167f9q9jotm.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_101f9l02sv8.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_102f9l02wrc.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_103f9l8x8b8.arc
Media Recovery Waiting for thread 1 sequence 168
Fetching gap sequence in thread 1, gap sequence 168-168
Sun Mar 04 15:55:08 2018
RFS[2]: Selected log 7 for thread 1 sequence 168 dbid -1759711868 branch 947273412
Sun Mar 04 15:55:10 2018
Archived Log entry 55 added for thread 1 sequence 168 ID 0x971d6184 dest 1:
Sun Mar 04 15:55:17 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_168f9q9lxgy.arc
Sun Mar 04 15:55:43 2018
Media Recovery Waiting for thread 1 sequence 169
Fetching gap sequence in thread 1, gap sequence 169-169
Sun Mar 04 15:55:46 2018
RFS[2]: Opened log for thread 1 sequence 169 dbid -1759711868 branch 947273412
Archived Log entry 56 added for thread 1 sequence 169 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:55:54 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_169f9q9n23p.arc
Media Recovery Waiting for thread 2 sequence 104
Sun Mar 04 15:55:55 2018
RFS[1]: Selected log 12 for thread 2 sequence 104 dbid -1759711868 branch 947273412
Sun Mar 04 15:55:55 2018
Archived Log entry 57 added for thread 2 sequence 104 ID 0x971d6184 dest 1:
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_104f9q9nc85.arc
Media Recovery Waiting for thread 2 sequence 105
Fetching gap sequence in thread 2, gap sequence 105-105
Sun Mar 04 15:56:05 2018
RFS[2]: Opened log for thread 2 sequence 105 dbid -1759711868 branch 947273412
Archived Log entry 58 added for thread 2 sequence 105 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:56:14 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_105f9q9no3z.arc
Media Recovery Waiting for thread 2 sequence 106
Fetching gap sequence in thread 2, gap sequence 106-106
Sun Mar 04 15:56:16 2018
RFS[2]: Opened log for thread 2 sequence 106 dbid -1759711868 branch 947273412
Archived Log entry 59 added for thread 2 sequence 106 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:56:24 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_106f9q9o0j5.arc
Sun Mar 04 15:56:49 2018
Media Recovery Waiting for thread 1 sequence 170
Fetching gap sequence in thread 1, gap sequence 170-170
Sun Mar 04 15:56:59 2018
RFS[2]: Opened log for thread 1 sequence 170 dbid -1759711868 branch 947273412
Archived Log entry 60 added for thread 1 sequence 170 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:09 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_170f9q9pcpl.arc
Media Recovery Waiting for thread 1 sequence 171
Fetching gap sequence in thread 1, gap sequence 171-171
Sun Mar 04 15:57:11 2018
RFS[2]: Opened log for thread 1 sequence 171 dbid -1759711868 branch 947273412
Archived Log entry 61 added for thread 1 sequence 171 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:20 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_171f9q9pqkc.arc
Media Recovery Waiting for thread 1 sequence 172
Fetching gap sequence in thread 1, gap sequence 172-172
Sun Mar 04 15:57:23 2018
RFS[2]: Opened log for thread 1 sequence 172 dbid -1759711868 branch 947273412
Archived Log entry 62 added for thread 1 sequence 172 rlc 947273412 ID 0x971d6184 dest 2:
RFS[2]: Opened log for thread 2 sequence 107 dbid -1759711868 branch 947273412
Sun Mar 04 15:57:28 2018
RFS[3]: Assigned to RFS process 10616
RFS[3]: Opened log for thread 2 sequence 108 dbid -1759711868 branch 947273412
Sun Mar 04 15:57:28 2018
RFS[4]: Assigned to RFS process 10614
RFS[4]: Opened log for thread 2 sequence 109 dbid -1759711868 branch 947273412
Sun Mar 04 15:57:31 2018
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: Assigned to RFS process 10618
RFS[5]: Selected log 11 for thread 2 sequence 119 dbid -1759711868 branch 947273412
Sun Mar 04 15:57:34 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_172f9q9q3pz.arc
Media Recovery Waiting for thread 2 sequence 107 (in transit)
Sun Mar 04 15:57:36 2018
Archived Log entry 63 added for thread 2 sequence 107 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:38 2018
RFS[6]: Assigned to RFS process 10620
RFS[6]: Opened log for thread 2 sequence 110 dbid -1759711868 branch 947273412
Sun Mar 04 15:57:38 2018
Archived Log entry 64 added for thread 2 sequence 109 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:39 2018
Archived Log entry 65 added for thread 2 sequence 108 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:39 2018
RFS[7]: Assigned to RFS process 10622
RFS[7]: Opened log for thread 2 sequence 111 dbid -1759711868 branch 947273412
Archived Log entry 66 added for thread 2 sequence 111 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:39 2018
RFS[8]: Assigned to RFS process 10624
RFS[8]: Opened log for thread 2 sequence 112 dbid -1759711868 branch 947273412
RFS[7]: Opened log for thread 2 sequence 113 dbid -1759711868 branch 947273412
Archived Log entry 67 added for thread 2 sequence 113 rlc 947273412 ID 0x971d6184 dest 2:
Archived Log entry 68 added for thread 2 sequence 112 rlc 947273412 ID 0x971d6184 dest 2:
RFS[7]: Opened log for thread 2 sequence 114 dbid -1759711868 branch 947273412
RFS[8]: Opened log for thread 2 sequence 115 dbid -1759711868 branch 947273412
Archived Log entry 69 added for thread 2 sequence 114 rlc 947273412 ID 0x971d6184 dest 2:
Archived Log entry 70 added for thread 2 sequence 115 rlc 947273412 ID 0x971d6184 dest 2:
RFS[7]: Opened log for thread 2 sequence 116 dbid -1759711868 branch 947273412
RFS[8]: Opened log for thread 2 sequence 117 dbid -1759711868 branch 947273412
Archived Log entry 71 added for thread 2 sequence 116 rlc 947273412 ID 0x971d6184 dest 2:
Archived Log entry 72 added for thread 2 sequence 117 rlc 947273412 ID 0x971d6184 dest 2:
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_107f9q9q7lr.arc
RFS[7]: Opened log for thread 2 sequence 118 dbid -1759711868 branch 947273412
Archived Log entry 73 added for thread 2 sequence 118 rlc 947273412 ID 0x971d6184 dest 2:
Archived Log entry 74 added for thread 2 sequence 110 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:58:38 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_108f9q9q7lv.arc
Media Recovery Waiting for thread 1 sequence 173
Fetching gap sequence in thread 1, gap sequence 173-173
Sun Mar 04 15:58:47 2018
RFS[6]: Opened log for thread 1 sequence 173 dbid -1759711868 branch 947273412
Archived Log entry 75 added for thread 1 sequence 173 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:58:59 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_173f9q9sq3g.arc
Sun Mar 04 15:59:22 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_109f9q9q7z6.arc
Media Recovery Waiting for thread 1 sequence 174
Fetching gap sequence in thread 1, gap sequence 174-174
Sun Mar 04 15:59:27 2018
RFS[6]: Opened log for thread 1 sequence 174 dbid -1759711868 branch 947273412
Archived Log entry 76 added for thread 1 sequence 174 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:59:36 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_174f9q9tz7q.arc
Sun Mar 04 15:59:52 2018
Media Recovery Waiting for thread 1 sequence 175
Fetching gap sequence in thread 1, gap sequence 175-175
Sun Mar 04 15:59:53 2018
db_recovery_file_dest_size of 10240 MB is 4.63% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sun Mar 04 15:59:56 2018
RFS[6]: Opened log for thread 1 sequence 175 dbid -1759711868 branch 947273412
Archived Log entry 77 added for thread 1 sequence 175 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:00:04 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_175f9q9vwo0.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_110f9q9qlco.arc
Media Recovery Waiting for thread 1 sequence 176
Fetching gap sequence in thread 1, gap sequence 176-176
Sun Mar 04 16:00:09 2018
RFS[6]: Opened log for thread 1 sequence 176 dbid -1759711868 branch 947273412
Archived Log entry 78 added for thread 1 sequence 176 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:00:21 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_176f9q9w9h5.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_111f9q9qmng.arc
Media Recovery Waiting for thread 1 sequence 177
Fetching gap sequence in thread 1, gap sequence 177-177
Sun Mar 04 16:00:41 2018
RFS[6]: Opened log for thread 1 sequence 177 dbid -1759711868 branch 947273412
Archived Log entry 79 added for thread 1 sequence 177 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:00:51 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_177f9q9x92z.arc
Media Recovery Waiting for thread 1 sequence 178
Fetching gap sequence in thread 1, gap sequence 178-178
Sun Mar 04 16:00:51 2018
RFS[6]: Opened log for thread 1 sequence 178 dbid -1759711868 branch 947273412
Archived Log entry 80 added for thread 1 sequence 178 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:01:01 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_178f9q9xmc8.arc
Media Recovery Waiting for thread 1 sequence 179
Fetching gap sequence in thread 1, gap sequence 179-179
Sun Mar 04 16:01:01 2018
RFS[6]: Opened log for thread 1 sequence 179 dbid -1759711868 branch 947273412
Archived Log entry 81 added for thread 1 sequence 179 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:01:11 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_179f9q9xxgx.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_112f9q9qmwy.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_113f9q9qmyd.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_114f9q9qncn.arc
Media Recovery Waiting for thread 1 sequence 180
Fetching gap sequence in thread 1, gap sequence 180-180
Sun Mar 04 16:01:11 2018
RFS[6]: Opened log for thread 1 sequence 180 dbid -1759711868 branch 947273412
Archived Log entry 82 added for thread 1 sequence 180 rlc 947273412 ID 0x971d6184 dest 2:
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_180f9q9y7sn.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_115f9q9qncr.arc
Media Recovery Waiting for thread 1 sequence 181
Fetching gap sequence in thread 1, gap sequence 181-181
RFS[6]: Opened log for thread 1 sequence 181 dbid -1759711868 branch 947273412
Archived Log entry 83 added for thread 1 sequence 181 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:01:31 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_181f9q9ykrr.arc
Media Recovery Waiting for thread 1 sequence 182
Sun Mar 04 16:01:32 2018
RFS[6]: Opened log for thread 1 sequence 182 dbid -1759711868 branch 947273412
Archived Log entry 84 added for thread 1 sequence 182 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:01:42 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_182f9q9ywg8.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_116f9q9qnl3.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_117f9q9qnl7.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_118f9q9qnt2.arc
Media Recovery Waiting for thread 1 sequence 183