Re: Instance won't start up after powerfail

"Stan Brown" <stanb_at_panix.com> wrote in message news:c75h0g$jvp$1_at_reader2.panix.com...
>
> I've got an Oracle V7 (7.3.4.5.0 ) instance on HP-UX 10.20 that had the
> power droped to it, and now it won't start up.
>
> Here's what I get when I try to start it from svrmgrl:
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> shutdown abort
> ORACLE instance shut down.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 769118400 bytes
> Fixed Size 38984 bytes
> Variable Size 31635576 bytes
> Database Buffers 737280000 bytes
> Redo Buffers 163840 bytes
> Database mounted.
> ORA-01113: file 6 needs media recovery
> ORA-01110: data file 6: '/db_local3/oradata/pwhse/tables/trend.dbf'
>
> So, it appears that one datafile was in backup mode, right?
>
> So,
>
> SVRMGR> select * from v$backup ;
> FILE# STATUS CHANGE# TIME
> ---------- ------------------ ---------- --------------------
> 1 NOT ACTIVE 131699818 04/27/04 05:28:15
> 2 NOT ACTIVE 131697427 04/27/04 05:21:47
> 3 NOT ACTIVE 131699938 04/27/04 05:28:35
> 4 NOT ACTIVE 131700997 04/27/04 05:31:38
> 5 NOT ACTIVE 130164708 04/24/04 07:19:07
> 6 ACTIVE 131701051 04/27/04 05:31:48
> 7 NOT ACTIVE 131656545 04/27/04 03:29:13
> 8 NOT ACTIVE 131656684 04/27/04 03:29:34
> 9 NOT ACTIVE 131656575 04/27/04 03:29:17
> 10 NOT ACTIVE 131676065 04/27/04 04:23:15
> 10 rows selected.
>
> The last time something like this happened, I made the situation far worse
> by not understanding the correct action to take.
>
> So, I'm asking for some advice here.
>
> Can I just do something like this?
>
> alter datafile 6 end backup
>

Hi Stan,

Datafile 6 is currently in backup mode so simply mount the database, issue the command 'alter database datafile 6 end backup;' (you forgot the database keyword) and hopefully you should be able to then open the database.

Good luck !!

Richard Received on Mon May 03 2004 - 08:39:39 CDT