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

Recovery in this case is unnecessary. Just check v$backup for datafiles with status ACTIVE, then 'alter database datafile <file#> end backup;' and 'alter database open;'

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 25 Apr 2001, Joe Kazimierczyk wrote:



> If tablespaces are in backup mode when a shutdown or crash

> occurrs, then upon startup you usually see something like

> 'file x.x needs media recovery'.  Recovery from backup is

> probably not needed.  Just do something like this, and you

> should be back to normal:

>

> startup mount

> alter database recover automatic database;

> alter database open;

>

> Andrei wrote:

> >

> > ..or if db crashes..

> > database won't startup......

> > is there are any way to recover besides recovering from backups?