RE: Data Guard Configuration

From: Scott Canaan <srcdco_at_rit.edu>
Date: Wed, 29 May 2013 15:25:23 -0400
Message-id: <A9F069F06B325049A1D90D1F8EBEB8B6EEF6A1427E_at_ex02mail02.ad.rit.edu>



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 Received on Wed May 29 2013 - 21:25:23 CEST

Original text of this message