启动DG备库到open状态报错ORA-10458，ORA-01152

jiawang

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-10458: standby database requiresrecovery

ORA-01152: file 1 was not restored from asufficiently old backup

ORA-01110: data file 1:

'/u01/app/oracle/oradata/ORCL_STD/datafile/o1_mf_system_08t05rs9_.dbf'

报错原因：归档日志不可用，

查看alter日志

[oracle@strong_dg trace]$ tail -30alert_orcl.log

Creating archive destination file :/u01/app/arch/1_7_972555957.dbf (5281 blocks)

Thu Apr 12 17:23:12 2018

Standby crash recovery need archive log forthread 1 sequence 7 to continue.

Please verify that primary database istransporting redo logs to the standby database.

Wait timeout: thread 1 sequence 7

Standby Crash Recovery aborted due to error16016.

Errors in file/u01/app/oracle/diag/rdbms/orcl_std/orcl/trace/orcl_ora_6134.trc:

ORA-16016: archived logfor thread 1 sequence# 7 unavailable

Recovery interrupted!

Completed Standby Crash Recovery.

Signalling error 1152 for datafile 1!

Errors in file/u01/app/oracle/diag/rdbms/orcl_std/orcl/trace/orcl_ora_6134.trc:

ORA-10458: standby database requiresrecovery

ORA-01152: file 1 was not restored from asufficiently old backup

ORA-01110: data file 1: '/u01/app/oracle/oradata/ORCL_STD/datafile/o1_mf_system_08t05rs9_.dbf'

ORA-10458 signalled during: alter databaseopen...

Thu Apr 12 17:23:14 2018

Creating archive destination file :/u01/app/arch/1_7_972555957.dbf (5281 blocks)

Thu Apr 12 17:28:57 2018

Creating archive destination file :/u01/app/arch/1_10_972555957.dbf (371 blocks)

Thu Apr 12 17:28:57 2018

Creating archive destination file :/u01/app/arch/1_9_972555957.dbf (477 blocks)

Thu Apr 12 17:28:57 2018

Creating archive destination file :/u01/app/arch/1_8_972555957.dbf (76 blocks)

Thu Apr 12 17:28:59 2018

Creating archive destination file :/u01/app/arch/1_11_972555957.dbf (371 blocks)

Thu Apr 12 17:28:59 2018

Creating archive destination file :/u01/app/arch/1_12_972555957.dbf (7 blocks)

Thu Apr 12 17:28:59 2018

Creating archive destination file :/u01/app/arch/1_13_972555957.dbf (157 blocks)

解决办法：确认备库是否存在归档目录，是否有oracle权限。

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /u01/app/arch

Oldest online log sequence     13

Next log sequence to archive   0

Current log sequence           15

SQL>

[oracle@strong_dg ~]$ cd /u01/app/

[oracle@strong_dg app]$ ll

总用量 0

drwxr-xr-x 2 root   root      6 4月  12 15:13 arch

drwxrwxr-x 9 oracle oinstall 122 4月  12 15:12 oracle

drwxrwx--- 5 oracle oinstall  89 4月  12 12:06 oraInventory

[root@strong_dg ~]# chown -Roracle:oinstall /u01/app/arch

SQL> alter database open;

Database altered.

SQL> selectname,open_mode,database_role,switchover_status from v$database;

NAME     OPEN_MODE           DATABASE_ROLE    SWITCHOVER_STATUS

--------- ------------------------------------ --------------------

ORCL     READ ONLY            PHYSICALSTANDBY NOT ALLOWED