Hi I found this on http://www.orafaq.com/faqdbabr.htm#BACKMODE
rem ----------------------------------------------------------------------- rem Filename: end_backup.sql rem Purpose: This script will create a file called end_backup_script.sql rem and run it to take all tablespaces out of backup mode. rem Author: Frank Naude ([EMAIL PROTECTED]) rem ----------------------------------------------------------------------- column cmd format a80 heading "Text" set feedback off set heading off set pagesize 0 spool end_backup_script.sql select 'alter tablespace '||a.tablespace_name||' end backup;' cmd from sys.dba_data_files a, sys.v_$backup b where b.status = 'ACTIVE' and b.file# = a.file_id group by a.tablespace_name / spool off set feedback on set heading on set pagesize 24 set termout on start end_backup_script.sql Regards, Jeroen -----Original Message----- From: Rupp Thomas (Illwerke) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 2:34 PM To: [EMAIL PROTECTED] Subject: TDP for SAP R/3 - Tablespaces in BEGIN BACKUP status after backup failes Hi TSM-ers, we backup our SAP servers (online) using TDP for SAP R/3. Yesterday our backup cancelled due to networking problems. Unfortunately all tablespaces remained in status BEGIN BACKUP. Is there a way to ensure that all tablespaces are reset to END BACKUP even when the backup fails? Kind regards Thomas Rupp Vorarlberger Illwerke AG MAIL: [EMAIL PROTECTED] TEL: ++43/5574/4991-251 FAX: ++43/5574/4991-820-8251 ---------------------------------------------------------------------------- -------------- Dieses eMail wurde auf Viren geprueft. Vorarlberger Illwerke AG ---------------------------------------------------------------------------- --------------
