Skip to Main Content

Oracle Database Discussions

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!

Standby redo logs

DBA112Jul 18 2012 — edited Jul 18 2012
Dear Experts,

I've rebuilt a standby database using RMAN (Duplicate target database for standby) and have dropped standby redo logs that were cloned from primary (select * from v$standby_log shows 0 rows on standby) . Now, when trying to create standby redo logs, I get an error that group 1 already exists (ORA-01184: logfile group 1 already exists), select * from v$log; shows redo groups existing on standby.

Can someone please clarify the difference b/w V$LOG and V$STANDBY_LOG on a standby database? How do I create standby redo logs?

Thanks
This post has been answered by Hemant K Chitale on Jul 18 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 15 2012
Added on Jul 18 2012
6 comments
438 views