|
||||
|
Hello, A question from Application Teams or the business, does dataguard supports hetergenous platforms, means can I have my production in linux and dataguard (standby) in windows environment, the answer is Yes. This is possible from 11g onwards where you dataguard environment’s platforms can vary. Look the metalink document 413484.1, which describes the […] Normally, archived redo log files in a flash recovery area that were backed up to a tertiary device or made obsolete (as defined by the RMAN retention policy) are eligible for deletion. The archived redo log files that are backed up or obsolete can eventually be deleted automatically to make space if the disk space […] In RAC, you may all know about a TAF services which gives the failover capability to availability instances when the preferred failed. But how does this can work in when you have a Dataguard Environment with Primary and standby. Well answer is until 10g/11gR1 create a trigger like below and manage the service based upon […] We all know that sys password is required and should be same on both the primary and standby databases, and many times during switchover, failover we encountered, ORA-01017: invalid username/password; logon denied, due to password mismatch etc. From 11g Onwards, a new parameter REDO_TRANSPORT_USER has been introduced to overcome this issue, […] Dear All, Attached the document for all your reference, which I found very useful and informative on dataguard best practices. this also helps in diagnosing and tuning dataguard related issues. Enjoy reading. http://db.geeksinsight.com/wp-content/uploads//2012/10/dataguard_bestpractices.doc -Thanks Geek DBA A call today from one of my friend regarding switchover issue, once the role swap has been performed the standby (current primary) is not able to ship the redo log files. Verification:- 1) v$managed_standby in production(current standby) stucks at sequence “waiting for log” 2) Trace files shows Redo shipping client performing standby login OCISessionBegin […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!