RAC And Data Guard On 11.1?

May 13, 2011

i'm using a mixture of Oracle� Data Guard Concepts and Administration11g Release 1 (11.1) And Bulletin : MAA - Creating a RAC Physical Standby for a RAC Primary 10g ( on oracle support) But neither is comprehensive for what i'm trying to do.

setting up Data Guard Broker on a RAC Data Guard environment?

View 1 Replies


ADVERTISEMENT

Data Guard :: Rolling Upgrade Physical Data Guard

Jul 5, 2011

We have physical data guard configured version (10.2.0.4). We are in need to upgrade primary & standby database to 11G R2. Can we perform rolling upgrade.

View 3 Replies View Related

Data Guard :: How To Know Current Active Guard Settings In Standby Database

Oct 17, 2012

Controlling User Access to Tables in a Logical Standby Database can be controlled using the following command:

ALTER DATABASE GUARD STANDBY;

My simple question is: how can I know the current active Guard setting in the standby database?

Oracle 11g R2.

View 1 Replies View Related

Data Guard :: Unable To Get Data Of Primary In Standby Database (dataguard)

Jan 16, 2013

i have configured physical standby in my local system, to check logshipping i created a table at primary db, wen i tried to check in standby, it says table does not exist..below are primary & standby alert entries..

Primary alert log

Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.0.98)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=STAND)(SERVER=dedicat ed)(CID=(PROGRAM=d:oracle11gappadministratorproduct11.1.0db_1inORACLE.EXE)(HOST=A960M)(USER=SYSTEM))(SERVER=dedicated)))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.1.0.6.0 - Production

[code]....

View 1 Replies View Related

Data Guard :: Changing Dbname / Sid / Data / Control File Locations?

Nov 5, 2010

I want to change dbname,sid,data/control file locations in operational dataguard setup i plan to follow as below

1)shutdown primary and standby (stop managed recovery)

2)change db name in init.ora of primary and standby change database name control file location

3)create control file for primary from trace(script) make changes for db name and file locations

4)mount and open primary database

5)create standby control file

6) transfer standby control file to standby

7) mount stand by database and start manage recovery

If this steps will error free do i need to follow any thing additional to this or what is other best way for this or its not possible at all

View 1 Replies View Related

Data Guard :: Buffer Busy Waits On UNDO Data In Active DG

Feb 24, 2013

Oracle Version: 11.1.0.7.0
Active Dataguard

Statspack has been configured for Active Dataguard on Primary database.We got an spike of Buffer busy waits for about 5 min in Active Dataguard, this was causing worse Application SQL's response time during this 5 min window.Below is what i got from statspack report for one hour

Snapshot       Snap Id     Snap Time      Sessions Curs/Sess Comment
~~~~~~~~    ---------- ------------------ -------- --------- -------------------
Begin Snap:      18611 21-Feb-13 22:00:02      236       2.2
  End Snap:      18613 21-Feb-13 23:00:02      237       2.1
   Elapsed:               60.00 (mins)
[code]...

Why there could sudden spike of demand on UNDO data in Active Data Guard ?

View 2 Replies View Related

Data Guard :: DATA FILES IN Storage Area Network (SAN)

Mar 29, 2011

I am working in a bank as an system consultant, i have a SAN Storage Area and oracle as below.

SAN 1

This interface includes the DATA FILES of the oracle tablespace

SAN 2

SAN1 Mirrors the DATA FILES of the oracle tablespace to SAN 2

1. Can i rely on real time data recovery from SAN2 ?
2. if SAN1 (Data Files are currupted) will the SAN2 Data Files will be currupted as well.
3. If the SAN2 is currupted then what Oracle Features can be used to have uncurrupted data.

View 5 Replies View Related

Data Guard :: ORA-01157 / Cannot Identify / Lock Data File 1

Jul 23, 2010

i did everything writen but when i do *SQL>alter database recover managed standby database disconnect from session;*

i go and look in the standby database AlertLog file ,and thats whats writen

*ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:ORACLEPRODUCT10.2.0ORADATADBSYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: غير قادر على فتح الملف
O/S-Error: (OS 3) The system cannot find the path specified.

[code]....

strange thing that it realises the primary database in drive F and it goes to it but i dont understand what could be the reason of this ,although im doing this command while primary database is shutdown!

View 2 Replies View Related

Data Guard :: ORA-01354 / Supplemental Log Data Must Be Added To Run This Command

May 2, 2012

I configure logical standby online .when I execute dbms_logstdby.buid,first

SQL> EXECUTE DBMS_LOGSTDBY.BUILD;

it was blcoked by other sesson,then i kill the holding session,but no work.then i cancel this step and execute it again . the error is

