Oracle Database Discussions

Hi all,

i have trouble with standby logfiles in a database which is restored from standby database backup.

First some information:
- 2 Node RAC running Oracle Database 11.2.0.3.0 on Linux (LIVE)
- Data Guard running which applies logs on another 2 node rac which acts in standby mode (STANDBY)

A full backup is taking on STANDBY db. The backup will than be used on Test environment (same hardware as in LIVE and also a 2 node RAC) to restore the database.
Restore and recovery on Test system is working fine and database is up and running.

Now my problem:
The controlfile still contains information about the standby log files and i can't drop this with ALTER DATABASE DROP STANDBY LOGFILE because i do NOT have them in test system. The test system does not have a standby database, so there is no need for the standby logfiles.

If i try to delete the standby logfiles i get the following error:

SQL> alter database drop standby logfile group 206;
alter database drop standby logfile group 206
*
ERROR at line 1:
ORA-00313: open failed for members of log group 206 of thread 2
ORA-00312: online log 206 thread 2:
'+STBY_REDO2/stby/onlinelog/group_206.364.778300599'
ORA-17503: ksfdopn:2 Failed to open file
+STBY_REDO2/stby/onlinelog/group_206.364.778300599
ORA-15012: ASM file '+STBY_REDO2/stby/onlinelog/group_206.364.778300599'
does not exist
ORA-00312: online log 206 thread 2:
'+STBY_REDO1/stby/onlinelog/group_206.364.778300599'
ORA-17503: ksfdopn:2 Failed to open file
+STBY_REDO1/stby/onlinelog/group_206.364.778300599
ORA-15012: ASM file '+STBY_REDO1/stby/onlinelog/group_206.364.778300599'
does not exist


The main problem now is that my alert.log is growing up very fast. Every second i get a message in the log file that the files are missing. So after a few hours the alert.log is ~1GB in size.

Now my question:
How can i drop the standby logfiles from controlfile? Is it only possible by recreating the controlfile without the information about the standby logfiles?


Thanks to All
Thomas