Instance won't start up after powerfail
Stan Brown
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
Richard Foote
news:c75h0g$jvp$1...@reader2.panix.com...
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
Stan Brown
>Hi Stan,
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?
Dorian Büttner
or '/db_local3/oradata/pwhse/tables/trend.dbf'
?
Stan Brown
Must be the later. The first did not work.
I'll try the 2nd right after my backup finishes.
Thanks!
Stan Brown
For the record, that was it.
Thanks to everyne!
Howard J. Rogers
> In <c75lsu$p5g$05$1...@news.t-online.com> "Dorian Büttner" <dorian....@gmx.de> writes:
>
>
>>is it data file 6
>>or '/db_local3/oradata/pwhse/tables/trend.dbf'
>>?
>
>
>
> For the record, that was it.
>
> Thanks to everyne!
Also for the record, Richard's original advice was 100% correct for
version 8.0 and upwards (file number alone is sufficient there).
Clearly, version 7 (which, like me, he probably doesn't have a museum
capable of running) was a bit different!
Glad you got it sorted this time Stan without hassle! (PS... ever
thought of buying a UPS??)
Regards
HJR
Stan Brown
>Stan Brown wrote:
It's on a 75KVA industrial UPS, which has 2 feeds from 2 different buses,
and it's powered by the 125VDC station bateries that control the switchgear
in the same location.
But hardware cannot overcome incompetence in people. Putting the UPS in
"bypass", and ifnoring the "UPS not in sync" alarm on the computer screen,
and opening random breakers without authiriztion can overcome even the best
hardware.
Srry, I'm stilll upset about this!
Joel Garry
http://groups.google.com/groups?selm=6dnn80%24q7h%241%40pebble.ml.org&oe=UTF-8&output=gplain
And of course, the loudest sound I ever heard, including '70's rock
concerts, was a 1 Farad capacitor:
http://groups.google.com/groups?selm=68wNsB1w165w%40netlink.cts.com&oe=UTF-8&output=gplain
I'm _still_ laughing about it.
jg
--
@home.com is bogus.
http://news.bbc.co.uk/2/hi/technology/3672887.stm
Ed Stevens
Did I read that right? 1 Farad? It's been a loooong time since I
studied that stuff ... (like, in jr. high in the early '60s when I was
interested in ham radio and you pretty much had to roll your own) ...
but aren't capacitors usually measured in micro- and pico-farads?
That would make a 1 Farad .... crikeys, I don't even want to think
about it!
But reading the story made me think about our whole approach to UPS
protection in the data center -- for which I am decidedly *NOT*
responsible for. In this case, the server in question would have been
much better served sitting on a little APC unit costing a couple of
hundred bucks. By extension, I wonder if it wouldn't be less
expensive up front as well as more flexible and more powerful in the
long run to eliminate the single point of failure, massive data center
wide UPS systems and just put each server on its own little unit.
I'm also reminded of the data center that had a big diesel powered
backup system that they tested religiously by running the data center
on it one weekend every month. Then, when they actually lost utility
power and went to start the backup they realized that the electric
starter motor ran on .... you guesed it!
Stan Brown
>http://groups.google.com/groups?selm=6dnn80%24q7h%241%40pebble.ml.org&oe=UTF-8&output=gplain
OK, those war stories helped me feel less lonely :-)