Re: TDP for SAP R/3 - Tablespaces in BEGIN BACKUP status after ba ckup failes
2002-05-14 09:31:52
Subject: |
Re: TDP for SAP R/3 - Tablespaces in BEGIN BACKUP status after ba ckup failes |
From: |
"Hooft, Jeroen" <Jeroen.Hooft AT ATOSORIGIN DOT COM> |
Date: |
Tue, 14 May 2002 15:31:32 +0200 |
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 (frank AT ibi.co DOT za)
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: TDP for SAP R/3 - Tablespaces in BEGIN BACKUP status after ba ckup failes,
Hooft, Jeroen <=
|
|
|