September 14, 2009
Oracle Performs redo shipping and authentication services between the primary and the standby using Password files and if your security protocols dictate a sys password change you will start having issues with stopped log shipping with errors like . Error 1017 received logging on to the standby ———————————————————— Check that the primary and standby are [...]
April 12, 2009
Everyone has various ways to manage scripts. I have found UDM’s in Oracle Enterprise manager to be a nice way to catalog and standardize scripts across various platforms.UDM’s or User Defined Metrics are a great way to track, alert and look at trending information using Oracle Enterprise manager . Oracle provides UDM’s on a server [...]
March 30, 2009
Well,with the record_unsupported_operations-true . I was able to capture the commands that oracle skipped. using that info i was able to write a simple piece of code to use that information to getAlter database datafile commands executed on my logical standby database which in this case has exactly the same structure as my primary. /* [...]
March 23, 2009
DBMS_LOGSTDBY is the heart and soul of the logical standby management infrastructure . While trying to figure out how to get my alter database datafile operations . i bumped in a record unsupported operations in $logstdby_stats . There seems to be no mention in the documentation and no reference to this parameter being set anywhere [...]
January 15, 2009
During a recent implementation of Dataguard on a Active/Passive Cluster. I started receiving weird errors using the installation/configuration phase. The Grid control add standby wizard which is something i like to use for smaller databases started out the the process but would never complete it leaving the primary and the standby in a weird state.Errors [...]