重庆思庄Oracle、Redhat认证学习论坛

标题: 启动DG备库到open状态报错ORA-10458，ORA-01152 [打印本页]

作者: jiawang 时间: 2018-4-12 17:38
标题: 启动DG备库到open状态报错ORA-10458，ORA-01152

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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)