备库DUPLICATE后启用同步，开启ADG打开数据库时报错：ORA-10458

最新推荐文章于 2025-05-06 16:38:43 发布

原创

最新推荐文章于 2025-05-06 16:38:43 发布 · 1k 阅读

1 ·

CC 4.0 BY-SA版权

备库DUPLICATE后启用同步，开启ADG打开数据库时报错：ORA-10458

SQL> select status from v$instance;
    STATUS
    ------------
    MOUNTED

    SQL> recover managed standby database using current logfile disconnect;
    Media recovery complete.
    SQL> 
    SQL> recover managed standby database cancel;
    Media recovery complete.
    SQL> 
    SQL> alter database open ;
    alter database open
    *
    ERROR at line 1:
    ORA-10458: standby database requires recovery
    ORA-01152: file 1 was not restored from a sufficiently old backup
    ORA-01110: data file 1: '+SDE_DATA/sdedg/datafile/system.283.984230107'
    SQL>

查看日志，发现所有主库的归档日志都没有被应用，手动恢复日志

    SQL> recover managed standby database

查看告警日志，发现错误

[oracle@sde1 trace]$ tail -f alert_sde1.log 
    FAL[client]: Failed to request gap sequence
     GAP - SCN range: 0x0e57.4d6ec257 - 0x0e57.4d6ec257
     DBID 2155281896 branch 984123832
    FAL[client]: All defined FAL servers have been attempted.
    ------------------------------------------------------------
    Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
    parameter is defined to a value that's sufficiently large
    enough to maintain adequate log switch information to resolve
    archivelog gaps.
    ------------------------------------------------------------
    Wed Aug 15 14:47:10 2018
    Recovery interrupted!
    Media Recovery failed with error 448
    Errors in file /u01/app/oracle/diag/rdbms/sdedg/sde1/trace/sde1_pr00_29797.trc:
    ORA-00283: recovery session canceled due to errors
    ORA-00448: normal completion of background process
    Slave exiting with ORA-283 exception

查看错误文件；

[oracle@sde1 ~]$ tail -fn200 /u01/app/oracle/diag/rdbms/sdedg/sde1/trace/sde1_pr00_29797.trc

里边有错误指示：

*** 2018-08-15 14:34:10.634
    Media Recovery add redo thread 2
    *** 2018-08-15 14:34:10.721 4320 krsh.c
    Media Recovery Waiting for thread 1 sequence 129
    Redo shipping client performing standby login

是日志文件没有被应用，查看备库的日志组文件，发现日志组过多，先删除过多的备库日志组，然后重建备库日志组

SQL> select group#,member,type from v$logfile;
        GROUP# MEMBER                                                       TYPE
    ---------- ------------------------------------------------------------ -------
             6 +SDE_FRA/redo06.log                                          ONLINE
             5 +SDE_FRA/redo05.log                                          ONLINE
             2 +SDE_FRA/redo02.log                                          ONLINE
             1 +SDE_FRA/redo01.log                                          ONLINE
             3 +SDE_DATA/sdedg/onlinelog/group_3.284.984232869              ONLINE
             3 +data                                                        ONLINE
             4 +SDE_DATA/sdedg/onlinelog/group_4.302.984232871              ONLINE
             4 +data                                                        ONLINE
             7 +SDE_DATA/sdedg/onlinelog/group_7.301.984232871              ONLINE
             8 +SDE_DATA/sdedg/onlinelog/group_8.281.984232871              ONLINE
             9 +SDE_DATA/sdedg/onlinelog/group_9.280.984232871              ONLINE

        GROUP# MEMBER                                                       TYPE
    ---------- ------------------------------------------------------------ -------
            10 +SDE_DATA/sdedg/onlinelog/group_10.300.984232873             ONLINE
            11 +SDE_DATA/sdedg/onlinelog/group_11.299.984232873             ONLINE
            12 +SDE_DATA/sdedg/onlinelog/group_12.271.984232873             ONLINE
            13 +SDE_DATA/sdedg/onlinelog/group_13.274.984232873             ONLINE
            14 +SDE_DATA/sdedg/onlinelog/group_14.284.984230143             STANDBY
            15 +SDE_DATA/sdedg/onlinelog/group_15.284.984230145             STANDBY
            16 +SDE_DATA/sdedg/onlinelog/group_16.284.984230147             STANDBY
            17 +SDE_DATA/sdedg/onlinelog/group_17.284.984230149             STANDBY
            18 +SDE_DATA/sdedg/onlinelog/group_18.284.984230151             STANDBY
            19 +SDE_DATA/sdedg/onlinelog/group_19.284.984230153             STANDBY
            20 +SDE_DATA/sdedg/onlinelog/group_20.284.984230155             STANDBY

        GROUP# MEMBER                                                       TYPE
    ---------- ------------------------------------------------------------ -------
            21 +SDE_DATA/sdedg/onlinelog/group_21.284.984230157             STANDBY
            22 +SDE_DATA/sdedg/onlinelog/group_22.284.984230159             STANDBY
            23 +