Re: Instance won't start up after powerfail

From: Stan Brown <stanb_at_panix.com>
Date: Mon, 3 May 2004 14:17:46 +0000 (UTC)
Message-ID: <c75kaa$l61$1@reader2.panix.com>

In <vYrlc.9726$TT.2848_at_news-server.bigpond.net.au> "Richard Foote" <richard.foote_at_tbigpond.nospam.com> writes:

>"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.

Thanks for the help.

I must still have a syntax issue thought. Here's what I did:

svrmgrl
connect internal
startup mount;

Then I did:

alter database datafile 6 end backup

                        *

ORA-02236: invalid file name

So what should I do?

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

Received on Mon May 03 2004 - 09:17:46 CDT