The dataguard tag has no wiki summary.
1
vote
1answer
69 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 ...
2
votes
1answer
102 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
127 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
826 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
147 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
2answers
320 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
109 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 ...
