(Zahid Anwar) This blog post is part of the “RMAN Back to Basics” series, which can be found here.
Tag: Oracle
In case you miss DBMS_OPTIM_BUNDLE … again …?!?
(Mike.Dietrich) I’m tempted to copy and paste my blog post about DBMS_OPTIM_BUNDLE from February 2019, and exchange only 12.2.0.1 with 19c.
Disaster Recovery using Merge
(Uwe M. Küchler) Wait, WHAT? Does that headline sound fishy?
DBMS_JOB – watching for failures
(Connor McDonald) I had a friend point this one out to me recently. They use DBMS_JOB to allow some “fire and forget” style functionality for user, and in their case, the jobs are “best efforts” in that if they fail, it is not a big deal.
How to change Remote Trail Location at Source– Golden Gate 12c
(Syed Jaffar Hussain) There is a requirement to modify the remote trail location because of typo in the mount point.
RMAN Full Backup & Demo
(Zahid Anwar) This blog post is part of the “RMAN Back to Basics” series, which can be found here.
Steps to recover the standby database’s datafile using a backup of the primary database’s data file
(Shesadev Biswal) Recently we have faced an issue for one of our data guard environment, we will discuss those steps here which we followed to fix this issue.
Exploring the new SSB Schema with SQL Developer Web
(Jeff Smith) The Autonomous Data Warehouse folks have built a nice sample schema for testing analytic views and doing ‘cool Star Schema stuff.’ It’s called, the Star Schema Benchmark (SSB).
Oracle Database File Placement Best Practice & Create Database Demo
(Zahid Anwar) This blog post is part of the “RMAN Back to Basics” series, which can be found here.
Indexing Null Values – Part 2
(Randolf Geist) In the previous post I’ve demonstrated that Oracle has some problems to make efficient use of B*Tree indexes if an IS NULL condition is followed by IN / OR predicates also covered by the same index – the predicates following are not used to navigate the index structure efficiently bu
