Home » RDBMS Server » Server Administration » Fail to startup Database.... urgent!!!
Fail to startup Database.... urgent!!! [message #53460] Sun, 22 September 2002 22:40 Go to next message
Teik Choon
Messages: 1
Registered: September 2002
Junior Member
I try to startup a database but get failed.. I didn't provide what's the error that couse the error ORA-00312. What should I do next?

I am running oracle 8i in Sun Solaris,

SVRMGR> startup
ORACLE instance started.
Total System Global Area 186740720 bytes
Fixed Size 69616 bytes
Variable Size 104570880 bytes
Database Buffers 81920000 bytes
Redo Buffers 180224 bytes
Database mounted.
ORA-16038: log 3 sequence# 13506 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 3 thread 1: '/appl/oracle/oradata/devl/redo03.log'
ORA-00312: online log 3 thread 1: '/oradata/disk0/devl/redo03.log'
SVRMGR>

Thanks for help..

Report message to a moderator

Re: Fail to startup Database.... urgent!!! [message #53476 is a reply to message #53460] Mon, 23 September 2002 11:23 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Make sure log_archive_dest (where your archive logs are being written to) isn't full.

Report message to a moderator

Re: Fail to startup Database.... urgent!!! [message #54771 is a reply to message #53460] Wed, 04 December 2002 05:15 Go to previous messageGo to next message
mohan babu
Messages: 1
Registered: December 2002
Junior Member
iam getting below error in windows 2000.so plese give an alternative...

ORACLE instance started.

Total System Global Area 143727516 bytes
Fixed Size 453532 bytes
Variable Size 109051904 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-16038: log 3 sequence# 22 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 1: 'C:ORACLEORADATAMBADBAREDO03.LOG'

Report message to a moderator

Re: Fail to startup Database.... urgent!!! [message #54775 is a reply to message #53460] Wed, 04 December 2002 05:45 Go to previous message
psmyth
Messages: 81
Registered: October 2002
Member
looks like you haven't specified the archive log parameters correctly in the init.ora file:

make sure you have the following in your init.ora file:
log_archive_start = TRUE
log_archive_dest = "c:oracle...."
log_archive_format = arch%s_%t.arc

I don't know where you plan to locate your log_archive_dest, so you'll need to edit that parameter appropriately.

Try that and get back to us if you get more interesting errors ;-)

Report message to a moderator

Previous Topic: Difference between Session and Instance???
Next Topic: Problems with Oracle 8.1.7.3.0 optimizer (Sun Solaris)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:45:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.