SELECT X.GROUP#, MEMBER, SEQUENCE#, FIRST_CHANGE# FROM V$LOG X, V$LOGFILE Y WHERE X.GROUP# = Y.GROUP#;
otterremo una tabella di questo tipo:
GROUP# | MEMBER | SEQUENCE# | FIRST_CHANGE# |
1 | C:ORACLEORADATAGMIREDO01.LOG | 1276 | 423235480 |
2 | C:ORACLEORADATAGMIREDO02.LOG | 1277 | 423255541 |
3 | C:ORACLEORADATAGMIREDO03.LOG | 1278 | 423264408 |