OraFAQ Forum: Server Administration » ORA-16014: log 2 sequence# 80 not archived, no available destinations

Home » RDBMS Server » Server Administration » ORA-16014: log 2 sequence# 80 not archived, no available destinations (oracle application 10g,windows xp 64bit)

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

ORA-16014: log 2 sequence# 80 not archived, no available destinations [message #523365]

Sat, 17 September 2011 03:07

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

hello

when i connect to my database i got this error.

SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16014: log 2 sequence# 80 not archived, no available destinations
ORA-00312: online log 2 thread 1:
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOON\REDO02.LOG'

..

so what can i do

Report message to a moderator

Re: ORA-16014: log 2 sequence# 80 not archived, no available destinations [message #523366 is a reply to message #523365]

Sat, 17 September 2011 03:15

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

This is the step following guide from ID 104918.1

[quote title=Quote:]

Edit:
Removed Metalink Content.

Please do not post the Metalink notes.
Mahesh Rajendran

[Updated on: Sat, 17 September 2011 05:59] by Moderator

Report message to a moderator

Re: ORA-16014: log 2 sequence# 80 not archived, no available destinations [message #523370 is a reply to message #523365]

Sat, 17 September 2011 04:29

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

This may give you a clue:

select dest_name,status,error from v$archive_dest;

Report message to a moderator

Re: ORA-16014: log 2 sequence# 80 not archived, no available destinations [message #523376 is a reply to message #523370]

Sat, 17 September 2011 06:27

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

i have solved the problem this error occur due to my FRA size is low so i increase its size so error solved
Quote:

SQL> select dest_name,status,error from v$archive_dest;

DEST_NAME
--------------------------------------------------------------------------------

STATUS ERROR
--------- -----------------------------------------------------------------
LOG_ARCHIVE_DEST_1
INACTIVE

LOG_ARCHIVE_DEST_2
INACTIVE

LOG_ARCHIVE_DEST_3
INACTIVE

DEST_NAME
--------------------------------------------------------------------------------

STATUS ERROR
--------- -----------------------------------------------------------------
LOG_ARCHIVE_DEST_4
INACTIVE

LOG_ARCHIVE_DEST_5
INACTIVE

LOG_ARCHIVE_DEST_6
INACTIVE

DEST_NAME
--------------------------------------------------------------------------------

STATUS ERROR
--------- -----------------------------------------------------------------
LOG_ARCHIVE_DEST_7
INACTIVE

LOG_ARCHIVE_DEST_8
INACTIVE

LOG_ARCHIVE_DEST_9
INACTIVE

DEST_NAME
--------------------------------------------------------------------------------

STATUS ERROR
--------- -----------------------------------------------------------------
LOG_ARCHIVE_DEST_10
ERROR ORA-19809: limit exceeded for recovery files

10 rows selected.

SQL> ALTER SYSTEM SET db_recovery_file_dest_size=4g scope=both;

System altered.

SQL> alter database open;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

Report message to a moderator

Re: ORA-16014: log 2 sequence# 80 not archived, no available destinations [message #523391 is a reply to message #523376]

Sat, 17 September 2011 09:37

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Good, for you next posts please How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Previous Topic:	Configure archivelog stored inside ASM diskgroup
Next Topic:	data growth

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 04:29:13 CST 2024