Set Feedback Off
Set Echo Off
Set Heading Off
Set Term Off

Column Instance New_Value _Instance NoPrint
SELECT 'ORL_' || name Instance FROM v$database;

spool &&_instance..txt;

-- Redo Log Active Status

select f.status, f.member, l.bytes/1024 bytes, l.status
from   v$logfile f, v$log l
where  f.group# = l.group#;

spool off;
Set Feedback On
Set Echo On
Set Heading On
Set Term On

exit;