Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: what happens when you do shutdown abort while a tablespace is in backup mode

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

From: Hieraklion <hieraklion_at_spray.fr>
Date: Wed, 25 Apr 2001 10:31:58 +0200
Message-ID: <3AE68B7E.741CC633@spray.fr>

"Bonjour" from Paris,

Drake solution is OK if you do not use Rman. If you use Rman, the backup is wrong (yoiu do not need to do the Drake manipulation because in Rman Hot Backup there is no alter tbs begin/end backup).

"Au revoir" from Paris
Hieraklion

Paul Drake a écrit :

> 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 Wed Apr 25 2001 - 03:31:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US