RE: Data Guard Configuration
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