Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

open failed for members while creating standby via duplicate command

edited Aug 20, 2021 9:14AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

Hi Everyone,

Facing this issue as the redo log file are not available in the standby database and we are not able to drop it either. Please help.

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME         NEXT_CHANGE# NEXT_TIME

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

         3          1        963   20971520        512          2 YES CLEARING            5.9712E+12 16-MAR-17            5.9712E+12 16-MAR-17

         4          1        964   20971520        512          2 YES CLEARING            5.9712E+12 16-MAR-17            5.9712E+12 16-MAR-17

         7          1        962   20971520        512          2 YES CLEARING            5.9712E+12 16-MAR-17            5.9712E+12 16-MAR-17

         6          1        966   20971520        512          2 YES CURRENT             5.9712E+12 16-MAR-17            5.9712E+12 16-MAR-17

         5          1        965   20971520        512          2 YES CLEARING            5.9712E+12 16-MAR-17            5.9712E+12 16-MAR-17

Standby redo logfile;

======================

Errors in file /d00/oracle/PRODERP/db/tech_st/11.2.0/admin/ERPCLONE_erprhel/diag/rdbms/erpclone_stby/ERPCLONE/trace/ERPCLONE_mrp0_892.trc:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center