Stack Overflow
Stack Overflow

Questions tagged [dataguard]

44 questions
4
votes
0 answers

EM 13c - Custom Views for Incident Manager

EM 13c Cloud control Looking to create Custom view for DataGuard incidents in the Incident Manager of the Cloud Control. Following is the Current search criteria I used for my custom view: Shows open Incidents and Problems Updated in the last 31…
R-K
  • 119
  • 1
  • 1
  • 8
2
votes
0 answers

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 initialization or shutdown in progress" error instead of…
exit_1
  • 1,240
  • 4
  • 13
  • 32
1
vote
1 answer

Need some suggestions with the following query

I need some suggestions with the following query. SQL> select value from v$dataguard_stats where name like 'apply lag'; VALUE ---------------------------------------------------------------- +00 00:21:38 where +00 --> increases to 1 if the lag is…
Karthikmu
  • 11
  • 4
1
vote
2 answers

Oracle : JDBC TNS URL Connection won't failover because listener still responding

I'm facing a stupid problem, but after some time searching online and experimenting, I'm starting to lose hope. I've got two Oracle DBs which are configured to be replicas, thanks to Dataguard. I'm using a JDBC TNS URL to connect to my DBs, such as…
mbutton77
  • 21
  • 1
  • 7
1
vote
1 answer

Weblogic datasource configuration for DB on Oracle Dataguard with PDB

We are moving to Oracle Dataguard with PDB. Currently we just point to a single DB url in Weblogic datasource configuration. How to configure the Datasource in weblogic for Oracle Dataguard with PDB ? Should we use 'JDBC Multi Datasource' ?
Jay
  • 9,189
  • 12
  • 56
  • 96
1
vote
1 answer

Replicated database for storing historical data

Only part of the data in the database is being processed by the application, the rest is necessary for reporting purposes, but it causes poor application performance. I would like to archive historical data without modifying database schema. Is…
kar8o
  • 41
  • 5
1
vote
2 answers

Oracle dataguard is not working properly because a FAL[client]

I had two databases, a primary and secondary and a configured dataguard between both, i restarted the suse linux but when starting up databases, the replication is not being done, i think i took the wrong way to startup the standby database....no it…
Patricio_Estrella
  • 25
  • 1
  • 1
  • 7
1
vote
1 answer

Dataguard broker reporting ORA-16801: redo transport-related property is inconsistent with database setting

I have set up a dataguard config, and done most of the work from within DGMGRL to avoid possible issues, its seems to be running fine, but its reporting the following problem: ORA-16801: redo transport-related property is inconsistent with database…
Rand
  • 35
  • 1
  • 6
1
vote
0 answers

Unable to sync with Oracle Standby database

I have created a standby database on Windows machine with version 10.2.0.1 For the first time for the database to sync I have copied the archive from the primary database. But on the switch from the primary database. The archive log doesn't ship to…
محمد خليل
  • 137
  • 1
  • 5
  • 13
1
vote
3 answers

Data Guard Oracle 11g

I want to do the disaster recovery in oracle 11g using data guard. But I don't the procedure or the way how to do it. I want all of someone that show me the document or the way to do it. Can anyone help me to do that? Thanks, Ung Sopolin
Sopolin
  • 576
  • 5
  • 15
  • 26
0
votes
1 answer

Oracle dataguard standby read only lag tolerance

Oracle 19c, Primary and Active Dataguard standby database. Has anyone had any luck to automatically change the session parameter STANDBY_MAX_DATA_DELAY when a user logs in to the database? We want users connected in read only mode to the Standby DB…
Eduardo Fierro
  • 1
  • 1
0
votes
1 answer

Dataguard replication on SQL Server

Can i use Dataguard replication on SQL Server 2019 (or 2022)? I have an application with several SQL Server databases containing realtime data, historical data, calculated data using realtime information, etc. Besides that, all the other…
Jefferson Fernandes
  • 1
0
votes
1 answer

Tomcat 9 datasource URL syntax to connect to an oracle DB

Im gonna do a datasource Tomcat 9.0.63 to connect to my Oracle DB. Actually we use dataguard (2 db, a main one and a backup one) In the configuration of server.xml file , in order to set the connection, i wonder in the parameter "URL" if i can use…
Ana Martinez
  • 1
0
votes
1 answer

HELPP -- Cannot start OracleServiceORCL

It's my first time asking a question here but I wanted to log with username and password on SQL*Plus and it's giving me this error ERROR: ORA-12560: TNS:protocol adapter error. After I googled for it found this answer and I tried to Start…
jor_57688
  • 1
  • 1
0
votes
1 answer

Single name for primary and standby database with Autonomous Data Guard on Autonomous Database?

How do I get one name for the primary and standby database, such that I may connect to the primary site but in case of a disaster, the same name can redirect connections to the DR automatically. Do we have such as an option in Autonomous Data Guard…
Nilay Panchal
  • 541
  • 6
  • 17
1
2 3