RE: SCR: Hot DB backup script

From: Jason Salter <jason_at_seahorseNOSPAM.demon.co.uk>
Date: Mon, 11 Oct 1999 14:36:52 +0100
Message-ID: <iucBOGt8qiAf0D5K29PF72KkdPa5@4ax.com>

set serverout on size 1000000

declare

begin

FOR tspace IN (select tablespace_name

                    from dba_tablespaces )

LOOP   dbms_output.put_line('ALTER TABLESPACE '||tspace.tablespace_name||

' BEGIN BACKUP;');
  FOR dbfile IN (select file_name from dba_data_files

                 where tablespace_name = tspace.tablespace_name)

  LOOP
   dbms_output.put_line('!tar rvf /dev/rmt/0c '||dbfile.file_name); -- Or equivalent

  END LOOP;    dbms_output.put_line('ALTER TABLESPACE '||tspace.tablespace_name||

' END BACKUP;');
 END LOOP;
END;
/

Hope that helps!

Jason. Received on Mon Oct 11 1999 - 08:36:52 CDT