Hi all,
I'm trying to drop standby logfiles on primary database (other database that I'm configuring the DG).
The members of the standby log groups don't exists on file system.
Somebody have deleted these files. Its old configuration where the files were in file system. Now they are in ASM.
When I try to drop the standby logfiles I got the following error:
SQL> alter database clear logfile group 7;
alter database clear logfile group 7
*
ERROR at line 1:
ORA-19528: redo logs being cleared may need access to files
SQL> select * from v$logfile order by 1;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------------------------------------- ---
1 ONLINE +REDO1/proj/onlinelog/group_1.256.340558657 NO
1 ONLINE +REDO2/proj/onlinelog/group_1.256.340558659 NO
2 ONLINE +REDO1/proj/onlinelog/group_2.257.340558879 NO
2 ONLINE +REDO2/proj/onlinelog/group_2.259.340558879 NO
3 ONLINE +REDO1/proj/onlinelog/group_3.258.340558707 NO
3 ONLINE +REDO2/proj/onlinelog/group_3.257.340558709 NO
4 ONLINE +REDO2/proj/onlinelog/group_4.258.340558713 NO
4 ONLINE +REDO1/proj/onlinelog/group_4.259.340558711 NO
5 ONLINE +REDO2/proj/onlinelog/group_5.260.340558965 NO
5 ONLINE +REDO1/proj/onlinelog/group_5.260.340558963 NO
6 ONLINE +REDO1/proj/onlinelog/group_6.261.340558967 NO
6 ONLINE +REDO2/proj/onlinelog/group_6.261.340558967 NO
7 STANDBY /oracle/proj/onlinelog2/redo_702.log NO
7 STANDBY /oracle/proj/onlinelog1/redo_701.log NO
8 STANDBY /oracle/proj/onlinelog2/redo_802.log NO
8 STANDBY /oracle/proj/onlinelog1/redo_801.log NO
9 STANDBY /oracle/proj/onlinelog2/redo_902.log NO
9 STANDBY /oracle/proj/onlinelog1/redo_901.log NO
10 STANDBY /oracle/proj/onlinelog1/redo_1001.log NO
10 STANDBY /oracle/proj/onlinelog2/redo_1002.log NO
20 rows selected.
SQL> select * from v$standby_log order by 1;
GROUP# DBID THREAD# SEQUENCE# BYTES USED ARC STATUS FIRST_CHANGE# FIRST_TIM LAST_CHANGE# LAST_TIME
---------- ------------ ---------- ---------- ---------- ---------- --- ---------- ------------- --------- ------------ ---------
7 UNASSIGNED 0 0 104854601 512 YES UNASSIGNED 0 0
8 UNASSIGNED 0 0 104854601 512 YES UNASSIGNED 0 0
9 UNASSIGNED 0 0 104854601 512 YES UNASSIGNED 0 0
10 UNASSIGNED 0 0 104854601 512 YES UNASSIGNED 0 0
What can I do to drop these reference?
Any other solution instead of edit the controlfile and stop/start tghe database?
thank you!!!!