Re: Standard Edition standby database

  • From: "Robert Bialek" <bialekr@xxxxxxxxx>
  • To: <sbecker6925@xxxxxxxxx>
  • Date: Thu, 12 Jul 2007 00:13:52 +0200

Hi Sandra,

the log_archive_dest_n is indeed limited to EE

Robert
  ----- Original Message ----- 
  From: Sandra Becker 
  To: oracle-l 
  Sent: Wednesday, July 11, 2007 10:53 PM
  Subject: 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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx
    www.proquest.com
    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: