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.
>
>
> --
> //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.'
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