SQL> EXECUTE DBMS_LOGSTDBY.BUILD;
BEGIN DBMS_LOGSTDBY.BUILD; END;
*
ERROR at line 1:
ORA-01354: Supplemental log data must be added to run this command
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3669
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3755
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 12
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_INTERNAL_LOGSTDBY", line 370
ORA-06512: at "SYS.DBMS_LOGSTDBY", line 157

[code]....

View 3 Replies View Related

Data Guard :: Data Files Locations On Oracle 11gR2

Jun 15, 2012

I have set up a cross platform (Microsoft Windows IA (32-bit) -> Linux x86 64-bit) data guard and it worked fine.Then I did a switch over (which again worked) and found out the data is not getting replicated at all.. checked the data files available from the new primary database and found out they are in the windows format as below..

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
D:ORACLEAPPADMINISTRATORORADATAMFSSYSTEM01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSSYSAUX01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSUNDOTBS01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSUSERS01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSRMANRMAN_TS01.DBF

and physically they were created at '/home/app/oracle/product/11.2.0/db_1/dbs/' and as

D:ORACLEAPPADMINISTRATORORADATAMFSREDO02.LOG
D:ORACLEAPPADMINISTRATORORADATAMFSREDO03.LOG
D:ORACLEAPPADMINISTRATORORADATAMFSRMANRMAN_TS01.DBF

View 5 Replies View Related

Data Guard :: Unable To Get Data Of Primary In Standby Database

Jan 16, 2013

I configured dataguard in my local system.

1) scn differs wrt primary in standby (i checked, 1day difference), how to make scn same?

2)i created a table in primary, its not refelecting in standby, (below i ve pasted alertlog entries)

ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Errors in file d:oracle11gappadministratordiag
dbmsstandstand racestand_dbw0_6916.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'D:ORACLE11GAPPADMINISTRATORORADATASTANDSYSAUX01.DBF'

[code]....

3)wen i try to open standby database in read only mode gives below error..

ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1:
'D:ORACLE11GAPPADMINISTRATORORADATASTANDSYSTEM01.DBF'

View 31 Replies View Related

Data Guard :: Data Change In Metro Cluster

Oct 21, 2012

Our organization has recently decided to go for storage metro cluster solution for disaster recovery. In a Data guard environment, we normally calculate how much archive log is generating and based on that value we calculate the required bandwidth.

For storage metro cluster, we need to find how much block is changing in our primary database, and the same rate of change would apply on DR cluster. Now, i need to give the assumption how much changing is happening in my system. How to calculate the change.

View 4 Replies View Related

Data Guard Failover

Jan 7, 2011

I am very new to data guard...I have a primary and a physical standby database...If the primary got crashed, are the users directly switched to physical standyby (is it automated) or the DBA has to manually do the fail over or switch over....is it the same concept as in RAC like TAF....How can the DBA know that the users are disconnected from the database.....explain with some steps...

the version is 10.2.0...

View 2 Replies View Related

Oracle Data Guard?

Feb 16, 2012

Log shipping stopped logging/shipping into the Standby Database in one of our Oracle Data Guard Servers about two month ago and there was no change carried out as at that time. The Data Guard has only one Standby database. I have been managing the log shipping and recovery manually.

View 1 Replies View Related

Data Guard :: Implement On Same PC

Apr 5, 2010

I want to implement data guard on same PC.

View 1 Replies View Related

Data Guard :: Upgraded 10.2.0.1 To 10.2.0.4

Sep 25, 2012

I did upgrade from 10.2.0.1 to 10.2.0.4 on the secondary database , the primary database version is 10.2.0.4,i took cold backup from the primary to the secondary database , when i try to create control file on the secondary , i am getting this ORA-01130: database file version 10.2.0.3.0 incompatiable with ORACLE version 10.2.0.1.0.*

Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE     10.2.0.4.0     Production
TNS for 64-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

View 2 Replies View Related

Data Guard :: Can't Connect To Standby DB

Jan 5, 2011

I'm trying to prepare data guard operation on the virtual machines.

1. I have install Oracle database without start up database on the standby server.

2. I try to connect this db by sysdba, but failed!

Quote:
C:>sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 5 20:03:33 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 5 20:03:33 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:

I'm using instruction below: [URL]

Why I can't login to database?

View 7 Replies View Related

Data Guard :: Physical Standby With Same SID

Sep 22, 2010

I have to implement Physical standby using same SID. parameters required to set on Primary and standby. Also what entries are required to do in TNS file. Recently we have faced hardware failure.

View 10 Replies View Related

Data Guard :: How To Check Synchronization

May 29, 2011

how to check dataguard synchronization?

View 2 Replies View Related

Data Guard :: Archive Gap Script

Mar 6, 2012

I am working on Data Guard concepts. I have configured Data Guard which is working fine.

