Re: what happens when you do shutdown abort while a tablespace is in backup mode

REM end_hot_backup.sql
REM this will produce the DDL needed to end backup on datafiles in backup mode
REM the script must be executed by a user with the alter database sys priv
set termout off heading off feedback off verify off trimspool on set linesize 255 pagesize 0 serveroutput on size 1000000 spool end_any_backup.sql
select 'ALTER DATABASE DATAFILE '''||name||''' END BACKUP;'   From v$datafile
 where file# in (select file# from v$backup where status='ACTIVE') /
spool off
rem @end_any_backup.sql; -- uncomment at your own risk

hth,

Paul

Andrei wrote:

> ..or if db crashes..
> database won't startup......
> is there are any way to recover besides recovering from backups?
>
> thanx.
> ---------------
> In case I forgot to mention:
> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
  Received on Tue Apr 24 2001 - 18:19:22 CDT