Hi Ajay,
It seems that all your log files are full and in the process of or waiting
to be archived. If you have an unusual amount of transactions you can just
wait for a while and your transactions should go through. If it's a normal
amount of activity you should consider either adding more redo logs or
recreating the ones you have with larger values.
This can also be caused by setting your init.ora parameter
log_archive_start = true
when archiving hasn't been initialized after database creation. Check to
see if you are in archive log mode by using:
select * from v$database;
If archiving has not been activated you must shutdown the database then
start it up and mount it without opening and start archiving.
Hope this didn't annoy Alex and it helps you.
-Rocky
- Ajay Khandelwal <ajay_at_tems.com> wrote:
> Hi All,
> I have this problem ,
> while trying to insert a record using sqlplus it just gets hanged .When
> i
> tried to look into trace it says
>
> "
> Thread 1 cannot allocate new log, sequence 5
> All online logs needed archiving
> Current log# 3 seq# 4 mem# 0: C:\ORACLE\ORADATA\AJAY\REDO01.LOG
> "
>
> I got a message in between saying oracle is not able to archive log
> file.
> I have checked the disk space , looks okay .
>
> Can anyone help me why is this happening .
>
> -Ajay
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ajay Khandelwal
> INET: ajay_at_tems.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
Received on Wed Jan 03 2001 - 14:49:34 CST
