刚创建的物理备库在打开时可能会报 ORA-10458: standby database requires recovery 这个错，此时只要打开备库的日志恢复，让备库apply重做日志即可。

[oracle@n2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed May 25 09:52:17 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 630501376 bytes
Fixed Size 2255872 bytes
Variable Size 234882048 bytes
Database Buffers 390070272 bytes
Redo Buffers 3293184 bytes
Database mounted.
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '/oracle/db/oradata/orcl/system01.dbf'

SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open;

Database altered.

SQL>

ITPub博客

物理备库open ORA-10458

最新文章