Data Guard Switchover - Broker Cannot Restart Primary Instance

Nov 22, 2011

I am fairly new to Oracle and have recently started learning the basics of Data Guard. I have set-up a Primary 11g database which successfully ships and applies logs to a Single Standby (on the same server) as expected. Manual switchovers work fine; however, I have found a slight problem when performing switchovers using the Data Guard Broker utility.

The switchover is successful- but the broker cannot restart the Primary instance. The strange thing is that when I perform a switchover in the opposite direction (i.e. the new Primary goes back to standby again) it works fine. The error is receive is: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

The majority of posts I have seen on this topic seem to point to incorrect listener / tnsnames set up but they have exactly the same values. If both databases are identical, why does it work one way but not the other? I will provide any necessary files to pinpoint where the issue could be.

View 5 Replies


ADVERTISEMENT

Data Guard :: Switchover From Physical Standby To Primary Fails

May 9, 2010

i have a db's in maximum protection mode and i am trying to perform a switchover of physical standby database to primary role. but it failed., the steps followed is as follows. everything is fine with old primary site and the it is now in mounted state. When I went through the log file, I got the error message as "ORA-16072: a minimum of one standby database destination is required".the standby_archive_dest is as follows.

old primary database

SQL> alter system switch logfile;
SQL> alter system archive log current;

old standby database...Disconnect the managed recovery mode in Standby database.

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> recover standby database;
AUTO
SQL> exit
[code]....

View 1 Replies View Related

Data Guard :: 11.1.0.7 RAC Primary To Single Instance Standby Using 11.1.0.6

Mar 2, 2011

Primary:

2 NODE RAC Cluster/Linux x86-64/11.1.0.7.4 RDBMS

Standby server:

Brand new box, and I installed 11.1.0.6 (software only)

I have a brand new box set-up for a single-instance standby database, and I have installed 11.1.0.6 software only.

Do I need to patch 11.1.0.6 to 11.1.0.7 before I send a copy of the primary over to be set-up as a standby? If so, how do I patch 11.1.0.6 without having a local database in place as this server will only be used for a standby? Can patching the oracle_home only be done?

View 2 Replies View Related

Data Guard :: Change Instance Parameter Of Primary Database And Standby

Nov 29, 2011

I have a requirement to change the instance parameter of the primary database and standby in the data guard. Any procedure to do the same. I have to do it directly on production and there is no test set up so I cannot experiment . The procedure I am thinking of is as below.

1. Stop the standby

2. backup the primary

3. Change the parameter and restart to make it effective

4. Start the primary

5. Go to stand by

6. Change the parameter and mount the database.

7. Check if both are in sync and apply logs if not.

View 6 Replies View Related

Data Guard :: Primary Database Is RAC And Physical Standby Is Single Instance

Mar 27, 2013

I am using Oracle RAC 11.2.0.3 as primary database, we are going to start using Oracle data guard. So I am designing my infrastructure and planing to use Oracle 11.2.0.3 Single instance as my physical stand by database.

My question is it feasible to have my standby database as single instance while the primary is RAC? is it feasible to build my Oracle single instance standby database from the RMAN backup of the RAC primary database? Is there any restrictions (or any points to be taken into consideration) since my primary database is RAC while the physical standby is Oracle single instance?

in the below link

[URL].......

it was mentioned that primary can be RAC or single and same for standby, but my question is it feasible to have primary as RAC while standby as single instance? or it should be like each others?

The primary database can be either a single-instance Oracle database or an Oracle Real Application Clusters (RAC) database. Similar to a primary database, a standby database can be either a single-instance Oracle database or an Oracle RAC database.

View 7 Replies View Related

Data Guard :: Using DG Broker To Create New Standby Database?

Jan 25, 2013

create another standby database on a new server.

I'm running Oracle 11.2 EE on Solaris 10.

We already have one standby database, but now, I want to create another standby database on another server, which ultimately I will make primary and then replace and destroy our current primary/standby databases.

Also, just for the heck of it, I tried to look in our DB Console, and the "Add standby database" is grey'd out.

Is this because I am only using DB Console, and not Grid?But if that were the case, why would the option even be in DB Console, or perhaps is there a lmiitation to the number of standby databases you can manage with DB Console?

View 1 Replies View Related

Data Guard :: Ora-03113 Network I/O When Adding Standby To Broker

Dec 13, 2011

I got a primary database which ships logs successfully to a standby database where it is applied successfully as well.

I can connect using the tns name defined for data guard (which are already used for log shipping) in sqlplus.

