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


ADVERTISEMENT

Data Guard :: Physical Standby Configuration

Mar 10, 2011

I did the all necessary steps required for the physical standby configuration. My standby db is mounted but not able to open.

Below are the steps.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1845493760 bytes

Fixed Size 2021568 bytes
Variable Size 452986688 bytes
Database Buffers 1375731712 bytes
Redo Buffers 14753792 bytes
Database mounted.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=demodb' scope=both;

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=BOTH;

System altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u002/app/OraDB10g/stdemo/oradata/system01.dbf'

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
*
ERROR at line 1:

ORA-00600: internal error code, arguments: [kcrfrsetnab_found], [1], [136], [],
[], [], [], []
ORA-00600: internal error code, arguments: [kcrfrgv_scn7], [], [], [], [], [],
[], []

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kccocx_01], [], [], [], [], [], [],
[]

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 :: 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 :: Cannot Open Physical Standby Read Only?

Dec 7, 2010

Suddenly I can't open any of my physical standby databases read only. Alert log snippet and trace files follow post. I'm running 9.2.0.1.0 on all hosts, which are running AIX 5.2. I've successfully opened all physical standby databases read only numerous times in the past. solve this? Is it possible that these standby databases cannot be switched over to primary should the need arise?

Here's how I typically open a physical standby database read only:

alter database recover managed standby database cancel;
alter database open read only;

Errors in file /ora/product/9.2.0.1.0/rdbms/log/icps1_ora_27382.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access

[code]...

View 18 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 :: One Primary And 2 Physical Standby Databases

Sep 29, 2010

I have one primary database and one physical standby database on my data guard environment.

Now i want one more physical standby database in my data guard environment, meaning i want 2 physical standby. since this is a production environment, i need to take great care. However, downtime will be mandatory.

[u]init.ora for production:[/u]

pup2.__db_cache_size=6241124352
pup2.__java_pool_size=33554432
pup2.__large_pool_size=134217728
pup2.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment
pup2.__pga_aggregate_target=5771362304
[code]......

init.ora for my first primary standby

pup2.__db_cache_size=6509559808
pup2.__java_pool_size=33554432
pup2.__large_pool_size=67108864
pup2.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment
pup2.__pga_aggregate_target=5502926848
[code].......

View 5 Replies View Related

Data Guard :: Upgrade Primary And Standby Database?

Apr 30, 2012

I have a primary and standby DB using data guard 10.2.0.3.I want to upgrade oracle to 11G.I know that primary and standby should have same version even if data guard will not work again.I want to know what is the steps by steps action to properly upgrade both DB : primary and Standby.

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 :: 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 :: How To Convert Primary Control File For Standby

Dec 29, 2009

I try to recover standby db from a primary db backup set,but the standby control file is different.

to create primary controlfile by rman:
backup control file format '/home/cur_control';

to create standby controlfile:
backup control file for standby format '/home/std_control';

I want to know if there is method to convert cur_control to std_control.

View 3 Replies View Related

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 :: Check If Database Encrypted Or Not On Primary / Standby?

Jul 25, 2013

We have a primary and a standby (Physical Dataguard) site.

1. How do i check if the database is encrypted or not on primary as well as standby ?
2. If primary and standby are encrypted, does the data that gets replicated from primary to standby also in encrypted form ? If not, does it make sense to encrypt that ?

View 2 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 :: Apply Redo While Standby Open In Read Only Mode?

Apr 9, 2013

1) If i do changes in table on primary database and if i open standby database in Read-Only mode, i can see those changes immediately only if Real Time Apply is enabled. Am i correct? Database version is 10.2.0.4

2) From 11g, It is possible to apply redo while the standby is open in read only mode. prior to 11g, it was not possible. Right?

3) Should I first cancel Managed Recovery prior to issuing “ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY”?

View 1 Replies View Related

Data Guard :: Convert Snapshot Database (standby) Directly To Primary?

Dec 16, 2012

(Oracle 11gR1 OEL 5)Is there any possibility to convert snapshot database (standby) directly to Primary. Instead of manual switchover I want to do this

I have checked that snapshot creates a guaranteed restoration point which reverts back changes in Standby.

View 3 Replies View Related

Data Guard :: Query Regarding Standby Database State When Primary Is Down / Unreachable

Feb 20, 2013

I want to know if there is any reflection on the standby database states when it's primary is down or not reachable? I want to use this information from standby node to determine if I can programmatically execute (dgmgrl) failover operation or not? This is considering that the broker configuration has no fast-start failover and no observer enabled/configured.

View 4 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 :: Change Server B To Standby Database With A Running As Primary

Oct 4, 2010

I new to data guard concept.

I am using oracle 10g with data guard configured , I have primary ( A ) and standby database ( B ) .But because of some unavoidable conditions the primary database ( A ) got shutdown and was not starting , We shifted the standby database ( B ) at new location and changed it to primary with following command ,

startup mount;
alter database recover managed standby database finish;
alter database commit to switchover to physical primary;
shutdown;
startup;

