rem *********************************************************************
rem * Copyright © Oracle-Consultant.co.uk 2001, all rights reserved     *
rem *                                                                   *
rem * Name     : backups.sql                                            *
rem * Synopsis : Shows online backup status of datafiles                *
rem * Source   : http://www.oracle-consultant.co.uk                     *
rem *                                                                   *
rem * Oracle-Consultant.co.uk are not responsible for any liability     *
rem * that may arise from the use of this code. Support can be obtained *
rem * by emailing script_support@oracle-consultant.co.uk                *
rem * Note: This script is best viewed in a fixed-width font.           *
rem *********************************************************************

column "File No"       format 9999        wrapped
column "File Name"     format a50         wrapped
column "Size (bytes)"  format 99999999999 wrapped
column "Backup Status" format a10         wrapped heading "Backup|Status"
column "Start Time"    format a18         wrapped

set linesize  1000
set pagesize  32000
set trimspool on

select   b.file#                                "File No"
,        d.name                                 "File Name"
,        d.bytes                                "Size (bytes)"
,        b.status                               "Backup Status"
,        to_char(b.time,'DD-MON-YY HH24:MI:SS') "Start Time"
from     v$backup   b
,        v$datafile d
where    b.file# = d.file#
order by b.time
/

column "File No"       clear
column "File Name"     clear
column "Size (bytes)"  clear
column "Backup Status" clear
column "Start Time"    clear