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!

Switch redo logs hourly to provide point-in-time?

MSandicoJan 16 2014 — edited Jan 16 2014

Hi All,

Oracle 11G on Windows 2008 R2

I am learning the details of managing backups/restores and want to be able to provide a good point-in-time capability in case of a disaster. Is it good practice to schedule an hourly job that does ALTER SYSTEM SWITCH LOGFILE; ? Does this cause the redo log to be archived every hour so if I needed to restore, I know that I can at least restore to the previous hour (using the archive logs) and before?

Thanks in advance

This post has been answered by Aman.... on Jan 16 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2014

Added on Jan 16 2014

#general-database-discussions

9 comments

1,051 views