onlineredo1.sql

rem ======================================================================
rem Name:  onlineredo1.sql
rem Desc:  Online Redo Log
rem
rem ======================================================================

rem Set the general display parameters for the report:
set pages 55
set lines 79
set pause off
set echo off
set feed 1
set termout on

rem Capture the current date and time:
set termout off
col currdate new_value now
select to_char(sysdate, 'mm/dd/yy hh24:mi') currdate from dual;
set termout on

rem The title for the report:
ttitle left   "onlineredo1.sql" -
       center "Online Redo Log" -
       right  "Page:" sql.pno  skip 1 -
       right  "Date: " now  skip 3 

select * from v$logfile ;

spool onlineredo1.lst
/
spool off

exit