Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

oracle 10gr2 with windows 2003 error starting

438439Sep 25 2010 — edited Sep 25 2010

dear gurus,

2 months back i enable archive log in database enable in archive log mode. now i start facing problem of hard disk space. i cant exceed 2gb for flash recovery area.

all of sudden i notice the database not working properly when i try to startup it give me below error messages. can someone guideline me how to over come such issues and resolve it

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Sat Sep 25 10:24:26 2010

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> conn sys/sys as sysdba
Connected to an idle instance.
SQL> startup;
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1292060 bytes
Variable Size 494930148 bytes
Database Buffers 113246208 bytes
Redo Buffers 2899968 bytes
Database mounted.
ORA-16038: log 1 sequence# 697 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'

SQL>

kind regards
your student

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2010

Added on Sep 25 2010

#general-database-discussions

23 comments

1,450 views