Re: Standard Edition standby database

Mark,

Thank you for replying to my questions. I did not fill my disk. Permissions are not the issue either since I can continue writing archivelogs and normal processing after issuing the "alter database commit..." command fails. I'm inclined to believe this is an issue with SE not being able to use the log_archive_dest_n parameters rather than an actual problem with the archivelogs.

Sandy

On 7/11/07, Bobak, Mark <Mark.Bobak_at_il.proquest.com> wrote:
>
> 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_at_il.proquest.com
> www.proquest.com
> www.csa.com
>
> *ProQuest...*Start here.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l