Data Guard :: Oracle Standby Database Recovery

Mar 31, 2011

i have done oracle data guard between two databases (database A is the primary) and (database B is the standby), and it was working fine for two weeks, then the network admin did some changes on the firewall on standby side, which made the primary database can not write on standby redo log , so archives was generated on primary and do not generated on standby by, now we solve the firewall probelm and new archives generated on primary is generated on atandby too, but now i have a gap in archives on standby database and standby database now is not synchronized with primary database, and data changes happen on primary is not reflected on standby, also archives that were generated on primary and did not generated on standby during the problem time is not registered in V$ARCHIVED_LOG neither on primary database nor on standby database

View 1 Replies


ADVERTISEMENT

Data Guard :: Archive To Complete Recovery On Standby Database

Oct 22, 2013

i have found an issue regarding log archiving on dest1. yesterday one sequence number 76871 not archive to dest1.alert logfile content as follow. i configure standby and ship archive manually with window copy command. i need this archive to complete recovery on standby database.

Mon Oct 21 09:29:28 2013
ARC2: Completed archiving log# 3 seq# 76869
Mon Oct 21 09:39:28 2013
Thread 1 advanced to log sequence 76871
Current log# 2 seq# 76871 mem# 0: D:ORACLEORADATAORC1REDO02.LOG
[code]....

View 7 Replies View Related

Data Guard :: How To Find Applied_time In Standby Database Managed Recovery Mode

Sep 10, 2012

How to find applied_time in standby database managed recovery mode (*PHYSICAL STANDBY*).

View 3 Replies View Related

Data Guard :: Apply Patches On Oracle Database With Logical Standby Database?

Apr 22, 2011

I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.

I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?

1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site

View 2 Replies View Related

Data Guard :: Standby Database With Oracle Standard Edition?

Nov 6, 2012

my customer wants to create a standby database for his production database (Oracle Standard Edition 11g R2 @ Windows 2008 R2 64 Bit). Now any proof-of-concept which explains shortly the concept and how to achieve it.

View 4 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 :: Standby DB Cannot Do Auto Recovery?

Apr 23, 2013

I have done the configs as per the guide here [URL] .... This is a physical standby db

Primary initBP1.ora
compatible = "11.2.0"
log_archive_dest_1 = "LOCATION=H:oracleBP1oraarchBP1arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=BP1"
log_archive_dest_2 = "SERVICE=BP1_DR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
[code]...

How I do I make sure that the DR site is recovering automatically ?

View 10 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 :: ORA-00274 / Illegal Recovery Option SESSION Physical Standby DB

May 6, 2011

oracle version: 10gr2
os:windows 32

I have configured a physical standby database.

I have set the physical standby database to open read mode for a short while.

according to [URL] in order to set db in for from open read-only to applying redo data

Quote:

To change the standby database from being open for read-only access to performing Redo Apply:

Terminate all active user sessions on the standby database. Restart Redo Apply. To start Redo Apply, issue the following statement:

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

To enable real-time apply, include the USING CURRENT LOGFILE clause:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
2> USING CURRENT LOGFILE;

this is what happen

SYS@ngdr> alter database recover managed standby database disconnect session;
alter database recover managed standby database disconnect session
*
ERROR at line 1:
ORA-00274: illegal recovery option SESSION
SYS@ngdr> alter database recover managed standby database using current logfile;

okay since I encountered the illegal recovery options session, I decided to use alter database recover managed standby database using current logfile; now the session seems to be hanging forever.

View 3 Replies View Related

Data Guard :: Oracle Application 12.1.1 / Database 10.2.0.4 - Disaster Recovery Site

Aug 18, 2012

We have an Oracle application 12.1.1 running with oracle database 10.2.0.4 and we're using HP-UX itanium 11i v3 servers for both application and database, our requirement is to establish a Disaster Recovery site out of our building to ensure data protection.

What is the best option we can use to reduce the cost and to implement the DR site? can we use data guard ? and will be the configurations and requirements for it?

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 :: How To Get SQL Plan In Standby Database

Mar 14, 2012

I want to get the execute plan of a sql in standby database(read only),but failed,how can i do?

SQL> explain plan for select count(1) from hxl.tb_objects;
explain plan for select count(1) from hxl.tb_objects
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-16000: database open for read-only access

SQL> select count(1) from hxl.tb_objects;

COUNT(1)
----------
22238018

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ ONLY

View 4 Replies View Related

Data Guard :: How To Create Standby Database For RAC

Mar 10, 2010

I have two node rac running on SAN with ASM , i want to configure a single instance standby database for this.

