Home » RDBMS Server » Server Administration » database is not open
database is not open [message #290022] Thu, 27 December 2007 03:10 Go to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
hi to everyone

my database was running fine when i import dmp file its not completed and suddanaly shutdown istart is again when i connect to database its mounted but not open its show error

SQL> startup
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
ORA-16038: log 3 sequence# 241 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1:
'E:\ORACLE\PRODUCT\10.1.0\ORADATA\DATABASE\REDO03.LOG'

i check location of redolog3 is same place

please help me

thanks in advance
Re: database is not open [message #290026 is a reply to message #290022] Thu, 27 December 2007 03:16 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Please read here

I think space not available in your database drive. If you using RMAN Backup. Remove old backup's and archive log file.

Babu

[Updated on: Thu, 27 December 2007 03:17]

Report message to a moderator

Re: database is not open [message #290035 is a reply to message #290026] Thu, 27 December 2007 03:49 Go to previous messageGo to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
hi babu
there is sufficient space in database and i am not using rman backup

i allteady delete all archivefile but same problem
Re: database is not open [message #290038 is a reply to message #290035] Thu, 27 December 2007 03:54 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:

ORA-19809: limit exceeded for recovery files

Cause: The limit for recovery files specified by the
DB_RECOVERY_FILE_DEST_SIZE was exceeded.

Action: The error is accompanied by 19804. See message 19804 for further details.


http://dbataj.blogspot.com/2007/09/ora-19809-limit-exceeded-for-recovery.html

[Updated on: Thu, 27 December 2007 03:55]

Report message to a moderator

Re: database is not open [message #290050 is a reply to message #290022] Thu, 27 December 2007 04:44 Go to previous messageGo to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
THANKS BABU
MY PROBLEM IS SOLVE AS YOU SAY

Re: database is not open [message #290051 is a reply to message #290022] Thu, 27 December 2007 04:47 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Post the output of ,

archive log list;

show parameter db_recovery_file_dest;

select space_used, SPACE_LIMIT,SPACE_RECLAIMABLE from V$recovery_file_dest;


Re: database is not open [message #290052 is a reply to message #290022] Thu, 27 December 2007 04:48 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Pratik use initialize Capital letter.
Re: database is not open [message #290053 is a reply to message #290022] Thu, 27 December 2007 04:54 Go to previous message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
Ok Boss
Previous Topic: Tablespace management
Next Topic: Permission is available but not workings ....?
Goto Forum:
  


Current Time: Sat Dec 14 17:16:39 CST 2024