Query For Redo log Files

Onur ARDAHANLI

11 months ago

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;

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

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;

SQL> select * from v$log;

1	SQL> select * from v$log;