View 2 Replies View Related

Data Guard :: Standby Database Architecture

Jul 8, 2011

To have physical standby database, the hardware and software versions should be same, including patch sets?

View 3 Replies View Related

Data Guard :: 10g Physical Standby Database

Sep 17, 2012

DB1 <Primary> - Production
DB2 <Physial Standby> - DR

I will need to startup my DB2 in DR segment for testing.If i perform the below, will it affect my Production DB? I need it to be up and running as well.

DR:
recover managed standby database cancel;
shutdown immediate;
startup nomount;
alter database mount standby database;
recover standby database until cancel;
alter database activate standby database;

View 11 Replies View Related

Data Guard :: Drop Standby Database

Sep 7, 2012

Oracle RDBMS 11.2.0.2 on RHEL 5.6.

I need to drop standby database completeley and rebuilt physical standby for the same database. We identified there are lot of inconsistencies between primary and standby. How do i need to remove the standby? And what is the best procedure?

View 2 Replies View Related

Data Guard :: Creation Of Standby Database

Dec 7, 2010

I was able to create the standby database on different server with the same name for the primary and standby database but I want to know that can I create a standby database with different database name than that of the primary database server.

View 1 Replies View Related

Data Guard :: Creating Standby Database From Active Database Using RMAN

Dec 21, 2012

creating the standby database from Active database using RMAN and getting the below issue after i executed the duplicate command.

Version of Database:11g(11.2.0.1.0)
Operating System:Linux 5
Error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/21/2012 17:26:52
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
[code]....

provide any work arounds to proceed further in creating the 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 :: 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 :: Error While Connecting Standby Database

Apr 19, 2011

During data guard configuration i have receive an error while connecting to stanby database from primary database rman prompt.

rman target sys/srk786@orcli
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 19 09:59:26 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCLI (DBID=3754068166)
RMAN> connect auxiliary sys/srk786@stnd
[code]....

View 1 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 :: How To Create Standby Database On Same Machine

Apr 4, 2012

how to create the standby database on the same machine. os-window xp 2000(32 bit window) oracle 10g 10.2.0.1.0.

View 4 Replies View Related

Data Guard :: How To Defile Logfile Of Standby Database

Feb 18, 2012

How can i define the logfile of standby database when using then duplicate database to create the standby database? the flowing command can not run.

run{
duplicate target database for standby dorecover nofilenamecheck
logfile group 1 ('/u01/app/oracle/oradata/oracl/redo1_1.log','/u01/app/oracle/oradata/oracl/redo1_2.log') size 512M,
group 2 ('/u01/app/oracle/oradata/oracl/redo2_1.log','/u01/app/oracle/oradata/oracl/redo2_2.log') size 512M,
group 3 ('/u01/app/oracle/oradata/oracl/redo3_1.log','/u01/app/oracle/oradata/oracl/redo3_2.log') size 512M;
}

View 3 Replies View Related

Data Guard :: Backups On Physical Standby Database (RAC)?

Nov 23, 2011

I have set up a single instance standbys for rac databases. Now, I need to offload the backups from the primary on to the standbys.

1. cancel managed recovery

2. connect to target(standby) and catalog and backup the standby

3. put standby in managed recovery mode.

I think following these steps, I can restore primary(?). Now, My question is, how can I use these standby backups to clone/refresh databases? I tried it by connecting to target(primary), catalog and auxiliary but rman is using the primary backups instead of standby's to refresh the auxiliary database.

View 7 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 :: How To Create Standby Database Using RMAN

Jul 25, 2011

I am trying to create the Standby database using RMAN.

I have first created an auxiliary instance followed by the password file for the instance and the registering it it listener.

Below are the parameters of the pfile of the standby database and followed by the command issued at the RMAN prompt.

PFILE parameters [STANDBY]
orcl.__db_cache_size=293601280
orcl.__java_pool_size=8388608
orcl.__large_pool_size=8388608
orcl.__oracle_base='F:appdsharma'#ORACLE_BASE set from environment

[code]....

View 3 Replies View Related

Data Guard :: How To Create Standby Database Without And With RMAN

Oct 19, 2011

How to create a standby database without rman and with the rman..?

View 1 Replies View Related

Data Guard :: Physical Standby Database Backup

May 9, 2013

I have Oracle database on Oracle 10g R2 with physical as well as logical standby database.

1) Is is necessary to take Physical standby database backup?
2) If 1) yes then Which RMAN backup is preferred?with catalog or default?How to take backup as different location?
3)how to Restore that backup?How to ensure backup is valid?

View 4 Replies View Related







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