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!

ORA-16038: log 3 sequence# 102 cannot be archived

501173Mar 6 2007 — edited Mar 7 2007

Hello,

I am running oracle database 10g (10.2.0.1.0) on solaris 10 sparc.

I tried to connect to oracle database using sqlplus.
I got an error message:

ORA-00257: archiver error. Connect internal only, until freed.

Then I shutdown the database and started it up again.
The following error messages were displayed:

----------------------------------------------------------------
Total System Global Area 3187671040 bytes
Fixed Size 1982024 bytes
Variable Size 620757432 bytes
Database Buffers 2550136832 bytes
Redo Buffers 14794752 bytes
Database mounted.
ORA-16038: log 3 sequence# 102 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/u03/oradata/anno/redo03.log'
----------------------------------------------------------------

I have redo.log files on
- /u01/oradata/anno/redo01.log (500M)
- /u02/oradata/anno/redo02.log (500M)
- /u03/oradata/anno/redo03.log (500M)

and

db_recovery_file_dest='/u04/flash_recovery_area'
*.db_recovery_file_dest_size=31457280000

Could someone please help me to fix the problem?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2007

Added on Mar 6 2007

#general-database-discussions

13 comments

1,192 views