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

28 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
362 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: ...
2
votes
1answer
3k 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 ...
2
votes
1answer
960 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 ...
2
votes
0answers
2k views

What is the nature of "LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2"?

I'm not sure when this started, but for the time being the primary database instances in a physical standby configuration logs this message on every redo log switch. *********************************...
2
votes
1answer
295 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 ...
1
vote
0answers
110 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 ...
1
vote
1answer
142 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 ...
1
vote
0answers
713 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 ...
1
vote
0answers
3k 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
0answers
2k 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 ...
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=(...
0
votes
0answers
468 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....
0
votes
0answers
239 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; ...
0
votes
0answers
51 views

Oracle 19c standby - redo transport errors

I have a 19c RAC Standby database on RHEL6 using dataguard, however, I’m currently getting a “ORA-16737 redo transport device dir standby has an error” msg. I’ve tried recreating the password file and ...
0
votes
1answer
360 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 (...
0
votes
1answer
59 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 ...
0
votes
1answer
297 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 ...
0
votes
0answers
54 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, ...
0
votes
1answer
156 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
1answer
228 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 ...
0
votes
0answers
371 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
219 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
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
2k views

From RAC to Standby RAC With Active Dataguard

I have oracle database 11.2.0.3 with RAC feature , with 2 node on oracle linux 6.4 : ol6-112-rac1 and ol6-112-rac2 I want to create active data guard with RAC feature from this database , these ...
0
votes
0answers
1k views

Oracle 10gR2 Data Guard Switchover

I need some help! I have a scenario of oracle 10gR2 database replication using data guard. I have selected the data guard command line interface. After my initial setup I can ship and apply logs from ...
-1
votes
1answer
104 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 ...
-1
votes
2answers
2k 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 ...
-2
votes
1answer
129 views

Oracle dataguard - Redo apply

In a low bandwidth environment when a transaction commits that generates a large amount of redo data will cause other independent transactions to slow down. This is because the redo data of small ...