Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will be learning to Query Redo log Files and get detailed information about Redo Log files.
Querying Redo Log files;
1 2 3 4 5 6 | SQL> select * from v$logfile; GROUP STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE 3 ONLINE /u01/app/oracle/oradata/traindb/redo03.log NO 2 ONLINE /u01/app/oracle/oradata/traindb/redo02.log NO 1 ONLINE /u01/app/oracle/oradata/traindb/redo01.log NO |
Detailed information about Redo Log files;
1 | SQL> select * from v$log; |
