[Oracledatagard]从库恢复之ORA-16032:parameterORA-07286:问题 - 数据库编程

ence 7368 Fetching gap sequence in thread 1, gap sequence 7368-7392 FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 7368-7392 DBID 3391761643 branch 821708334 FAL[client]: All defined FAL servers have been attempted. Attempt to start background Managed Standby Recovery process MRP0: Background Managed Standby Recovery process started Managed Standby Recovery not using Real Time Apply MESSAGE -------------------------------------------------------------------------------- Media Recovery Waiting for thread 1 sequence 7368 Fetching gap sequence in thread 1, gap sequence 7368-7392 FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 7368-7392 DBID 3391761643 branch 821708334 FAL[client]: All defined FAL servers have been attempted. MRP0: Background Media Recovery cancelled with status 16037 MRP0: Background Media Recovery process shutdown Managed Standby Recovery Canceled Managed Standby Recovery not using Real Time Apply Attempt to start background Managed Standby Recovery process MESSAGE -------------------------------------------------------------------------------- MRP0: Background Managed Standby Recovery process started Managed Standby Recovery not using Real Time Apply Media Recovery Waiting for thread 1 sequence 7368 Fetching gap sequence in thread 1, gap sequence 7368-7392 FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 7368-7392 DBID 3391761643 branch 821708334 FAL[client]: All defined FAL servers have been attempted. 52 rows selected.
9 再试试直接修改状态到open吧

SQL> alter database open;

Database altered.

SQL>  select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY
# 将备库置于自动恢复状态
SQL> recover managed standby database disconnect from session;
Media recovery complete.

10 # check，检查主从的归档日志情况

SQL> archive log list;                                                                                                                                                                         
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       /oracle/app/oracle/flash_recovery_area/archivelog
Oldest online log sequence     7777
Next log sequence to archive   7779
Current log sequence	       7779
SQL>

#从库状态：

SQL>  archive log list;                                                                                                                                                                        
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       /data/oracle/oradgdata/standby_archive
Oldest online log sequence     7778
Next log sequence to archive   0
Current log sequence	       7779
SQL>

最后问猫猫，怎么样才能彻底check下datagard主从数据一致，结果被猫猫美女一顿狂批，多看点datagard官方文档，别老问她，得自己去专研去总结。

哈哈，看来是得抽功夫去恶补下oracle datagard了。

[Oracledatagard]从库恢复之ORA-16032:parameterORA-07286:问题(二)