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


ADVERTISEMENT

Data Guard :: Running Observer On Different OS As Compared To Primary And Secondary DBs

Jan 28, 2013

Primary RAC and Standby RAC databases are using version 10.2.0.4. They are configured & controlled via Data Guard Broker. Currently, the observer runs from one of the Standby nodes. All are on Solaris x86 64bit OS version 10.

Now, I have to move Observer to 3rd DC and I am looking If I could use another OS for observer instead of same as DB OS version. Why? Our new infrastructure is on RHEL Linux, therefore, I would like to deploy observer once and then wait for existing databases to be upgraded and moved to RHEL. Also, i understand that database and observer software should be of same version e.g. 10g, 11g.

My question is what if i install & configure observer on RHEL ? The end result would be:

1. Primary DB: Solaris 10, Oracle Software binaries version 10.2.0.4
2. Secondary/Standby DB: Solaris 10, Oracle Software binaries version 10.2.0.4
3. Observer: RHEL 5.8, Oracle Software binaries version 10.2.0.4

Is it accepted mix configuration say e.g. to run for six months? Also, it would be grateful to know if there any license implications when running observer on a different node running no databases at all.

View 2 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 :: Disaster Recovery Best Practice With SAN

Mar 29, 2011

I have a SAN systems with primary and secondary interfaces. i need to know what is best practice of oracle to use disaster recovery features, with automatic or manual failover concept.

example.

Primary Server Duty Station 1 New York

Secondary Server Duty Station 2 Los Angelous

requirement : If primary server in DS 1 gets fire and completed get down then secondary server DS 2 should become primary server and reply to client request with AUTO or Manual failover concept.

View 6 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 Managed Recovery Process Is Not Working

Mar 15, 2012

My standby database was working fine which was running in maximum performance mode .Suddenly i found that logs are not being applied though archived logs are received from primary database.i issued the command in mount mode: alter database recover managed standby database disconnect from session;

altered database this command runs successfully. but MRP process in not initiated which i confirmed with the query (select process,status from v$managed_standby;)

View 1 Replies View Related

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

Data Guard :: Oracle 10G - Disaster Recovery Site

Dec 21, 2010

Do we have any plan to create DR ( disaster site) for ORACLE 10G standard version. Since, Data Guard is not available with Standard version, can we have any another plan for the same.

View 5 Replies View Related

Data Guard :: Setup Disaster Recovery Site

Aug 25, 2012

1.What are the basic things we need to analyze before we recommend the business to go for oracle Dataguard for DR setup?

2. Do you know any technology that will replicate the schema from one datacenter[one primary database ] to another datacenter [secondary or replication database]?

3. What are the various option to configure the disaster recovery plan at schema level?

View 3 Replies View Related

Data Guard :: Stop Recovery In Specific Time

Nov 9, 2012

I'd like to stop Recovery in specific time. For instance ; My db works Day-1 and Every day Recovery starts 20:00 and finish 05:00. If it is possible that when DB time reach to sync 03:00, I'd like to stop recovery.

DB version Oracle 10.2.0.5 .....

View 5 Replies View Related

Data Guard :: Configuration - Incompatible Media Recovery Is Active

Dec 1, 2011

I have created dataguard between two instances hosted in two different servers. I have done switchover from primary to standby & then again standby to primary with DGMGRL utility.

1- When I done switchover to primary & trying to open standby database in readonly mode it was giving below error-

ORA-01154: database busy. Open, close, mount, and dismount not allowed now

Why this error was coming ?

2- As I was not able to open standby database in read only mode, I have executed below command-

alter database recover managed standby database disconnect from session;

which return an error as-

ORA-01153: an incompatible media recovery is active

After this I have executed-

alter database recover managed standby database cancel;

which executed successfully.

& then after standby database open in read only mode.

Why above error was coming ?

3- After this I had tried to check the checkpoint_change# & controlfile_change# from primary database and result shows both number were different.

Why they are not matching ?

View 6 Replies View Related

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 :: 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 :: Background Media Recovery Terminated - Error In Sequence?

