Sample Header Ad - 728x90

How can I use RMAN to show if there are archive logs that need to backed up?

0 votes
5 answers
33161 views
My main concern is knowing if the Oracle Archive Logs haven't been backed up in a while because something is broken that I may not know about. When I query v$log it appears to be good with First_Time being very recent. I would think v$log wouuld have lots of rows if the logs had not been backing up. SELECT * FROM v$log; Shows only a few, two say current (four returned). select * from v$log_history order by FIRST_TIME desc; Shows lots.
Asked by johnny (612 rep)
Oct 9, 2017, 02:49 PM
Last activity: Jan 18, 2024, 11:57 AM