Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
14 views

How to retire a physical standby in Oracle 11.2

I have a production Oracle 11gR2 RAC database with a single node physical standby. Now it has become the time to retire the old standby and pass that role to a RAC on fresher hardware. We don't use ...
0
votes
0answers
8 views

Oracle 11G DataGuard: infrequent change of Log Archive Destination Role

currently we have the weired behavior of our DataGuard-Setup, in which the primary database somtetimes changes the role of "log_archive_dest_1" from "valid_for=(ALL_LOGFILES,ALL_ROLES)" to ...
0
votes
1answer
17 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 ...
0
votes
0answers
257 views

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor at the time of switchover using data guard broker

I have a oracle data guard setup with nodes - one as primary and other as physical standby. I also, have configured the data guard broker on it. The problem is when I tried to switch over , I just ...
0
votes
0answers
21 views

Error While Restoring Standby Database from RMAN Backup of Primary Database

My Standby Database was corrupted. So i took primary database backup using RMAN. Transferred to my standby database. On standby, on startup nomount, restored standby control file then on mount stage, ...
0
votes
0answers
9 views

Error While Restoring Standby Database from RMAN Backup of Primary Database

On standby database i got error while restoring rman backup of primary database. Some targets not found. ORA 06100 no channel to restore a backup or copy of datafile datafile_number
1
vote
1answer
41 views

How to verify that a certain commit has been transmitted to standby

Scenario: Oracle Data guard 12c with 1 primary and 1 standby, Max. Av. protection mode Primary open, standby mounted (all green in OEM) Perform a dummy CTAS in primary Question: Without opening ...
0
votes
0answers
26 views

Does data guard support Oracle Warehouse Builder?

Does data guard support Oracle Warehouse Builder (both 11.2.0.4)? If not, what is the procedure to setup/configure my OWB project (repository, workspace, control center service...) on the standby ...
0
votes
1answer
85 views

RAC, data guard, physical stand by and impdp

We're setting up a RAC 2 nodes data guard 11g environment, with a remote physical standby (2 nodes also) We receive the client's data he exports with expdp. We have imported his dump in the primary ...
0
votes
1answer
54 views

Modify an Oracle Dataguard destination database

I'd like to set up some Oracle triggers to take action after rows are inserted, but I can't do this on our production database because it's controlled by a vendor. One alternative I was looking at is ...
1
vote
1answer
97 views

How does direct path load work when dataguard is enabled?

There's a few posts about direct path and dataguard but I just want to understand exactly how it actually works. How maybe I made an incorrect assumption, but if direct path means it writes to the ...
1
vote
1answer
689 views

Startup NOMOUNT and Startup MOUNT on dataguard oracle

I have a question here about Oracle data guard. After performing a switchover, we shutdown the new standby database and startup it. At this stage, sometimes I find DBA performance in 2 different ...
0
votes
1answer
108 views

ERP (Oracle) real time backup [closed]

I work in a small company, that runs an ERP that holds about 600MB of data. My task at hand is, to find a way to always have real time backup of the erp (Oracle 11g) that can be retrieved easily (so ...
0
votes
3answers
75 views

Oracle Data Guard - redo logs not in chronological order?

The disadvantages section of the Wikipedia entry for Oracle Data Guard says: If the network link connecting primary and standby is over-subscribed, the redo logs are not applied in chronological ...
1
vote
1answer
136 views

Can a production Oracle DB server also have a dataguard active standby for a different production database?

If you have a production oracle database (PRIM1) protected using Oracle Dataguard to a standby (STBY1) physical server in a different data centre, the standby server needs to be a similar ...
4
votes
1answer
634 views

Oracle: How to gather stats in a logical standby database?

I have a Primary and a (logical) Standby Database. The Schema 'APP' gets synced. Now a User has performance issues running a query against some tables in this 'APP' schema of the Standby Database. On ...
1
vote
0answers
560 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. ...
1
vote
2answers
3k views

Oracle RAC with single node Data Guard physical standby

Best practices for Oracle 11gR2 Data Guard implies that the primary and standby databases should have the same layout, eg. RAC to RAC. What special considerations would one need to take into account ...
0
votes
0answers
416 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 ...
2
votes
0answers
959 views

Standby controlfile error

I am doing dataguard. I have manually done a backup for the standby database. It was working fine. Problem arose when I used the standby controlfile. On the primary, I have created a standby ...
1
vote
1answer
276 views

Ora - 00088 error: command cannot be executed by shared server

I get this error from the database when I run the query: select status, error from v$archive_dest where dest_id=2; It's a dataguard environment. I have never seen this problem before. I'm not ...