Yet, at the time of configuring data guard broker,the command add database 'standby' connect identifier is 'to_standby'; fails.

Looking into drc<instance>.log, I see the error ora-03113 network I/O.

I haven't seen any error like that online and I can't explain why it does that when logs can ship already with the same connection identifier.

I have edited dest_2 with and without parameters LGWR and SYNC and reconfigured the broker without success. I've removed the configuration files and tried again.

I've checked that the password file is the same on both servers as well.Nothing seems to work. Is there a parameter I'm missing somewhere.

View 3 Replies View Related

Data Guard :: Broker Connecting To Standby Database Fails?

Jun 4, 2013

I checked lots of pages but I'm not able to find a solution für my problem. I already set up a primary and a standby database (prim = ALPHA1 / standby = ALPHA2). After enabling my dgmgrl configuration I got two errors:

DGM-17016: failed to retrieve status for database "alpha2"
ORA-16664: unable to receive the result from a database

The dg log from ALPHA1 says:

06/04/2013 16:06:57
Site alpha2 returned ORA-16664.
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration alphadgb Warning ORA-16607
Primary Database alpha1 Success ORA-00000
Physical Standby Database alpha2 Error ORA-16664

While the dg log from ALPHA2 (standby) says:

06/04/2013 16:43:28
SPFILE is missing value for property 'LogArchiveFormat' with sid='ALPHA2'
Warning: Property 'LogArchiveFormat' has inconsistent values:METADATA='arch_ALPHA2_%S_%t_%r.arc', SPFILE='(missing)', DATABASE='arch_ALPHA2_%S_%t_%r.arc'
Failed to connect to remote database alpha1. Error is ORA-12514
Failed to send message to site alpha1. Error code is ORA-12514.

How can I solve this issue? Every type of tnsping is successfull. The sqlplus login from the primary to the standby database works, the other way round works too! Therefore the tnsnames and listener data seems to be correct.

My configuration for ALPHA1 (primary db):
---------------------------------------------------------------
Listener
---------------------------------------------------------------
LISTENER_ALPHA1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

[code]....

View 3 Replies View Related

Data Guard :: EM (DB Console) Configuration After Switchover?

Dec 20, 2012

I have this scenario:

- Oracle 11.2.0.3
- RHEL 4.6 64 bits
- Active Data Guard
- Broker configured
- DBconsole configured on primary server

Now, I have server PRIM with the primary database, and server STB with the standby server. For now, the dbconsole is configured in the PRIM server.When I do a switchover (to the standby on STB), EM is not configured, so I use RepManager.sh to clean the sysman user, and I use emca to recreate the dbconsole. After this, everything works.

Once I switch back, the EM is no longer configured on PRIM, so I repeat the previous steps (repManager and emca). Everything is ok after this. I can access the EM on the primary normaly, and this gets information from the broker to provide basic information on the STB (like db status, apply, and so forth).

View 3 Replies View Related

Data Guard :: Unable To Perform A Switchover

Nov 2, 2013

I have a dataguard configuration (physical standby).Database A is the primary database and database B is the standby database (I do not use the broker).Both are Oracle RDBMS 12cR1 EE. The Apply process uses the current log (standby redo logs).On database B, when querying v$managed_ standby;, I get:           

ClientProcess    process    Status  ---------- ARCH       ARCH       CONNECTED          ARCH       ARCH       CONNECTED          ARCH       ARCH       CONNECTED          ARCH       ARCH       CONNECTED          RFS        ARCH       IDLE               MRP0       N/A        APPLYING_LOG       RFS        LGWR       IDLE                

It works fine.   Before to perform a switchover,- from database A (current physical database), I get switchover_status = 'TO STANDBY'- from database B (current standby database). I get switchover_status = 'NOT ALLOWED'. What switchover_status = 'NOT ALLOWED' means exactly and how to get further with the switchover? 

View 2 Replies View Related

Data Guard :: Database Is Read-only After Switchover On 11g?

Oct 1, 2012

we have a created primary and physical standby databases. Before the switchover the application connected to dataguard allows updates on the database. However after the switchover, it allows read-only access and we are unable to update. Any comments prima-facie ?

View 12 Replies View Related

Data Guard :: Any Documentation / Link Available To Switchover Of RAC Database Using Dgmgrl

Dec 8, 2010

I am having setup of 2 node 10.2.0.4.0 RAC setup on ASM with Single Instance Physical standby on File System (OS: RHEL 5.4). I configured DG Broker without any major issues. Getting all output of 'show configuration' and all DG related logs are clear. Archives are getting transferred from both Primary nodes.

