Re: Data Guard Configuration

From: Martijn Bos <maboc_at_maboc.nl>
Date: Thu, 30 May 2013 09:10:55 +0200
Message-ID: <20130530071054.GA26406_at_app01.bos>



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_at_rit.edu<mailto:Scott.Canaan_at_rit.edu>)
> (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_at_gmail.com]
> Sent: Wednesday, May 29, 2013 3:23 PM
> To: Scott Canaan
> Cc: oracle-l_at_freelists.org
> Subject: Re: Data Guard Configuration
>
> On the primary or the standby?
>
> On Wed, May 29, 2013 at 2:18 PM, Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> 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_at_rit.edu<mailto:Scott.Canaan_at_rit.edu>)
> (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_at_gmail.com<mailto:andrew.kerber_at_gmail.com>]
> Sent: Wednesday, May 29, 2013 3:14 PM
> To: Scott Canaan
> Cc: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>
>
> 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_at_rit.edu<mailto:srcdco_at_rit.edu>> 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_at_rit.edu<mailto:srcdco_at_rit.edu><mailto:Scott.Canaan_at_rit.edu<mailto:Scott.Canaan_at_rit.edu>>)
> (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
Received on Thu May 30 2013 - 09:10:55 CEST

Original text of this message