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
97
questions
0
votes
0
answers
364
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
...
- 868
0
votes
1
answer
27
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 ...
- 125
0
votes
1
answer
81
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 ...
- 109
0
votes
0
answers
9
views
How to check if a new Oracle PDB has been replicated successfully to the standby side?
How can I check if a newly plugged in 19c PDB on the primary has been replicated successfully (automatically) to the DataGuarded standby side?
- 29
0
votes
2
answers
420
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 ...
- 29
0
votes
2
answers
231
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 ...
- 506
0
votes
1
answer
225
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 ...
0
votes
1
answer
141
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 ...
- 656
0
votes
0
answers
1k
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
0
answers
445
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; ...
- 29
0
votes
1
answer
65
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....
0
votes
1
answer
625
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 ...
- 506
0
votes
1
answer
624
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 (...
- 29
0
votes
1
answer
87
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 ...
- 33
0
votes
1
answer
133
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/...
- 157
1
vote
1
answer
372
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 ...
- 13
0
votes
1
answer
446
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 ...
- 1
0
votes
0
answers
56
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, ...
- 125
0
votes
1
answer
189
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 ...
- 505
0
votes
1
answer
2k
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 ...
- 11
1
vote
0
answers
116
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 ...
- 11
0
votes
1
answer
182
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 ...
- 125
0
votes
1
answer
3k
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
1
answer
3k
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)...
1
vote
1
answer
572
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 ...
- 125
0
votes
1
answer
266
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 ...
- 1
2
votes
1
answer
83
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)...
- 123
1
vote
1
answer
2k
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, ...
- 23
2
votes
1
answer
1k
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 ...
- 131
1
vote
1
answer
164
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 ...
- 141
0
votes
1
answer
19k
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
1
answer
116
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 ...
- 157
0
votes
1
answer
585
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 ...
- 157
0
votes
1
answer
307
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 ...
- 868
0
votes
0
answers
423
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 ...
- 12.2k
0
votes
1
answer
5k
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 ...
- 101
0
votes
1
answer
5k
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 ...
- 868
1
vote
1
answer
2k
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 ...
- 11
2
votes
1
answer
3k
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 ...
- 868
2
votes
1
answer
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 ...
3
votes
0
answers
386
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
0
answers
796
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
1
answer
178
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
0
answers
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
1
answer
1k
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
1
answer
244
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
2
answers
1k
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
1
answer
321
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
0
answers
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
1
answer
631
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 ...
- 101