This new primary ( B ) was open for end users for 2 days during which old primary ( A ) was shutdown .

I took the backup of ( B ) and restored it on A AND shutdown the B . Now A is acting as Primary database. Server B is shutdown . I want to change server B to standby database with A running as Primary .Is it possible ?

View 5 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 :: Create Control File With Standby Keyword On Primary Database

Jul 4, 2012

What is difference when you issue a create controlfile with "standby" keyword on the primary database

ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/path/db_stby.ctl';

vs. creating a control using

ALTER DATABASE BACKUP CONTROLFILE to '/path/db_control.ctl';

what does ORACLE put into the standby control that is "extra"? ie. what is the difference between a standby control file and a normal control file?

View 7 Replies View Related

Data Guard :: Find Out Number Of Standby Databases Configured For Primary Database From OS Level?

Nov 14, 2013

How can find the number of standby databases configured for primary database from os level

View 9 Replies View Related

Data Guard :: Flashback Snapshot Standby Database Or New Primary Database After Failover?

Aug 30, 2013

If flashback is enable in physical standby database 1. If we failover at 11AM can I flash back NEW primary database to 6 AM ? 2. if I convert physically standby database to snapshot standby database at 11AM ,  Can I  flashback snapshot standby database to 6 AM and do some works on it (DML operations)  then   converting the snapshot standby database into physical standby database ?  

View 1 Replies View Related

Data Guard :: Switch (convert) Primary Database To Standby Database?

Jan 30, 2013

I have installed oracle 11g standard edition one and created both primary and standby database. now i want to know how to switch(convert) primary database to standby database.

View 8 Replies View Related

Data Guard :: Apply Standby Redo Log To Physical Standby Database

May 26, 2013

I have dataguard configuration operating in maximum availability mode with a local standby db (A - lgwr sync not using real time apply) and a remote standby db (B - lgwr async). I then simualted a crash of my primary database with batch jobs running. Since the stby db A is in lgwr sync option ,all the commited data in the current online redo log has been transmitted to stby A and is present in its stby redo log (Group 2).How do I apply this stby redo log to the remote stby db.

Tried the following methods.

1.ftp the stby redo log to the remote db and tried to regiter it, got an error that it is not completely archived.

2.issued the recover standby database command and supplied the stby redo log when it asked for the sequence in the stby redo, got an error saying there is corruption in a block(tried this option multiple times ended up with the same result.)

View 5 Replies View Related

Data Guard :: Possible To Convert Logical Standby To Physical Standby

Aug 30, 2013

My steps for testing as below:

1.create a primary database
2.duplicate a physical standby database;
3.turn on flashback on both databases.
4.record SCN xxx on physical standby database.
5.convert physical standby to logical standby (using keep identity statement)
6.flashback to logical standby to xxx
7.convert logical standby to physical standby
8.using real time apply I got errors: Fast Parallel Media Recovery enabledManaged Standby Recovery starting Real Time ApplyMRP0:

Background Media Recovery waiting for new incarnation during transient logical upgrade procedure

Errors in file /home ora/ app/ oracle/ diag/ rdbms/ ora11gr1dg/ora11gr1dg/trace/ora11gr1dg_mrp0_10120.trc:ORA-19906: recovery target incarnation changed during recoveryManaged Standby Recovery not using Real Time ApplyErrors in file /home/ ora/app/ oracle/diag/ rdbms/ ora11gr1dg/ ora11gr1dg/ trace/ora11gr 1dg_mrp0_ 10120.trc:ORA-19906: recovery target incarnation changed during recovery  

Errors appears every 10 seconds. Seems MPR0 is waiting for new incarnation for a long time. So am I.Standby database incarnation:

List of Database IncarnationsDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time-------1 1 ORA11GR1 3853851354 CURRENT 1 08/09/2013 01:02:182 2 ORA11GR1 3853851354 ORPHAN 2127877 08/28/2013 19:22:01     BGV

View 2 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 :: Standby Redo Log On Standby

Apr 24, 2011

GROUP# THREAD# SEQUENCE# sizeMB ARC STATUS T
---------- ---------- ---------- ---------- --- ---------------- -
1 1 115 512 YES CLEARING O
2 1 116 512 YES CURRENT O
6 1 114 512 YES CLEARING O
4 1 112 512 YES CLEARING O
5 1 113 512 YES CLEARING O
3 1 111 512 YES CLEARING O

6 rows selected.
[code]...

Above result is from standby database.I am trying to understand the concept of standby redo log.My stadby database protection_mode is MAXIMUM PERFORMANCE.

View 10 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

ORA 16009 - Data Guard Configuration Seems To Be Working

Apr 26, 2007

just realised the data guard configuration seems to be workin but the error kepps appearing on the alert log of both primary and physical standby that i configured. below is my primary and standby pfiles.

primary
*.db_unique_name='CPASPRD'
*.service_names='CPASPRD'
*.log_archive_dest_1='LOCATION=/Oracle/archivelog/'
*.log_archive_format='%t_%s_%r.dbf'
[code]....

View 11 Replies View Related







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