Instance won't start up after powerfail

From: Stan Brown <stanb_at_panix.com>
Date: Mon, 3 May 2004 13:21:21 +0000 (UTC)
Message-ID: <c75h0g$jvp$1@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

Or do I need to do somehting else?

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin

Received on Mon May 03 2004 - 08:21:21 CDT