--
-- 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;
|