open failed for members while creating standby via duplicate command
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: