Home » RDBMS Server » Server Administration » database cannot startup (oracle database 10g linux)
database cannot startup [message #348245] Tue, 16 September 2008 03:47 Go to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
hi
in our institution suddenly cannot startup database.
but database mounted, cannot opened
database startup fails with error
ora-16038,ora-19809,ora-00312

following error displayed


Database mounted.
ORA-16038: log 1 sequence# 47 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/oradata2/data1/dbase/redo03.log'

send the solution pls
Re: database cannot startup [message #348249 is a reply to message #348245] Tue, 16 September 2008 03:48 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Increase your FLASH_RECOVERY_AREA size.
alter system set db_recovery_file_dest_size='xx g';

[Updated on: Tue, 16 September 2008 03:48]

Report message to a moderator

Previous Topic: ASM Migration
Next Topic: Unable to startup or shutdown the database
Goto Forum:
  


Current Time: Sun Jul 07 23:27:46 CDT 2024