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 using a password [...]
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 [...]
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 [...]
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 [...]
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 [...]
