模拟物理standby产生GAP的情形(二)
05797.dbf'
Tue Aug 6 11:24:30 2013
Fetching gap sequence in thread 1, gap sequence107-110
Tue Aug 6 11:25:00 2013
FAL[client]: Failedto request gap sequence
GAP - thread 1 sequence 107-110
DBID 1321586530 branch 793805797
FAL[client]: All defined FAL servers have beenattempted.
通过查询备库的视图也可以获得信息：
SQL> select* from v$archive_gap;
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
----------------------- --------------
1 107 110
7.现在开始做恢复，将主库的日志给copy过来，并注册到备库：
[oracle@rhel131archivelog]$ scp 1_107_793805797.dbf.bk 172.17.61.132:/tmp oracle@172.17.61.132's password: 1_107_793805797.dbf.bk 100% 1024 1.0KB/s 00:00 [oracle@rhel131archivelog]$ scp 1_108_793805797.dbf.bk 172.17.61.132:/tmp oracle@172.17.61.132'spassword: 1_108_793805797.dbf.bk 100% 75KB 74.5KB/s 00:00 [oracle@rhel131archivelog]$ scp 1_109_793805797.dbf.bk 172.17.61.132:/tmp oracle@172.17.61.132'spassword: 1_109_793805797.dbf.bk 100% 4608 4.5KB/s 00:00 [oracle@rhel131archivelog]$ scp 1_110_793805797.dbf.bk 172.17.61.132:/tmp oracle@172.17.61.132'spassword: 1_110_793805797.dbf.bk 100% 2560 2.5KB/s 00:00 SQL> alterdatabase register logfile '/tmp/1_107_793805797.dbf.bk'; Databasealtered. SQL> alterdatabase register logfile '/tmp/1_108_793805797.dbf.bk'; Databasealtered. SQL>alterdatabase register logfile '/tmp/1_109_793805797.dbf.bk'; Databasealtered. SQL> alterdatabase register logfile '/tmp/1_110_793805797.dbf.bk'; Databasealtered.
8.此时的备库信息：
alter databaseregister logfile '/tmp/1_107_793805797.dbf.bk'
Tue Aug 6 11:43:28 2013
There are 1logfiles specified.
ALTER DATABASEREGISTER [PHYSICAL] LOGFILE
Completed:alter database register logfile '/tmp/1_107_793805797.dbf.bk'
Tue Aug 6 11:43:30 2013
Media RecoveryLog /tmp/1_107_793805797.dbf.bk
Media RecoveryWaiting for thread 1 sequence 108
Fetching gapsequence in thread 1, gap sequence 108-110
Tue Aug 6 11:43:42 2013
alter databaseregister logfile '/tmp/1_108_793805797.dbf.bk'
Tue Aug 6 11:43:42 2013
There are 1logfiles specified.
ALTER DATABASEREGISTER [PHYSICAL] LOGFILE
Completed:alter database register logfile '/tmp/1_108_793805797.dbf.bk'
Tue Aug 6 11:43:49 2013
alter databaseregister logfile '/tmp/1_109_793805797.dbf.bk'
There are 1logfiles specified.
ALTER DATABASEREGISTER [PHYSICAL] LOGFILE
Completed:alter database register logfile '/tmp/1_109_793805797.dbf.bk'
Tue Aug 6 11:43:56 2013
alter databaseregister logfile '/tmp/1_110_793805797.dbf.bk'
Tue Aug 6 11:43:56 2013
There are 1logfiles specified.
ALTER DATABASEREGISTER [PHYSICAL] LOGFILE
Completed:alter database register logfile '/tmp/1_110_793805797.dbf.bk'
Tue Aug 6 11:44:00 2013
Media RecoveryLog /tmp/1_108_793805797.dbf.bk
Media RecoveryLog /tmp/1_109_793805797.dbf.bk
Media RecoveryLog /tmp/1_110_793805797.dbf.bk
Media RecoveryLog /u01/app/oracle/oradata/orcl/archivelog/1_111_793805797.dbf
Media RecoveryLog /u01/app/oracle/oradata/orcl/archivelog/1_112_793805797.dbf
Media RecoveryLog /u01/app/oracle/o