| Need Help [message #58735] |
Mon, 29 September 2003 04:00  |
S.Rajesh Kannan
Messages: 26
Registered: September 2003
|
Junior Member |
|
|
Hi all,
I have observed the following error in the alert_sid.log in bdump directory.
Because of this, i am unable to enter sqlplus. The processes was keep on increasing.
start time of database : Mon Sep 29 12:15:30 2003
Mon Sep 29 13:41:30 2003
ORACLE Instance SID - Can not allocate log, archival required
Mon Sep 29 13:41:30 2003
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 235
All online logs needed archiving
Current log# 1 seq# 234 mem# 0: REDO_LOG_PATH/redo03.log
How to rectify this?.
Thanks in Advance,
S.Rajesh Kannan.
|
|
|
|
| Re: Need Help [message #58745 is a reply to message #58735] |
Mon, 29 September 2003 07:10  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Rajesh,
Looks like your archivelog filesystem is full(ie LOG_ARCHIVE_DEST) . You will need to move the older archive files to a different location immediately. LogWriter cannot perform a log switch onto a online logfile that hasnt been archived yet.
-Thiru
|
|
|
|
| Re: Need Help [message #58768 is a reply to message #58735] |
Mon, 29 September 2003 23:34 |
dba2rescue
Messages: 5
Registered: September 2003
|
Junior Member |
|
|
Hi Rajesh,
SQL> show parameter log_archive_dest
SQL> show parameter log_archive_start
Check the location of Log_archive_dest for necessary space.
Check if log_archive_start=TRUE or not. if the value is false, that means that automatic archival is not enabled and hence the server is hanging. If the value is false you can set it to true.
Hope this solves the problem.
Regards,
DBA2RESCUE
|
|
|
|
| Re: Need Help [message #58800 is a reply to message #58745] |
Wed, 01 October 2003 01:29 |
S.Rajesh Kannan
Messages: 26
Registered: September 2003
|
Junior Member |
|
|
Hi all,
I had problem with REDO Log file. I have created two more redo log file with bigger size. I restarted the my database. Now it's working fine. Also I have taken backup of archive log and redo log.
Great thanks for all.
Regards
S.Rajesh Kannan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
