Typically the standby and the primary databases are located on the different hosts to ensure the full DR capabilities. However, there are some situations when you want to have the primary and standby database on the same Host. 151 more words
Tags » 11g
I am preparing Dataguard for switchover with 1 primary and 3 standbys and should be able to tnsping all the services from log_archive_config=DG_CONFIG=(HAWKA,HAWKB,HAWKC)
Not sure how valuable this may be for you as I wanted to perform all the tasks in one command and know where the error is at. 232 more words
If you have not read RMAN: Synchronize standby database using production archivelog, then please do so.
# Primary archivelog is on local vs shared storage. 2,104 more words
I know what you are thinking, “Why is this nut of a DBA writing shell script to synchronize standby with achivelog !”
It just happens the environment is very restrictive and NO changes can be made without any change control. 474 more words
Are you using WHEN OTHERS -> NULL to hide your PLSQL errors?
Don’t be so sure…
WHEN OTHERS exception handlers that do nothing and don’t raise errors using RAISE or RAISE_APPLICATION_ERROR can often hide code failures that result in hard to identify bugs. 176 more words
I was reviewing some features in Oracle and, basically, every single time I review them I find something new. Seems Oracle Databases’ features are near to infinite and we frequently find some that can really add value to our solutions. 181 more words