Now I am trying to work on script which can give me output on OS prompt if there are any archive gaps..

I tried to use few commands on a script archgap.sh as

archgap.sh
sqlplus "/ as sysdba"
select * from v$archive_gap;

I am trying to run above script on OS prompt as

ABC:/home/oracle>sh archgap.sh

but I am not getting output ... I want it a way that this script should run within interval of 5 min and give output on OS prompt.

View 2 Replies View Related

Data Guard :: Configuration For New Server?

Aug 23, 2011

tell me about data guard accommodate with 11g database standard additions or not if no,is there any way to make it working under this edition?one more thing may i have the steps of configuration data guard in real time for anew server.

View 5 Replies View Related

Data Guard :: What Is The Most Common Mode

Feb 27, 2012

what is the most common mode in dataguard? maximize protection or maximize availability or maximize performance

View 6 Replies View Related

Data Guard :: Windows To Aix (logical)

Oct 18, 2010

I have a Windows 2003 server with Oracle 10.2.03 database residing in one datacentre, with Dataguard configured to a physical standby in a similar location (proven process that works great).

I now have a requirement to transfer and synchronize the same live database to a database in a different country (AIX box), purely for data purposes not failover etc. I can transfer an export of the Database and have this up and running as a logical database of the live on AIX, but is it then possible to configure dataguard on the Windows server to also send updates to this logical database on the AIX system? Thus keeping them in sync with each other?

View 1 Replies View Related

Data Guard :: Archive Log Deletion

Mar 8, 2013

I have a RAC system with DR set-up, this is a test environment and it doesn't have any backup, why DR is required but it exist. Since this is a test a lot or archives gets generated and deleting the archives has become a daily job for this server manually.

I want have a script to delete archive logs which is in non-ASM (i.e. filesystem) after ensuring that the archive log has been applied in standby database. If this can done only by RMAN.

View 6 Replies View Related

Upgrade :: Data Guard Setup From 10g To 11g

Jun 23, 2013

We have dataugard set up on linux with oracle10.2.0.1.0 and now we want to upgrade that complete setup (primary, standby, dataguard broker) to 11.2.0.3.0.

View 1 Replies View Related

Data Guard :: Configure Non-RAC DG For RAC Instance

Jun 13, 2011

We are in project design phase and following is the hardware setup:

Database (2 node RAC)-Solaris 10
Application server server (2 server) -Solaris 10
Web server (2 server for Failover)= RHEL

For DR
Database (1 node)-Solaris 10

need to know
1.What are the best practice to implement and to configure DR as Non-RAC physical standby for RAC database server.
2.What are implication if we go for single node except failover node unavailability for DR.
3.What are the steps of Switchover in this case.
4.What's the recommended backup solution for 8-10 Terabyte database

View 1 Replies View Related

Data Guard - Difference Between 2 Commands?

Mar 6, 2012

Before I am going to implement data guard in my company i am experimenting it in a test server. I want to know the difference between these 2 commands mentioned below which i found from various websites.

[ START REDO APPLY ]
SQL> alter database recover managed standby database disconnect;
[ START REDO APPLY USING REAL-TIME APPLY ]
SQL> alter database recover managed standby database using current logfile disconnect;

Which of the two commands should i use in my production database.

View 1 Replies View Related

Data Guard :: Delay=60 Not Working In 11.2.0.2?

Mar 20, 2013

I am using 11.2.0.2 Data Guard.

I had set Delay=60 for Standby Database in init parameters of Primary Database and bounced both Primary and Standby DB.

But as soon as i perform log switch in Primary DB it is being applied in Standby DB immediately ignoring my Delay parameter.

The Physical Standby is mounted and redo apply is enabled.

Parameters:
-----------------

LOG_ARCHIVE_DEST_1=
'LOCATION=/data/dg/arch1/chicago/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=chicago'
LOG_ARCHIVE_DEST_2=
'SERVICE=boston ASYNC DELAY=60
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=boston'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE

Standby:
-------------

SEQUENCE# APPLIED
---------- ---------
1208 YES
1209 YES
1210 YES
1211 YES
1212 YES
1213 YES
1214 YES
1215 YES
1216 IN-MEMORY

View 4 Replies View Related

Data Guard :: How To Apply Archives In Standby

Sep 1, 2010

i have attended an interview there i got a question like--->There are 100 archives generated in standby in that a series of five archives are missing and those are not available in the primary then how will you do.....

View 2 Replies View Related

Data Guard :: Recovery Is Not Running Automatically

Sep 5, 2013

in a RAC multi-node environment with single instance dataguard..Recovery is not running automatically I have to re-run the recovery command to make them sync and this command works for already archived log files no upcoming archive log file applied I have to re-run the recovery command again for newly archived log files.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved