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

Filter by
Sorted by
Tagged with
0 votes
1 answer
27 views

Migration of Data Guard HW Servers to Cloud Servers

I'm looking for information & advice on the best way to migrate from a hardware Oracle 19c Data Guard server pair to an Oracle 19c Cloud Data Guard server pair. Our configurations currently are: ...
P_J's user avatar
  • 1
0 votes
1 answer
32 views

How to recover the standby database after opening

If I have standby which is db role is PHYSICAL STANDBY and it is MOUNTED. So, when I open it read/write the standby will be destroyed. (I have DataGuard) So, basically do I need to mount it again and ...
paganini's user avatar
  • 118
0 votes
0 answers
42 views

Querying V$ARCHIVE_DEST_STATUS

-- Oracle 19c when querying v$ARCHIVE_DEST_STATUS, I get the following output: SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ#,APPLIED_SEQ#,APPLIED_THREAD# FROM V$ARCHIVE_DEST_STATUS ...
datascinalyst's user avatar
0 votes
1 answer
52 views

Problem in Oracle 19c Replication

Replication is working fine on the other servers, however on DB_B there's some problem; It is unable to receive archives. Can someone help me out? If I have missed any parameters, please do let me ...
datascinalyst's user avatar
0 votes
1 answer
141 views

Help with simple check for Oracle Dataguard on 19c

I am new to Oracle and needing help just getting a quick script to check Oracle Dataguard. Do any of you have a simple script that could be used to just give me a quick status on dataguard? Just a ...
jmichaelwDBA's user avatar
0 votes
1 answer
135 views

Oracle 12cR1 - How to Switchover In Multiple Physical Standby Environment With Cascaded Standby Scenario

Current Environment: 12cR1 RAC Production Database -> Let's say PROD 12cR1 Single Instance Physical Standby (Active Data Guard) -> Let's say DR1 Planned Environment: 12cR1 RAC Production ...
rndm_acct1's user avatar
0 votes
0 answers
35 views

Cascading DR - Switchover issue in Oracle

I have 3 databases:A, B, C. A is the primary database, and the log_arhive_dest_2 parameter is set accordingly: log_arhive_dest_2=service='A' ASYNC valid_for=online_logfile,PRIMARY_ROLE B is the ...
datascinalyst's user avatar
0 votes
0 answers
47 views

Performance issues after activating second remote Data Guard

I have a primary database that has two remote data guard. Second data guard was configured for a DC migration on new DC. Second remote data guard was installed on the same DC (and subnet) with primary ...
skalkanci's user avatar
0 votes
1 answer
310 views

Rolling Upgrade (with logical standby) from 11g and 19c question

Let's say we have the following upgrade map: server1 (11g production db) ---> server2 (11g logical standby db) then we upgrade the 11g logical standby db to 19c server1 (11g production db) ---> ...
Astora's user avatar
  • 713
0 votes
1 answer
151 views

What could be the cause of the ORA-12638 error when setting up Oracle Data Guard?

I'm configuring Oracle Data Guard and I'm experiencing ORA-12638. I have the Oracle 19c database on a Windows Server 2019. In the DR site, I can connect to the primary with no problem. But connecting ...
Poco Ocop's user avatar
-1 votes
1 answer
831 views

I want to change the location of redo files on standby db

my db is generating redofiles to a certain path, lets call it 'old/path', and i want to move it to a new path, lets call it 'new/path' in oracle can somebody help?
dbafix's user avatar
  • 62
0 votes
1 answer
766 views

Upgrade Oracle DB from 12C to 19C with minimum downtime

We are planning to apply the below steps --> Export Live DB setup on the Oracle version 12C Import on the new DB setup on version 19C At this point, V12, and V19 schema structures will be exactly ...
rajan dawra's user avatar
0 votes
1 answer
213 views

Use Oracle standby DB as fallback - stop log apply and switchover later?

