Questions tagged [dataguard]
Oracle Data Guard, Oracle Data Guard Broker and Oracle Active Data Guard are the commercial names for technologies that allows physical and logical standby (slave) databases to be configured and managed with Oracle Database Enterprise Edition
81
questions
0
votes
1answer
21 views
11g dataguard broken after primary ran out of space
I have Data Guard setup with Primary (A) and read-only standby (B).
primary server (A) ran out of space on the data mount point as auto extend was turned on. I managed to revive it by adding ...
0
votes
0answers
74 views
ora-49204: recursive dde invocation at phase i - after switchover to standby
I am currently testing a data guard environment. After a switchover, which is performed successfully, I can see the following error in the alert.log of the new stand:
ora-49204: recursive dde ...
1
vote
0answers
25 views
Operation CTL_BOOTSTRAP canceled during phase 0, error = ORA-408
I am currently testing a data guard environment.
In the alert.log of the broker I always see the following message after a switchover:
2019-05-23 08:08:54.716 7fffffff 0 Operation ...
0
votes
1answer
27 views
Dataguard the datafiles are created in another diskgroup
I have a recently made physical dataguard configuration and everything works correctly so far, but I've noticed that the datafiles that are created in the primary are created in the standby in a ...
0
votes
0answers
15 views
is it possible to enable supplemental logging only on the phisycal standby database of an Oracle dataguard setup?
We have an Oracle Dataguard setup with a Primary and a Phisycal stand by database that we need to use CDC in it.
A requirement for CDC is having supplemental logging enabled, my question is if we ...
0
votes
1answer
178 views
RMAN Duplication - Oracle Data Guard - Syntax error(s) RMAN-01009 / RMAN-01008 / RMAN-01007
New to DB. Interested in Oracle Data Guard. New working with RMAN.
All of this is for testing only and does not involve any kind of production env.
Making use of ORACLE documentation:
Step by Step ...
0
votes
0answers
10 views
Keeping INSTANCE_NAME on Data Guard failover
I have a legacy application which uses a lot of PL/SQL stored procedures. It has a deeply ingrained need to know in which environment it is running, and uses the INSTANCE_NAME for that. For the sake ...
0
votes
1answer
453 views
ORA-16706: Data Guard broker worker process not available
Database version is 12.1.0.1.
We have one primary database and two physical standby database and dataguard also configured.
Dataguard sync is fine working between primary and physical standby.(No lag)...
1
vote
1answer
131 views
Rebuild dataguard configuration when standby is broken
I have an Oracle Data Guard configuration with two servers:
oradb (physical)
oradbstb (standby)
Both are running with Oracle 11g R2.
A few days ago I had problems with the standby (the server ...
0
votes
1answer
85 views
Oracle RAC and DataGuard configuration
We have deployed an Oracle RAC cluster which consists of three Oracle instances. As we are considering the HA issue, and as far as I know, the only way of Oracle HA is DataGuard. So is it possible ...
2
votes
1answer
46 views
Network line switch-over in Oracle Data Guard
We have a Primary database with a remote Standby which established using Oracle Data Guard. They can be syncing over a private Wireless Network and a Wired LAN (There are two options as network medium)...
1
vote
1answer
360 views
Problems with connecting to a remote Oracle 12c database
tl;dr
RMAN failing to connect to standby database with correct credentials.
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
Password file is correct, ...
2
votes
1answer
274 views
MSSQL Mirroring equivalent to Oracle Data Guard Snapshot Standby
Does MSSQL support an operating mode on the failover partner / mirror that is functionally equivalent to Oracle database's Snapshot Standby mode?
ie A temporary active copy of the replicated ...
0
votes
1answer
5k views
Listener Status Blocked
I'm deploying a 12C dataguard on oracle.
When performing all procedures, start the instance in the standby, as nomount. I noticed that the standby listener is as BLOCKED status, making it impossible ...
-1
votes
1answer
39 views
Whether Oracle Data Guard re-transmits logs from their starting after network interruptions?
Whether Oracle re-transmits logs from starting after any network interruptions?
If yes, Please advise on how to configure (or) instruct Oracle Data Guard to resume a failed log transfer from where it ...
0
votes
1answer
305 views
How to instruct Oracle 11g Standby database MRP to bring down as soon as applying the given archive log file?
Scenario:
Let us consider the following:
Oracle 3 node RAC.
RMAN Managed Recovery and Dataguard are configured between production and standby DBs.
The SCNs of 3 nodes are S1, S2, S3 at some point of ...
0
votes
1answer
163 views
Backup Oracle Data Guard with TDPO
We are using TSM/TDPO SBT to backup Oracle Databases. When using Oracle Data Guard with TDPO, what is the best strategy to ensure backups continue after failover/switchover?
TSM/TDPO uses a feature ...
0
votes
0answers
179 views
Can I have single tablespace excluded from DataGuard
Can I have single tablespace not being logged and excluded from DataGuard with in same database? We are trying to keep objects owned by a schema isolated in one tablespace and set those objects for ...
0
votes
1answer
3k views
Oracle Data Guard Error
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected as SYSDBA.
DGMGRL> show ...
0
votes
1answer
2k views
Setting up the Listeners for Oracle Dataguard
I setup up a Oracle 12c Dataguard configuration. To build the standby database I used the RMAN DUPLICATE command, which requires a static listener configuration.
tnsname.ora on HOSTNAMEA and ...
1
vote
1answer
869 views
Nologging materialized view
I need to create a materialized view (MV) with auto refresh every hour. After I create it, a lot of redo logs are generated (10GB per hour). I think the solution is to recreate the MV in NOLOGGING ...
1
vote
1answer
1k views
Setting DataGuardSyncLatency for Oracle Data Guard
With Oracle 12.2 there is a new parameter DataGuardSyncLatency when setting up Data Guard. I keep getting the warning:
Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent ...
2
votes
1answer
1k views
When trying to configure data guard broker I'm getting Error: ORA - 12154 : TNS: could not resolve the connect identifier specified
I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to data broker configuration and ...
3
votes
0answers
270 views
Cannot add standby database to the data broker configuration in oracle 11g
I have duplicated the primary database to standby database and then I added the primary database in data broker configuration. But when I'm trying to add standby database I'm getting following error:
...
1
vote
0answers
393 views
When trying to configure data guard broker I'm getting Error: ORA-16606: unable to find property “”
I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to my configuration and when I'm ...
0
votes
1answer
76 views
Granting Read access to Replica database (via data guard) but need to restrict the same login in production Database [duplicate]
We use Data Guard to replicate production Oracle database. We have a need to grant read access to replica DB and at the same time need to restrict that same login gaining read access to production.
...
1
vote
0answers
1k views
ORA-17627:invalid username/password;logon denied error message when trying to duplicate database in data broker
I'm trying to duplicate the database for the purpose of Data broker in windows platform. When I'm trying to duplicate using below command
DUPLICATE TARGET DATABASE TO LOCALDEV FROM ACTIVE DATABASE;
...
1
vote
1answer
539 views
What is the standard time delay taken for the data to get reflected in standby database when a new data is inserted in primary database
I've configured Data guard setup using data broker. When I'm inserting new data to the tables in primary database which is suppose to reflect in standby database. When I checked those data's in ...
0
votes
1answer
98 views
Replication using Datagaurd to FAR DR
We have already setup Oracle replication using Dataguard from a primary active site to a near DR site. The near DR is a passive site.
Is it possible to replicate from the Near DR (Passive) site to ...
0
votes
2answers
916 views
JDBC Connection on Current Primary Database After Switchover: ORA-01033 encountered
We are using Oracle Data Guard and currently testing Disaster Recovery scenarios, which is starting the application after switching over from the Primary Database to the Secondary Database.
I am ...
2
votes
1answer
208 views
Listener is not starting in my Standby database
I'm facing a serious issue in data guard installation. I'm setting oracle_sid and oracle_home and when I start the listener,error is showing as below:
C:\Windows\system32>lsnrctl start
LSNRCTL for ...
0
votes
0answers
3k views
ORA-00257, 00000, "archiver error. Connect internal only, until freed
When I was connecting to my database through SQL Developer tool I was getting error message as below:
ORA-00257, 00000, "archiver error. Connect internal only, until freed."
Cause: The archiver ...
0
votes
1answer
453 views
Using Oracle SCN to Calculate RPO
Is the difference between the SCN of primary and secondary a good indicator of RPO?
We are planning for the below logic to get the RPO.
Get the current SCN from secondary.
Get the time stamp of the ...
3
votes
1answer
2k views
Schema based replication in Oracle using Data Guard
We have active-passive database replication in our system cluster, so passive db belongs to DR class of nodes. We're trying to design zero-downtime deployment so I went out with few ideas.
Since we ...
-1
votes
2answers
1k views
How to check if dataguard is working properly?
I've a requirement for configuring data guard, but I haven't done it in the past. I'm using Oracle 11g database in Windows platform. On reading several blogs and tutorials in Internet, I managed to ...
1
vote
1answer
707 views
Unable to start listener of standby database
As part of data guard configuration, I've installed standby database using Oracle Software only and configured .ora files/folders as required. But while trying to start the listener or check the ...
1
vote
1answer
366 views
How real-time apply works in logical standby oracle?
I am a little bit confused about real-time apply services.
I've read a documentation about the services and I still have a question.
Does archived redo logs required for logical standby or not?
I've ...
1
vote
1answer
708 views
ORA-00205 error during the startup of physical standby database
Steps I have followed:-
Created a physical standby database by using DUPLICATE TARGET DATABASE.
Then checked the log gap between these two databases which was fine and in sync.
After that standby ...
0
votes
1answer
31 views
Force standby de-synchronisation for script testing
Two databases are configured in a production-standby configuration with Oracle Dataguard.
I want to test a script that supposedly detects whether the dataguard observer is in the status SYNCHRONIZED ...
3
votes
1answer
668 views
Data guard broker cascaded standby delay parameter is ignored
I have 3 databases: db01 primary, db02 standby cascading, db03 standby cascaded.
I have configured broker parameters by the following way:
DGMGRL> show configuration
Configuration – DB_HQ_DR
...
1
vote
0answers
929 views
RMAN Duplicate database errors with password file location could not be found
Running RMAN to duplicate two Oracle 12.1.0 databases, using the below, I'm faced with an error I can't seem to find an answer too.
c:\rman TARGET sys/password@TEST AUXILIARY sys/password@TEST_SDBY
...
0
votes
1answer
149 views
Oracle Data Guard:When would data rows exist in the view v$archive_gap?
I am trying to learn how to resolve the gap between primary and standby manually, the version of my oracle database is 11gr2.
What I did as follow:
At the beginning, primary and standby is ...
1
vote
1answer
1k views
Oracle Data Guard:Can archived redo log files be sent from primary database to physical standby database manually?
As a result of the configuration of firewall,the primary database can`t not send the archived redo log to physical standby database in real time,the network connection between primary and physical ...
1
vote
0answers
1k views
Why is my Redo Log Apply service “spotty”?
I have a 12c Dataguard configuration between apple (primary) and orange (physical standby). The following is my entry in ldap:
apple=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(...
2
votes
1answer
2k views
How to make dataguard switchover seamlessly
In my Dataguard configuration on a 12c environment, when I perform a switchover from primary (foo) to standby (bar) and then try to sqlplus in with user@foo, I receive the "ORA-011033: ORACLE ...
2
votes
2answers
423 views
Dataguard: preventing logical standby to loose track after flashback database on primary
We have 2 Oracle databases; a primary and a logical standby, configured with Dataguard. Whenever we have an application rollout on the primary, we create a restore point in case anything goes wrong.
...
1
vote
1answer
511 views
Dataguard parameter changed after DB bounce
I have a production environment of Oracle 11g R2 patchset 4 primary database configured with 2 standby machines.
Primary database unique_name is DBIDI
1st standby database unique_name is DBIFI
2nd ...
3
votes
1answer
3k views
Gap resolution of Logical Standby Database via Archive Log Backups
Due to reasons outside the scope of this question, we had to flashback our Logical Standby Database (at the VM level) to the previous day.
So, now i'm trying to resolve gaps in missing archivelogs ...
0
votes
1answer
286 views
data guard / network failure: deadline before global crash?
In a Maximum Availability scenario where there's one primary and one physical standby database, how long can we expect the system to run without problem when the standby site becomes out of reach (...
1
vote
1answer
1k views
Can standby database of a physical database be pluggable or vice versa?
We are currently planning to upgrade our databases from 11g to 12c. But I have some confusions regarding 12c. Here are my questions.
Can standby database of a non-container database be pluggable or ...