Sep 19, 2012

I noticed that my standby server was behind the prduction one.In the error log I noticed: ORA-00600: internal error code, arguments: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []

then
MRP0: Background Media Recovery terminated with error 448
Recovered data files to a consistent state at change 286116915

This error happens in sequence: Recovery of Online Redo Log: Thread 1 Group 4 Seq 8830 Reading mem 0I found this archive log in standby and it is same size as in the production one.

View 9 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 :: 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 :: 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

Recovery Manager (RMAN) :: Delete Obsolete Command Not Deleting Backupset Automatically

Nov 30, 2012

I am trying to delete the backupset using Delete Obsolete command, but i am unable to get the success. As per the oracle Doc after completion of Retention Period oracle automatically deletes the backupset. I have set the retention period of 8 days.

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

Any Data Compression Wizards That Automatically Suggest Level At Which Data Should Be Compressed

Jun 29, 2011

whether Oracle has any capability of automatically checking which lossless compression algorithm it should apply by analyzing a data stream on data load? Does Oracle have any compression advisors/wizards that would make recommendations as to type and level of compression?

View 3 Replies View Related

Backup & Recovery :: Change Archive Log Mode During DB Running?

Aug 24, 2011

changing archive mode during DB running.Before in 9.2, 'ALTER SYSTEM ARCHIVE LOG START/STOP' is available for this job. But, after 10g/11g, it cause 'archive log stop has been deprecated'.

However, for my practice, I need to estimate archived logs size before backup them, so I need to stop archive log for a while and enable it later during DB running.

I check Oracle documents, it only mentions changing archive log mode at DB mounted but not open.

View 12 Replies View Related

Backup & Recovery :: OCIServerAttach Returns ORA-1034 Even If Database Is Up And Running

Oct 9, 2012

We are using OCI call library to connect to Oracle database through one application. When we try to run this application through valgrind( a memory leak detection tool for linux) then, OCIServerAttach() call is failing to connect to db and it says that "ORA-1034 :Oracle not available"," Oracle instance may be down", etc. However, our oracle instance is running and database is open. When we run our application normally ( not through the tool) then everything is working fine.

View 11 Replies View Related

Backup & Recovery :: Running RMAN Commands In RUN File To Duplicate A Database

Dec 17, 2012

I have a RUN file within a script to duplicate a database. As part of this RUN file I also run the command configure controlfile autobackup off; as part of this RUN file. However, this command has turned off backup of the control file on the AUXILLARY database (i.e. production) as well as the TARGET database (test). Is this supposed to happen?

My run file is:

rman TARGET sys/XXXX@${DB}-SOURCE AUXILIARY /
RUN {
allocate AUXILIARY channel a1 type disk;
allocate AUXILIARY channel a2 type disk;
allocate AUXILIARY channel a3 type disk;
allocate AUXILIARY channel a4 type disk;

[Code]....

View 7 Replies View Related

Send CLOB Data Automatically Using CDC?

Jan 5, 2012

I want to know whether is it possible to send CLOB data automatically using CDC...i usually have to run a procedure manually to send such data to remote locations.

View 1 Replies View Related

Replication :: Materialized View Is Not Refreshing Data Automatically

Feb 14, 2012

I have created a MV on Oracle 10gR2 using dblink. Source database is AS400 DB2.MV script:

CREATE MATERIALIZED VIEW MV_BU
TABLESPACE TB_XXX
PCTUSED 0
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
[code]...

Above query should be refreshing the data every minute but I realized that its not doing it.

View 1 Replies View Related

Forms :: Upload Data Using 6i While Compiling Form Automatically Closed

Dec 6, 2010

i have create database link with msaccess2000 its working fine in forms 6i i am trying to upload data by using forms 6i while compiling form is automatically closed my code is this

begin
insert into baba1
(select *
from baba1@access_db
where dte between to_date(:block3.fdate,'dd-mon-yyyy')
and to_date(:block3.ldate,'dd-mon-yyyy')
[code]....

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 :: 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







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