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!

How to set the time for ArchiveLog

AmiWApr 5 2019 — edited Apr 10 2019

I have changed ARCHIVE_LAG_TARGET to 3600 (which will archive logs at the least once an hour), correct?

However, I think I may have turned on archiving at certain time because the archiving takes place at 11:22am, 12:22pm, 1:22pm. Is there a way to reset the time to top of the hour - 1:00pm, 2:00pm, 3:00pm, etc?

Can I run alter system archive log current; at the top of the hour to reset the time?

Thank you.

This post has been answered by top.gun on Apr 6 2019

Jump to Answer

Added on Apr 5 2019

#general-database-discussions

5 comments

3,390 views