I wanted to know whether we can configure single data guard for multiple database (instances), has this been done anytime in the past .
We are a small business and growing at rapid rate. we want to cut down the cost at the same time.
Any other method or approach that is practical and economical to synchronise database between multiple production system into centralised DR system.
My oracle version is 11.2.0.2 RAC RDBMS on RHEL 5.6.
At my standby site my physical standby database is on 4 node cluster with all 4 instances up. I need to disable 3,4 instances so that we want it to run on only 1,2 instances.To disable the instances do i need to stop apply(mrp) process. And the apply node is node 1.
We have installed "Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production" on server. we created one SID(agile9d) and configured listener(LISTENER) on 1521.This is working fine.
Now,we want to create one more SID(XXXX) on the same server.So,Need some clarification on below points.
(1). Do I need to configure one more listener for new SID?(Ex: LISTENER1)?
(2). Can I use the 1521 port again while configuring new listener?
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.
My requirement is to Run 2 instances of forms 11g R2 parallel at a time(means running 2 urls of 2 instances same time). I have tried with installing 2 instances but when i install and configure my 2nd instance then my 1st instance services are shutting down.At a time it is running only one instance services.
And also i have tried with installing 2 Cluster instances of 11g R2 Forms but same thing happening as above.
how to run 2 instances of Forms 11g R2 parallel and also suggest me to install instances in same domain or different domain because with same domain 2 instances it is creating only one config file..so i tried with different domains. Different Config files created but only one instance service is running.
Is it possible to use the Oracle HAIP feature to bond multiple network links between Active and Standby database ?
Does this require a seperate license ?
Basically, I was looking for a solution for bonding the muliple WAN links that we have between the active and Standby database.
how to insert the data in multiple bases( Same table structure in different bases) using the multiple database links?
View 4 Replies View RelatedI 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
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 Relatedcreating 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.
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 Relatedi 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]....
Here we have a data guard environment with db1(db_unique_name) as primary and db2(db_unique_name) as physical standby database. Also we configured one schema on a third machine as catalog database using following steps. The steps executed in catalog database(appsdb):
SQL> create tablespace rmancatlog_tbs datafile '/u01/app/oracle/oradata/NEW/rman_catalog.dbf' size 500M autoextend off extent management local segment space management auto;
SQL> create user rman identified by oracle
2 default tablespace rmancatlog_tbs
3 quota unlimited on rmancatlog_tbs
4 ;SQL> GRANT connect, resource, recovery_catalog_owner TO rman;
RMAN> create catalog;
recovery catalog created
Added tns entries of catalog database in primary and standby. Then from primary database we tried to register to catalog database. It is showing that it is registering. But every query afterwards in rman is throwing the error. Below are the steps and error:
[oracle@db1 ~]$ rman target sys/oracle catalog rman/oracle@appsdb
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Aug 13 21:39:32 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: NIOS (DBID=1589015669)
connected to recovery catalog database
[code]....
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'
Currently, the only way I can find of doing so is to try to disable an instance, and if it is already disabled, it warns you that its disabled. This is not exatly an ideal solution! How do I simply run a query or issue a crs command to list all disabled database instances.
View 1 Replies View RelatedWe are planning to install second instance of Oracle 11gR2 in Linux server 2.6.39-400.21.1.el6uek.x86_64 x86_64. This is something we never haven done before. The existing instance has all the standard ports:
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Enterprise Manager Console HTTP Port (pterpdb02) = 1158
Enterprise Manager Agent Port (pterpdb02) = 3938
What ports should we select for second listener and enterprise manager? Is there anything else that we need to know before we install the second instance?
Installed Grid Control 10.2.0.2.0 on Windows Server 2003R2 32-bit. Immediately upgraded to 10.2.0.5.0. Both install and upgrade went fine, Grid Control can see its own database in the list of targets, looks good.
I then installed Oracle 11gR2 11.2.0.1.0 64-bit on Windows Server 2008R2 64-bit and created a new database. I then installed the 10.2.0.5.0 agent manually on the server via OUI. Agent install went fine, secured and started properly.
The problems I'm having is Grid Control can't seem to see the database instance. If I go to "Targets", GC can see the host just fine, shows that its up and can see targets for the listener (Up), the agent at port 3872 (Up), and the database instance (Down). Drilling down to the database instance, it shows that the instance is not up (though it is as I can connect to it from a different machine and run queries against not) and the Agent Connection to Instance is down with the error:
Failed to connect to database instance: (UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS settings etc...
Also, pulling up the "Alerts" tab for errors showed the following for Metrics "Access to Important Tables and Views", "DB Data Files Permissions", and "DB Control Files Permission":
Target: SR3
Type: Database Instance
Metric: Access To Important Tables And Views
Collection Timestamp: Jun 11, 2010 11:11:26 AM
Error Type: Collection Failure
Message: 1804 at c:oracleagent10g/sysman/admin/scripts/db/esaDbUtils.pl line 290.
There are also several "Missing Properties : [AdrHome,ConvertFromCharset,needCharsetConvert]" errors listed too.
I've looked into the 1804 error and from what I could find, its a perl-related issue with not being able to get the ORACLE_HOME information.
- I verified that ORACLE_HOME was set in the environment variables and even rebooted to make sure it was being picked up properly. That didn't work.
- I added "$ENV{ORACLE_HOME}='c:\oracle\product\11.2.0\dbhome';" to the esaDbUtils.pl file. That didn't work either.
- I added the GC security certificate to the trusted certificates on the target box in case it was some kind of SSL issue. I don't get the annoying "invalid certificate" warning, but it didn't fix it.
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
I have a clients who currently implementing an application that using Oracle 10g in 20 distributed location. Each location will have its own database server and locally managed. I plan to create a Disaster Recovery (DR) Centre for this client in centralised location. I plan to setup 20 Application Server but only one database server with 20 instances. My question, can the Dataguard manage the replication between 20 database (with single instances) and single database (with 20 instances? The reason we design such way is to reduce the license cost of Oracle.
View 9 Replies View RelatedI have two node rac running on SAN with ASM , i want to configure a single instance standby database for this.
View 2 Replies View RelatedTo have physical standby database, the hardware and software versions should be same, including patch sets?
View 3 Replies View RelatedThe GAP archived log can not transport to target database by auto, how can i do?
Sun May 27 06:32:59 2012
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 161-161
DBID 1820932955 branch 775456988
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter is defined to a value that is sufficiently large enough to maintain adequate log switch information to resolve archivelog gaps.
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;
I am planning to use Data Guard facility in Oracle 10g database.
1) I would like to have a standby database, which can be used if the primary goes down and also for reporting and other queries (read-Only).
2) What is the difference between Physical and Logical standby database. I have to explain non-technical users (management) regarding this.
3) What is Sync and Async redo log apply?
4) When i manipulate data (Insert,Delete,Update) in logical standby database, will these changes reflect in Primary database synchronously?
5) Which type of REDO APPLY is better: Managed Recovery Process(MRP) or Real Time Apply(RTA)?
6) can the redo data be deleted if its obsolete or is it deleted automatically by oracle?
7) If i want to take backup, should i take it from primary or standby database? If standby, then the database should be in which mode (Read-only or Recovery Mode)
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?
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 Relatedwe 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 RelatedDuring 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]....
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
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