DGMGRL> show configuration

Configuration
Name: dg_rac
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
livestdby - Primary database
livedg - Physical standby database

Current status for "dg_rac":
SUCCESS

Now I am getting error Error: ORA-16535: CRS is preventing execution of a broker operation.

DGMGRL> switchover to livedg;
Performing switchover NOW, please wait...
Error: ORA-16535: CRS is preventing execution of a broker operation

Oracle Says

Quote:Cause
A broker operation was underway that required CRS to stop managing the instances of this database, but CRS management could not be stopped on behalf of the broker"s request on at least some of the instances, so the broker operation was canceled.Suspend CRS management of this database using SRVCTL STOP DATABASE -D <name> -O NONE. Then reissue the broker request.But this command is not working as it's given to stop the database.

One more thing, it's nowhere said to stop CRS while performing Switchover / Switchback using DG Broker. When we do Switchover / Switchback we keep open only one of the Primary instance.

is there any documentation / link available to switchover of RAC database using dgmgrl (DG Broker)

View 3 Replies View Related

Data Guard :: Client Failure Failover / Switchover Standby Configuration?

May 10, 2011

After switchover the primary is now standby and standby is now primary, the clients are unable to connect to new primary database.

TNSNAMES.ora file at client side...

prim.world=
(DESCRIPTION_LIST=
(FAILOVER=true)

[Code].....

SQL> conn iq/iq@prim.world
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

SQL> conn sys/ora123@prim.world as sysdba
Connected.
SQL> select open_mode from v$database;

OPEN_MODE
--------------------------------------------------------------------------------
MOUNTED
SQL> select database_role from v$database;
DATABASE_ROLE
--------------------------------------------------------------------------------
PHYSICAL STANDBY
SQL>
--------------------------------------------------------------------------------
It's Oracle 10.2.0.1.0 version....

View 11 Replies View Related

Data Guard :: Failover / Switchover Without Loosing Previous RMAN Backups

Apr 5, 2013

Dataguard and RMAN.

Got Active DataGuard on a primary database, quite nicely sending its archive logs to its secondary. I can quite happily use the Broker and switchover between them.

Now if I take RMAN backups of the primary database, if I have to failover to the secondary, I'm gonna loose all those backups.

Well, I can restore the whole database to the backup, cos I can restore the control file, from the backuip and therefore I can restore the whole db.

But if I want to restore to a tablespace, I wont be able to , cos the db_unique_names names are different, and the DB ID's will be different.

Same goes if I use a recovery catalog....

so how do I failover/switchover without loosing my previous rman backups ??

View 2 Replies View Related

Data Guard :: Alter Database Commit To Switchover To Physical Standby - Getting Ora-16416?

Apr 21, 2011

alter database commit to switchover to physical standby; i am getting ora-16416 switchover target is not synchronized with the primary what to do

View 3 Replies View Related

Data Guard :: Possible To Use Dataguard From Single Instance To RAC Instance?

Jul 1, 2010

Is it possible to use oracle dataguard from single instance to RAC instance ? Does Oracle dataguard support this ?

View 1 Replies View Related

RAC & Failsafe :: Rac.vip.lsnr Instance Shutdown And Restart Itself?

Jul 7, 2011

'm using oracle rac 10.2.0.4.0 with 3 node and os SLES 10 sp 3 in early days we get error vip and lsnr service on my rac shutdown n restart itself,what happen to my rac ?

View 1 Replies View Related

During Primary (old Standby) To Standby (old Primary) Switchover Hang?

Apr 4, 2013

I am using RAC to RAC data guard environment. Os hp-unix. during primary(old standby) to standby(old primary) switchover I am ussing:

SQL>ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

I have 11.2.0.1 environment with standby and when performing switch over - it was hanging for more than 2 hours and i had to cancel it. This is what all i see in the database alert.log:

Errors in file /u02/app/oracle/diag/rdbms/drpdb/drpdb1/trace/drpdb1_m000_15160.trc:
ORA-01155: the database is being opened, closed, mounted or dismounted
Thu Apr 04 17:44:03 2013
Errors in file /u02/app/oracle/diag/rdbms/drpdb/drpdb1/trace/drpdb1_m000_15780.trc:
ORA-01155: the database is being opened, closed, mounted or dismounted
Thu Apr 04 17:59:03 2013
Errors in file /u02/app/oracle/diag/rdbms/drpdb/drpdb1/trace/drpdb1_m001_16373.trc:

[code]....

ORA-01155: the database is being opened, closed, mounted or dismounted.

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 :: 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 :: 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 :: Changing Primary DB Password?

Dec 16, 2011

I've 2 DB : One primary and One physical standby. I want to change SYS password on primary DB. Can I do it without any action on standby DB side ? If not, give me a step by step details to perform this action properly.

View 4 Replies View Related

Data Guard :: Delete Datafile In Primary?

May 26, 2012

I haved drop a datafile on Primary,and the archived log has transported to Standby,but the datafile is still exist in Standby.

Primary

alter tablespace tps_hxl
drop datafile '/u02/app/oracl/oradata/hxl10.dbf';

View 7 Replies View Related

Data Guard :: How To Manually Set Database_role To PRIMARY

Dec 11, 2010

I am getting error ORA-16816: incorrect database role. The reason is my switch over to standby become failed and now both primary and standby databases showing 'database_role' as 'Physical Standby'.My question is how to manually set 'database_role' to 'PRIMARY' on primary database.

--------------------------------------------
DGMGRL> show configuration
Configuration - dgproj
Protection Mode: MaxPerformance
Databases:
repl - Primary database
Error: ORA-16816: incorrect database role
dgrepl - Physical standby database
--------------------------------------------

View 8 Replies View Related

Data Guard :: Getting Standby Host And DB Name From Primary

Oct 25, 2012

I'd like to know the Standby hostname and database name (db_unique_name) from primary using SQL. Simply put, which table in primary datbase gives us the standby host and the database name. I am aware that TNSNAMES.ORA contains details, but we cannot use SQL for that. I am also aware of V$ARCHIVED_LOG's DEST_ID column. But, the DEST_ID will not show the host and the db names, neither does V$PARAMETER's LOG_ARCHIVE_DEST_n if SERVICE parameter is set to Connect Identifier.

If I further paraphrase my problem, how I'd relate a dest_id to a standby host and database using SQL.

SELECT <columns> FROM <v$some_view> WHERE dest_id IN (2, 3);

DEST_ID      HOST_NAME      DATABASE_NAME
--------------------------------------------------------
2            host2           standby_1
3            host3           standby_2DB version : 10g
OS : Solaris 10

View 3 Replies View Related

Data Guard :: Renaming DBName And Instance Name

Jul 13, 2010

We are planning to change the dbname from appr to apdr. Its a DR (Standby Database).

a. NID option will work for this? - DB in mount state (Standby db)

b. Is that possible to change the Instance name also?

c. Any Prerequsities and postrequirments for this change? (ie,Data Broker, communication with Primary and Standby etc?

Oracle 10g, OS - Sun Solaris

View 2 Replies View Related

Data Guard :: Refresh Primary Using Standby Database?

Feb 2, 2013

I was using physical standby but my primary database had had some HW issue.So I had activated standby database to handle production.During 3 months, standby database was our live database and our old primary was unavailable.Now HW issue on primary has been fixed.And I want to set again my old configuration : means set primary and standby db.

I'm trying this :

1) check the SCN on old primary

2) Rman incremantal backup from scn