I am working on a possible scenario, where a big data changes would happen on oracle dataguard primary (a large DB) and if something is wrong with the data quality after I would like to use my standby ...
ultimo_frogman's user avatar
0 votes
1 answer
378 views

Oracle Data Guard - Wrong Path with new created Data Files

I've created a Standby Database with the following duplicate command: run { duplicate target database for standby from active database spfile parameter_value_convert 'ORCL','ORCLSTBY' set db_name='...
msak85's user avatar
  • 3
0 votes
1 answer
86 views

Is possible to install Oracle data guard free? [closed]

I need to install an Oracle database and Oracle data guard. It's only for formation and education, no production or something like that. I've saw Oracle Xe don't have these feature. Is there some way ...
Miguel7799's user avatar
0 votes
0 answers
38 views

Are there a logs to harvest on Oracle Active Data Guard instance?

We are trying to see if there is a way for cloud/SaaS-based( like AirByte or Fivetran) CDC/replicate provider to harvest logs on Oracle active data guard instance. Any ideas?
LeoG's user avatar
  • 1
0 votes
1 answer
602 views

Oracle non-CDB to CDB - Do I need to recreate dataguard?

To convert from non-CDB to cdb it's necessary to install a new instance as CDB and so, to use dbms_pdb.describe in the non-CDB database to generate a xml of the non-CDB to add as a PDB in new CDB ...
Astora's user avatar
  • 713
0 votes
0 answers
4k views

How to solve Error ORA-16810: multiple errors or warnings detected for the member?

Oracle Enterprise Manager 13.5 constantly reports Error ORA-16810: multiple errors or warnings detected for the member. ... Target type=Database Instance Target name=xxxx Categories=Availability ...
r0tt's user avatar
  • 1,008
0 votes
1 answer
183 views

Stop Dataguard configuration to test standby database

I would like to know how it would be the correct way in which I should proceed to stop the Dataguard configuration in order to perform a series of tests on the standby database. It turns out that I ...
miguel ramires's user avatar
0 votes
1 answer
578 views

how oracle data guard operate SCN?

when use data guard, primary propagate redoLog and standby apply redo log. the transaction inner redo log was applied on standby will has same SCN with primary ? the apply action will cause the ...
Chinaxing's user avatar
  • 109
0 votes
2 answers
2k views

Rebuilding an Oracle 19c Standby Database after plugging in a new PDB

I have an Oracle 19c Dataguarded physical standby DB setup running on Linux 7. The container DB had one PDB but I've now just plugged a new PDB into the primary. What do I need to do to get this new ...
Franco's user avatar
  • 51
0 votes
2 answers
2k views

Is DB_FILE_NAME_CONVERT just needed when in the same machine?

I am a little confuse. I have created a primary database with DG names +DADOS AND +DGARC, and the standby (in another server) with DG names +DATA and +FRA. I don't have configured the ...
Astora's user avatar
  • 713
0 votes
1 answer
796 views

Data Guard 12.2 without Force Logging

I would like to know your opinion and experience in a specific setup I want to apply to a Production Database that is configured in Oracle Data Guard with one Standby. It is not an active data guard ...
Roberto Hernandez's user avatar
0 votes
1 answer
510 views

Oracle Active Dataguard and User passwords

I support a database that uses an active dataguard physical standby. The standby database is configured to let users access the read only standby for read only queries and reporting. We do this ...
Patrick's user avatar
  • 678
0 votes
0 answers
4k views

RMAN-08120: warning: archived log not deleted, not yet applied by standby

BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; In Data Guard environment this command tries to 1.backup archivelog before starting backup 2.delete archivelog before starting backup 3.backup database 4....
Elnara Mustafayeva's user avatar
0 votes
0 answers
1k views

Oracle 19c with SAP System - ORA-12154: TNS:could not resolve the connect identifier specified For Physical Standby

