Database Administration (MOSC)

MOSC Banner

v$log_history and v$archive_log showing future date

2 months before, server date updated accidently with future date and time. After few hours we resolved that issue and revert back to correct date and time.

Now, v$log_history and v$archive_log views showing future date archivelog sequence history now. but physically not available and unable to remove using rman those entries logically from the database.

Kindly help to remove for that. because can remove old entries using sysdate-1 like that. How we can do for future date entry.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center