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
Last activity: Jan 18, 2024, 11:57 AM