Put tablespaces in backup mode

--
-- Sample script to generate start backup and end backup scripts 
-- for all tablespaces in the database
--

set pagesize 0 echo off feedback off verify off

spool BEGIN_BACKUP.sql

SELECT 'spool BEGIN_BACKUP.log'
FROM dual;

SELECT 'ALTER SYSTEM SWITCH LOGFILE;'
FROM dual;

SELECT 'ALTER TABLESPACE ' || tablespace_name || ' BEGIN BACKUP;'
FROM dba_tablespaces;

SELECT 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE;'
FROM dual;

SELECT 'spool off'
FROM dual;

SELECT 'EXIT;'
FROM dual;

spool off

spool END_BACKUP.sql

SELECT 'spool END_BACKUP.log'
FROM dual;

SELECT 'ALTER TABLESPACE ' || tablespace_name || ' END BACKUP;'
FROM dba_tablespaces;

SELECT 'ALTER SYSTEM SWITCH LOGFILE;'
FROM dual;

SELECT 'spool off'
FROM dual;

SELECT 'EXIT;'
FROM dual;

spool off

EXIT;