OraFAQ Forum: Server Administration » database is not open

Home » RDBMS Server » Server Administration » database is not open

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database is not open [message #290022]

Thu, 27 December 2007 03:10

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

Report message to a moderator

Re: database is not open [message #290026 is a reply to message #290022]

Thu, 27 December 2007 03:16

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

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

Report message to a moderator

Re: database is not open [message #290038 is a reply to message #290035]

Thu, 27 December 2007 03:54

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

pratik123
Messages: 41
Registered: October 2007
Location: hyderabad

Member

THANKS BABU
MY PROBLEM IS SOLVE AS YOU SAY

Report message to a moderator

Re: database is not open [message #290051 is a reply to message #290022]

Thu, 27 December 2007 04:47

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;

Report message to a moderator

Re: database is not open [message #290052 is a reply to message #290022]

Thu, 27 December 2007 04:48

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Pratik use initialize Capital letter.

Report message to a moderator

Re: database is not open [message #290053 is a reply to message #290022]

Thu, 27 December 2007 04:54

pratik123
Messages: 41
Registered: October 2007
Location: hyderabad

Member

Ok Boss

Report message to a moderator

Previous Topic:	Tablespace management
Next Topic:	Permission is available but not workings ....?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 01:31:01 CST 2024