RE: Standard Edition standby database

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <sbecker6925@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 11 Jul 2007 16:36:36 -0400

Hi Sandra,

 

At the risk of stating the obvious....have you checked that there is
space available in the archive log destination?  That the permissions
are correct?  If it's a mounted filesystem, that there's no problem w/
the mount?

 

In general, ORA-16014 means "I tried to archive the file, but failed".

 

Hope that helps,

 

-Mark

 

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
734.997.4059  or 800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxxxxx <mailto:mark.bobak@xxxxxxxxxxxxxxx> 
www.proquest.com <http://www.proquest.com> 
www.csa.com <http://www.csa.com> 

ProQuest...Start here. 

 

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sandra Becker
Sent: Wednesday, July 11, 2007 2:38 PM
To: oracle-l
Subject: Re: Standard Edition standby database

 

        I've got an SE standby database up and running and scripts
shipping the archivelogs and appying them automatically.  (Thanks, Tim
G.)  My latest problem is actually doing a manual switch.  I'm getting
the following errors: 

 

ORA-16014: log 1 sequence# 127 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u05/oradata/dbatst/redo01.log'
 

I've been researching Metalink, but haven't found an answer yet.
Apparently, a few people who have SE solved the problem, but they didn't
post the solution in the thread.  Since the posts are a couple of years
old, I don't know that I'll get a response back from the emails I sent
out.  Everything I've read so far in the docs assumes you're EE, not SE.


 

Does anyone on this list have a solution they would be willing to share?

 

Sandy



 

Other related posts: