Home » RDBMS Server » Server Administration » ORA-16014
ORA-16014 [message #244778] Thu, 14 June 2007 01:51 Go to next message
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
Re: ORA-16014 [message #244779 is a reply to message #244778] Thu, 14 June 2007 01:52 Go to previous messageGo to next message
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
Re: ORA-16014 [message #244780 is a reply to message #244778] Thu, 14 June 2007 01:57 Go to previous messageGo to next message
rtskrajan
Messages: 43
Registered: March 2007
Member
Thank you Verymuch..
But i need any practical Solutions...

Re: ORA-16014 [message #244814 is a reply to message #244780] Thu, 14 June 2007 03:06 Go to previous messageGo to next message
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

Re: ORA-16014 [message #244822 is a reply to message #244778] Thu, 14 June 2007 03:43 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
check the archive log location by issuing:
Archive log list
Re: ORA-16014 [message #244827 is a reply to message #244822] Thu, 14 June 2007 03:58 Go to previous messageGo to next message
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....
Re: ORA-16014 [message #244830 is a reply to message #244827] Thu, 14 June 2007 04:21 Go to previous messageGo to next message
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
Re: ORA-16014 [message #244896 is a reply to message #244830] Thu, 14 June 2007 09:06 Go to previous message
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

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


Current Time: Fri Dec 06 15:13:16 CST 2024