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!

Forcing log switch every minute.

595718Apr 12 2008 — edited Apr 14 2008

Hi,
I want to force a log switch every one minute how can i do it?
What should be the value of fast_start_mttr_target?
Does a checkpoint force a log switch?
Do i need to only reduce the size of redo log to a small size?
How can i make sure that a log switch will happen after a particular time period for ex. 1Minute,2 minute.

I want to force a log switch every minute because i want to send the archive redo log to standby database so that not more than 1 minute changes in database are lost. I am using 10g R2 on windows 2003 server.

I am unable to find a solution. Any help?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 12 2008

Added on Apr 12 2008

#general-database-discussions

5 comments

2,865 views