Oracle 21c introduces the ability to improve the performance of queries executed on the read-only active Standby Database by enabling the use of the Result Cache feature to store query results for recurring use- so not just enabled on the Primary database, but the Standby database as well. The new Oracle 21c clause RESULT_CACHE (STANDBY […]
Active Data Guard databases are now no longer just ‘read-only’ databases – they have now become ‘read-mostly’ databases which is primarily used for reporting purposes but also allows to some extent DML activity as well. One of the new features in Oracle 18c is Private Temporary Tables. Private temporary tables differ from Global Temporary tables […]
This note describes the procedure used to setup and configure a Data Guard Cascaded Standby database environment. The cascading standby database receives redo from the Primary database and then this redo is cascaded to one or more cascaded standby databases. So the cascaded standby database does not receive its redo directly from the Primary database […]
Active Data Guard is a good new feature in 11g (although requires a license) which enables us to query the Standby database while redo logs are being applied to it. In earlier releases, we had to stop the log apply, open the database in read only mode and then start the log apply again when […]
Quick steps to set up a 11g Standby database with Active Data Guard using the Active Duplication feature available in 11g where we can create a standby database without having to take a backup on the primary database. Datafiles are copied over the network. Primary machine – OATU036 Standby machine – DROU036 Database Name – […]
One of the very good new features in Oracle 11g is the Snapshot Standby database where we can basically convert the physical standby database into a read-write real time clone of the production database and we can then temporarily use this environment for carrying out any kind of development testing, QA type work or to […]
