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!

Reducing size of Oracle redo log file

608069Mar 2 2010 — edited Mar 2 2010

Hi
Our production server running on Oracle 10g 10.2.0.3.0 on linux 64 bit, Size of our redo log is 100mb, We are creating Disaster recovery strategy. On the event of media failure, we will be using RMan to recover database.
Due to size of redo log (100 mb), we can loose 80-90 mb data.

Do i reduce the redolog size to reduce the risk of loosing data or switch log file every two hours or something.

What can be the correct way to go as i do not want to reduse the performance of Production database.

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2010

Added on Mar 2 2010

#general-database-discussions

3 comments

723 views