Re: Data Guard Configuration

  • From: Martijn Bos <maboc@xxxxxxxx>
  • To: Scott Canaan <srcdco@xxxxxxx>
  • Date: Thu, 30 May 2013 09:10:55 +0200

That you get this message on your primary database suprises me a little. 
In my experience the primary is somewhat a 'normal' database with an extra 
remote archive_log destination.

Do I understand correctly that these database reside on the same host? My first 
guess (always my worst), is that somehow the redolog files are mixed up/ used 
by both databases.

Problems I would expect on the secondary node.

Maybe you can supply some values from the init-file from both primary and 
secondary node, so we maybe can see some misconfiguration. Ow...and the tns 
names?

Probaly the more interesting parameters to have a look at are:
db_name
DB_UNIQUE_NAME
dg_broker_config_file1 <== But I guess you do not have DG_Broker configured 
allready
dg_broker_config_file2 <== But I guess you do not have DG_Broker configured 
allready
dg_broker_start=TRUE   <== But I guess you do not have DG_Broker configured 
allready
fal_server
log_archive_config
LOG_ARCHIVE_DEST_1
LOG_ARCHIVE_DEST_2
LOG_ARCHIVE_DEST_STATE_1
log_archive_dest_state_2

Anyway...as Andrew Kerber also said, I have spend numerous hours cursing DG, 
just to find a misspelling or relalizing that I misunderstood the scenario :-(


Best Regards,
Martijn




On Wed, May 29, 2013 at 03:25:23PM -0400, Scott Canaan wrote:
> Primary.
> 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:23 PM
> To: Scott Canaan
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Data Guard Configuration
> 
> On the primary or the standby?
> 
> On Wed, May 29, 2013 at 2:18 PM, Scott Canaan 
> <srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>> wrote:
> 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<tel:%28585%29%20475-7886> - work           (585) 
> 339-8659<tel:%28585%29%20339-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<mailto:andrew.kerber@xxxxxxxxx>]
> Sent: Wednesday, May 29, 2013 3:14 PM
> To: Scott Canaan
> Cc: oracle-l@xxxxxxxxxxxxx<mailto: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.'
> 
> 
> 
> --
> Andrew W. Kerber
> 
> 'If at first you dont succeed, dont take up skydiving.'
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 


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


Other related posts: