RE: Data Guard Configuration

  • From: Scott Canaan <srcdco@xxxxxxx>
  • To: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • Date: Wed, 29 May 2013 15:18:21 -0400

This is what I keep getting:
SQL> startup
ORACLE instance started.

Total System Global Area 409251840 bytes
Fixed Size 2228744 bytes
Variable Size 264244728 bytes
Database Buffers 134217728 bytes
Redo Buffers 8560640 bytes
Database mounted.
ORA-00314: log 5 of thread 1, expected sequence# 35 doesn't match 0
ORA-00312: online log 5 thread 1:
'/oracle/data/LNX8TEST/mirror_files/redo05b.log'
ORA-00314: log 5 of thread 1, expected sequence# 35 doesn't match 0
ORA-00312: online log 5 thread 1: '/oracle/data/LNX8TEST/redo05a.log'


SQL>

Scott Canaan '88 (srcdco@xxxxxxx<mailto:Scott.Canaan@xxxxxxx>)
(585) 475-7886 - work           (585) 339-8659 - cell
"Life is like a sewer, what you get out of it depends on what you put into it." 
- Tom Lehrer.

From: Andrew Kerber [mailto:andrew.kerber@xxxxxxxxx]
Sent: Wednesday, May 29, 2013 3:14 PM
To: Scott Canaan
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Data Guard Configuration

In my experience, if you are fairly confident that you followed the steps 
properly, the issue is almost always network/tns configuration.  Can you tell 
us what error you are getting in the alert log (or broker log if you are using 
dataguard broker)?  I have admittedly spent hours on issues that where simple 
typos in the log_archive_dest_2 setting.

On Wed, May 29, 2013 at 12:44 PM, Scott Canaan 
<srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>> wrote:
rk.  It seems simple enough, but I'm doing something very basic, wrong.  I 
can't figure it out and Oracle support has been useless.  Does anyone have a 
document on how to configure Data Guard, step-by-step?  I'm looking for 
something very basic, none of the fancy options.  I'd just like to see it work.
   We are Oracle 11.2.0.3 on Red Hat 6.  I have a sandbox that I can play in.  
I can delete both of the databases and start over.
Thank you,

Scott Canaan '88 
(srcdco@xxxxxxx<mailto:srcdco@xxxxxxx><mailto:Scott.Canaan@xxxxxxx<mailto:Scott.Canaan@xxxxxxx>>)
(585) 475-7886<tel:%28585%29%20475-7886> - work
"Life is like a sewer, what you get out of it depends on what you put into it." 
- Tom Lehrer.


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




--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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


Other related posts: