Today I did something very dumb when working with a vendor to trace and issue and rendered our Data Guard physical standby database unusable. I added an AFTER LOGON ON DATABASE trigger which collected information about a session and wrote it to a table. 848 more words
Tags » Data Guard
FASTSYNC is a new LogXptMode for Data Guard in 12c. It enables Maximum Availability protection mode at larger distances with less performance impact than LogXptMode SYNC has had before. 533 more words
One of the problems I have seen when deploying Data Guard for systems such as RAC One Node and policy managed databases was the static listener configuration you needed in 11.2. 2,187 more words
Create data guard user
create user dg identified by dg default tablespace users; grant create job to dg; grant create session to dg; grant manage scheduler to dg; grant select on dba_scheduler_job_run_details to dg; grant select on dba_scheduler_notifications to dg; grant select on v_$archive_dest_status to dg; grant select on v_$database to dg; grant select on v_$instance to dg; 404 more words
The ObserverReconnect configuration property specifies how often the observer establishes a new connection to the primary database. When this property is set to the default value of 0, it prevents the observer from periodically establishing a new connection with the primary database. 85 more words
How to Setup and Configure a New Data Guard Environment.
1. Label the disks.
sys90_oracle\>sudo /kelly/admin/bin/oracleasm createdisk primary_data /dev/mapper/mpathgp1 sys90_oracle\>sudo /kelly/admin/bin/oracleasm createdisk primary_fra /dev/mapper/mpathip1 sys90_oracle\>sudo /kelly/admin/bin/oracleasm scandisks… 1,322 more words