Query For Redo log Files

Onur ARDAHANLI

1 year 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;