rem -----------------------------------------------------------------------
rem Filename:   end_backup2.sql
rem Purpose:    Take database data files out of backup mode
rem Notes: 	Run from QL*Plus (or SVRMGRL prior to 9i)
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

connect internal

spool end_backup2.log

select 'alter database datafile '''||f.name||''' end backup;'
from v$datafile f, v$backup b
where b.file# = f.file#
and  b.status = 'ACTIVE'
/

spool off

! grep '^alter' end_backup2.log >end_backup2.log2

@end_backup2.log2

! rm end_baclup.log
! rm end_backup.log2

exit