Get location of REDO log files

    The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as they occur. 
    Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure.
Get location of REDO log files:

SQL> select current_scn from v$database;