Wednesday 11 January 2012

Oracle : Identifying last SCN available that has been backed up

select next_change#-1 last_change, br.* from V$BACKUP_REDOLOG br order by first_change# desc