Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Delete standby redo log from primary database

tad_csOct 31 2011 — edited Nov 1 2011
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!!!!
This post has been answered by mseberg on Oct 31 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2011
Added on Oct 31 2011
2 comments
3,340 views