If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Sync redo log change to standby

I have changed the redo log configuration on my primary database and wish to sync the changes with the standby.

I can add/drop using alter database but get "ORA-01623: log 4 is current log for thread 1 - cannot drop" when trying to run these commands on log group 4.

I assume this is because log group 4 was the current log when the standby was created, but as it is a standby I don't care. I cannot switch logfiles as I cannot open the database to run a switch logfiles command!

Thanks for the tip
My database version is 9.2.0.1 but is standard edition (no dataguard automation). Oracle docs on the subject simply say use the add/drop options mentioned in my original post.

Queries on v$log show group 4 as current which would have been true in the primary db. The alter database commands are still checking this status even though the database is a standby and I can't find a command to alter this without opening the database.