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

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?
>
> 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 - 06:36:27 CDT