OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-16014

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

ORA-16014 [message #244778]

Thu, 14 June 2007 01:51

rtskrajan
Messages: 43
Registered: March 2007

Member

Hi experts,
When i am given this Coomand in SQL the following error displayed.

alter database open;
ora-16014:log 2 sequence#39 not archived, no available destinations:
ora-00312:online log 2 thread 1:

Can anybody help this...
Thanks in Advance

Report message to a moderator

Re: ORA-16014 [message #244779 is a reply to message #244778]

Thu, 14 June 2007 01:52

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

Senior Member
Account Moderator

ora-16014: log %s sequence# %s not archived, no available destinations
 *Cause:  An attempt was made to archive the named log, but the archive was
          unsuccessful. The archive failed because there were no archive log
          destinations specified or all destinations experienced debilitating
          errors.
 *Action: Verify that archive log destinations are being specified and/or
          take the necessary step to correct any errors that may have
          occurred.

Regards
Michel

Report message to a moderator

Re: ORA-16014 [message #244780 is a reply to message #244778]

Thu, 14 June 2007 01:57

rtskrajan
Messages: 43
Registered: March 2007

Member

Thank you Verymuch..
But i need any practical Solutions...

Report message to a moderator

Re: ORA-16014 [message #244814 is a reply to message #244780]

Thu, 14 June 2007 03:06

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

Senior Member
Account Moderator

Which practical solution for "Verify"?
Have a look under your server if your wire is not plug-out. This a practical solution. Does it help you?
What don't you understand in:

Quote:

Verify that archive log destinations are being specified and/or take the necessary step to correct any errors that may have occurred.

Regards
Michel

Report message to a moderator

Re: ORA-16014 [message #244822 is a reply to message #244778]

Thu, 14 June 2007 03:43

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

check the archive log location by issuing:
Archive log list

Report message to a moderator

Re: ORA-16014 [message #244827 is a reply to message #244822]

Thu, 14 June 2007 03:58

rtskrajan
Messages: 43
Registered: March 2007

Member

Thanks for your Valuable Reply....

Before that i got Solutions...

Alter database clear unarchived logfile group #

This is the one Practical Solution....

Report message to a moderator

Re: ORA-16014 [message #244830 is a reply to message #244827]

Thu, 14 June 2007 04:21

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

Senior Member
Account Moderator

There are so many "practical solution" and we don't know what you know.
So how to choose which ones we can post?

Regards
Michel

Report message to a moderator

Re: ORA-16014 [message #244896 is a reply to message #244830]

Thu, 14 June 2007 09:06

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

@rtskrajan

In case you are going for instance recovery you may risk losing some of your data by going for this statement.
As this makes your statement impractical to use.

You go for this statement only when
you want to Clear A Log File If It Has Become Corrupt.

--Girish

Report message to a moderator

Previous Topic:	Process in V$SESSION
Next Topic:	Ora-600[4194]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 12:47:41 CST 2024