3) on primary db : catalog

4) on primary db : recover database noredo

View 1 Replies View Related

Data Guard :: Primary Not Open After Standby Configuration

Jul 19, 2011

I did standby before and it works wighout any disturbations and even configuration seems to me not very complicated - but it was before. now i am trying to do standby configuration once again. there is database named DESK.

two physical serwers:
sczepl-db07 - primary
r00979 - standby

on each for this serwer there is listener listening on port 1521, and on each is tnsnames configured properly:

for sczepl-db07
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sczepl-db07)(PORT = 1521))
[code]....

so why primary don't see standby db and claims that ther is no standby service? i proved that there is connection primary <--> standby.

View 21 Replies View Related

Data Guard :: Copying Archived Log File From Primary To DR

Sep 21, 2011

1) How to copy the ARCHIVED LOG FILE from Primary to DR location. Where if the DR is having the file already, how to SKIP that Particular Archived log file?
2) I have Checked with the FILE_TRANSFER DBMS package, but it gives the error if any file existing already.

View 2 Replies View Related

Data Guard :: Changing Password On Primary Database?

Nov 10, 2011

I'm using 2 databases : Primary and Standby DB. It working fine. I've just one question : I want to change SYS password on primary DB. Can I change it without any action on Standby DB?

View 8 Replies View Related







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