Oracle 19c + SAP system. On primary side I have a problem when transporting logs to Data Guard side. Outputs from primary side: SQL> select status, error from v$archive_dest where dest_id=2; ...
jrdba123's user avatar
0 votes
1 answer
178 views

Need for backup with Active Dataguard

When exploring the features of Oracle Active Dataguard, I found that one of them is block change tracking to allow the standby db to take the load of backups instead of the primary database doing them....
Mathew George's user avatar
0 votes
1 answer
2k views

How to change the thread of redo logfile group in standby database?

Is there some way to correct the thread of redo logfile group? it's ok the thread to be wrong? executing the following query I get de logfile groups, thread and members: set linesize 2000; set ...
Astora's user avatar
  • 713
0 votes
1 answer
2k views

RMAN restore of primary database - impact on standby database

I've just restored an 11g primary DB that was destroyed. Restored the controlfile from tape and performed a full restore, recovery, and open resetlogs. Looks fine now. How will my physical standby (...
Franco's user avatar
  • 51
0 votes
1 answer
143 views

Oracle 11g migration to AWS

I have an on premise oracle 11g database that i have to migrate to an EC2 instance hosting Oracle 11g in AWS. I have three options to achieve this Use Oracle Data guard to replicate the on premise ...
Vishesh's user avatar
  • 33
0 votes
1 answer
1k views

How to get the oracle dataguard log transfer and applying status?

Logs are transferred from primary db instances to stand-by db and applied continuously. Please advise how to get the report in the following format (preferably in browser) at some frequency (say 5sec/...
AVA's user avatar
  • 167
1 vote
1 answer
1k views

Move Oracle Database to New Server with Dataguard in place

I have a live Oracle Database with Dataguard in placed. I want to migrate live database to new server as tech refresh, but only Primary database. How I can achieve this? I have ideas on how I want to ...
Rahmat Saari's user avatar
0 votes
1 answer
840 views

Oracle data Guard status (active/passive)- version 11g

I have 2 servers: Primary (ABCUAT) and Standby (ABCUAT1) configured as Active-Standby DataGuard by previous DBA. When I took over the system, I think DataGuard was not in sync, but I could not ...
Weng's user avatar
  • 1
0 votes
0 answers
70 views

Oracle Dataguard old sequences

After having set up a dataguard environment with Oracle 12c I notice that when I execute the following command in the primary it shows me the archivelogs: select sequence#, first_time, next_time, ...
miguel ramires's user avatar
0 votes
1 answer
260 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 ...
Nick Kavadias's user avatar
0 votes
1 answer
4k 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 ...
IronMike's user avatar
1 vote
0 answers
177 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 ...
IronMike's user avatar
0 votes
1 answer
484 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 ...
Arnaldo Raxach's user avatar
0 votes
1 answer
5k 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 ...
Iris Catharina's user avatar
0 votes
1 answer
4k views

ORA-16706: Data Guard broker worker process not available [closed]

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)...
ram kumar's user avatar
1 vote
1 answer
777 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 ...
miguel ramires's user avatar
0 votes
1 answer
388 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 ...
yifan's user avatar
  • 1
2 votes
1 answer
132 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)...
Soheil's user avatar
  • 123
1 vote
1 answer
3k 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, ...
David's user avatar
  • 23
2 votes
1 answer
2k 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 ...
hunterjrj's user avatar
  • 131
1 vote
1 answer
236 views

Using hard-coded host name in logon trigger

I need to write a trigger which prevents certain users from logging into the production database. We use Active Data Guard. If I hardcode the Linux hostname in the trigger to verify the host is ...
oradbanj's user avatar
  • 141
0 votes
1 answer
26k 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 ...
Matheus Cunha's user avatar
-1 votes
1 answer
316 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 ...
AVA's user avatar
  • 167
0 votes
1 answer
777 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 ...
AVA's user avatar
  • 167
0 votes
1 answer
412 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 ...
r0tt's user avatar
  • 1,008