Re: Redo log files are there, why I can not start the database?

Verify the format of the log_archive_dest initialization parameter in your init<sid>.ora file. It should specify the full pathname to the directory that will hold your archived logs + the root of logs'name. This, together with the log_archive_format initialization parameter tell Oracle how to name and where to put the archived redo logs.

The ORACLE not available message indicates that the database instance is not up. You can go into SVRMGRL and issue the STARTUP command. If this doesn't work then it may be that some vestige of the instance was not cleaned up the last time it came down so, while still in SVRMGRL you can say SHUTDOWN ABORT (which always works but don't get the idea it's a good thing for normal practice!) then say STARTUP and you should be able to connect.

Mary
DBA
EDS "Wendy Chin" <wchin_at_corewest.com> wrote:

>Hi there,
 

>I'm a new DBA in NT4.0 and Oracle 8.03. I got an alert message saying, "can
>not find archive log file". Accidentally, NT server and Oracle server are
>restarted.... Anyway, I got the following message:
>ORA-01034;ORACLE not availabe
>ORA-09243; smsget; error attaching to SGA;
>OSD-04101; invalid SGA; SGA not initialized
>my questions are
>1) How can I get my database up running?
>2) What cause the database not be able to find the archivelog file?
>3) Why redo log files are not used, they are there in the directory and not
>lost?
>4)Why I can not run server manager? got an error of ORA -12203 TNS:unable to
>connect to destination when login as system/manager
 

>Thanks in advance
 

>wchin

Mary Travis
EDS
email: Mary.B.Travis_at_bridge.bellsouth.com Received on Fri Jan 16 1998 - 00:00:00 CST