How not to find Data Guard gaps
Oracle Sean
by Sean Scott
3M ago
I've recently had several encounters with a query for checking for archive log gaps. It appears on multiple blogs, and I suspect it may originate from MOS note 1542907.1, "Standby MRP is looking for very old archive log sequence even after restore new incremental backup at standby site." The query in question: SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME ..read more
Visit website
How to pull images from Oracle's Container Registry
Oracle Sean
by Sean Scott
7M ago
Once Upon a Time, Oracle shared container images in the kingdom of Docker Hub. They were freely available and easy to pull from a magical well that held a bounty of images that came together from every corner of the land. These were the Good Old Days, when containers were still new (but not yet very popular in the database community). One day, a lawyer visited the kingdom of Docker Hub and saw that the people were getting Oracle images without first accepting the License Agreement. This made the Lawyer unhappy, and over time, the Lawyer caused the spring that fed Oracle images into the well to ..read more
Visit website
Use Caution When Creating Gold Images!
Oracle Sean
by Sean Scott
11M ago
In older Oracle database releases, you would use the clone.pl script to create a copy of your Oracle Home. This process is much faster (and easier) than installing the database software and patches on a new host and guarantees that the new installation is identical to the old one. This functionality was deprecated with the release of Oracle Database version 18c. It still works, but Oracle recommends using runInstaller’s -createGoldImage option instead. With good reason—it’s a multi-step process that includes manually removing configuration files present in the original home. Creating a Gold Im ..read more
Visit website
Run Oracle 23c On-Premises NOW
Oracle Sean
by Sean Scott
1y ago
Earlier this year, Oracle announced the release of Oracle Database 23c Free. This free edition of the database software replaces the old Express Edition and allows developers to start exploring the many innovations and improvements introduced in 23c. Last month, Oracle announced the general availability of Oracle 23c production within Oracle Cloud Infrastructure's Base Database Service. We can expect a downloadable version to appear for Linux x86 soon, with other platforms to follow. But... what if you don't want to wait? What if you want to start experimenting with a production version of the ..read more
Visit website
Critical Issue in AHF 23.4.0 May Delete Remote ORACLE_HOMEs
Oracle Sean
by Sean Scott
1y ago
Did that headline get your attention? Good! I’m a huge fan of Oracle’s Autonomous Health Framework (AHF). It’s a wonderful tool with utilities and features that can make a DBA’s life easier. It’s simple to use and—best of all—free, a “Swiss Army Knife” for the DBA. If you aren’t taking advantage of AHF, I highly recommend starting, particularly since Oracle requires customers to provide an AHF diagnostic collection for certain Service Requests. I realize this seems like an extra step. Still, over the years I’ve used AHF and its predecessor, Trace File Analyzer (TFA), submitting a diagnostic co ..read more
Visit website
Docker Service Startup Failure When Using A Custom Docker Directory on Linux
Oracle Sean
by Sean Scott
1y ago
On Linux, you can change where Docker persists its resources from /var/lib/docker to a different directory. This directory contains all of your images, container layers, and volumes, and if your boot volume is small, Docker can quickly dominate the disk. Most references I’ve seen tell you to update the location by editing the /lib/systemd/system/docker.service configuration file and change the following line: ExecStart=/usr/bin/dockerd -H fd:// --containerd=/run/containerd/containerd.sock …by adding an entry with the -g or --graph flag: ExecStart=/usr/bin/dockerd -g /docker -H fd:// --conta ..read more
Visit website
"Oracle on Docker" is now available!
Oracle Sean
by Sean Scott
1y ago
The day is here at last! My book, “Oracle on Docker: Running Oracle Databases in Linux Containers,” is available for purchase through Apress, Amazon, and Barnes & Noble! Click on the image below to download your free sample chapter, Persistence. Click on the image above to download your free sample chapter on Persistence for Oracle Databases in containers ..read more
Visit website
Create a Fast-Start Failover Observer Service on Linux
Oracle Sean
by Sean Scott
1y ago
Oracle Data Guard protects critical database environments with exact, physical standbys, or copies, of production databases. Business continuity and disaster recovery are a matter of switching or failing over to the standby database when the primary system goes offline. Fast-Start Failover (FSFO) automates these activities. FSFO monitors participants in Data Guard configurations and, when it detects that the primary is unavailable, performs the switch automatically. It’s more responsive and durable than manual intervention. The time it takes for a DBA to acknowledge a page, log in to the envir ..read more
Visit website
Find the Gap
Oracle Sean
by Sean Scott
2y ago
A client’s Data Guard environment fell out of sync when archive logs went missing from the standby. A number of factors played a part: Undersized redo log files. The environment switched as often as five times per minute. Frequent RMAN archive log backups. The backup schedule performed archive log backups every five minutes. Aggressive archive log retention and deletion settings. Several years ago, the DBA team grew hypersensitive to archive logs filling FRA. They responded with an aggressive deletion policy of backed up 1 times to tape but omitted applied on standby. Alert fatigue. Th ..read more
Visit website
Automate My Oracle Support Patch Downloads with curl
Oracle Sean
by Sean Scott
2y ago
I recently built an API to automate Oracle database installation and patching on Linux containers running on local and cloud infrastructure. This would normally involve pulling media from a local repository, with all required install files and patches pre-staged. However, this project wasn't limited to predefined configurations. The API specification allowed users to pass a list of patches at runtime. The solution needed to automatically download anything not already in the local software catalog. To download a patch from MOS, I needed to automate these steps: Log into the site and save a co ..read more
Visit website

Follow Oracle Sean on FeedSpot

Continue with Google
Continue with Apple
OR