Checking your Data Guard gap using queries against v$archived_log or v$log_history? If so, there’s a good chance they’ll report that everything’s fine, even when there’s a gap!
Formed in 2009, the Archive Team (not to be confused with the archive.org Archive-It Team) is a rogue archivist collective dedicated to saving copies of rapidly dying or deleted websites for the sake of history and digital heritage. The group is 100% composed of volunteers and interested parties, and has expanded into a large amount of related projects for saving online and digital history.
History is littered with hundreds of conflicts over the future of a community, group, location or business that were "resolved" when one of the parties stepped ahead and destroyed what was there. With the original point of contention destroyed, the debates would fall to the wayside. Archive Team believes that by duplicated condemned data, the conversation and debate can continue, as well as the richness and insight gained by keeping the materials. Our projects have ranged in size from a single volunteer downloading the data to a small-but-critical site, to over 100 volunteers stepping forward to acquire terabytes of user-created data to save for future generations.
The main site for Archive Team is at archiveteam.org and contains up to the date information on various projects, manifestos, plans and walkthroughs.
This collection contains the output of many Archive Team projects, both ongoing and completed. Thanks to the generous providing of disk space by the Internet Archive, multi-terabyte datasets can be made available, as well as in use by the Wayback Machine, providing a path back to lost websites and work.
Our collection has grown to the point of having sub-collections for the type of data we acquire. If you are seeking to browse the contents of these collections, the Wayback Machine is the best first stop. Otherwise, you are free to dig into the stacks to see what you may find.
The Archive Team Panic Downloads are full pulldowns of currently extant websites, meant to serve as emergency backups for needed sites that are in danger of closing, or which will be missed dearly if suddenly lost due to hard drive crashes or server failures.
Checking your Data Guard gap using queries against v$archived_log or v$log_history? If so, there’s a good chance they’ll report that everything’s fine, even when there’s a gap!
Simple steps for overcoming the “unable to retrieve auth token: invalid username/password: authentication required” message encountered when trying to pull images from container-registry.oracle.com.
Creating a Gold Image of an Oracle Home with runInstaller -createGoldImage can leak sensitive information about the source environment! Learn how to identify and eliminate the risks!
Oracle Database 23c is currently only available on OCI Base Database Service, but that doesn’t mean you need to wait to run in locally!
A critical regression in AHF 23.4.0 may delete the ORACLE_HOME(s) on remote nodes of a RAC cluster. Learn what systems are affected and what you can do to avoid this issue!
Do you run Docker on Linux? Do you use a custom directory instead of /var/lib/docker? Did Docker recently stop working? If so, you may have configured your docker.service configuration file with an obsolete parameter. Fortunately, it’s an easy fix! Read on for more!
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! Download your free sample chapter on Persistence for Oracle Databases in containers now!
Learn how to use native Linux services to manage Observers in Data Guard Fast-Start Failover configurations, and build more durable, reliable, and simple solutions than scripting alone!
Finding missing archive logs when gaps are many and random is a tedious exercise. Learn how to use awk to find and generate restore scripts for the missing files! My contribution for #JoelKallmanDay!
Several blog posts describe how to authenticate with My Oracle Support and download patches. Unfortunately, some rely on manual authentication with MOS on one host to generate the cookie file, then copy the cookie to the automation machine. I needed a fully-automated solution that used curl.
This is the second in a multi-part series on building Docker images for Oracle 19c. In the first installment I demonstrated a Dockerfile for building images using the Oracle 19c RPM and applying Release Updates (RU) to the new home. In this post I describe the remaining steps necessary for running Docker images using the RPM-based installation.
The first in a multi-part series on building Docker images for Oracle 19c using the 19c RPM. Part 1 shows the Dockerfile used to create an Oracle 19c database via RPM install, update OPatch and apply the 19.8 Release Update (RU) to the Oracle Home. Part 2 covers the remaining components of the Docker build. Part 3 describes how to take multiple images and merge them to create containers with an older 11g or 12c Oracle home and database running alongside a 19c home, ready for testing and practicing your Oracle 19c upgrades!
Are you prepared to convert an unplanned outage into an opportunity to improve your database?
To promote my new YouTube Oracle technology channel I’m giving a $25 Amazon gift card to the first person to solve an Oracle puzzle. Subscribe to my channel and comment on the video with your answer. The first person to post the correct answer wins $25!
Adding certificates to a wallet for SSL/TLS access can be tedious and time consuming, particularly when multiple sites are involved. The answer? Automate it!
Oracle enforces complexity rules for passwords when creating databases. How do you generate random passwords while guaranteeing the rules are met, particularly when automating database creation?
AKA “The Definitive (and perhaps only) Guide to Loading Fixed-Width Data Into an Autonomous Database using DBMS_CLOUD”
How do you report on all your SIDs, or automate processes to run against everything that’s installed (or just running) on a database server? bash scripting, of course! Here are some scripts I use to generate a variety of output for LInux and Solaris systems.
Get our FREE eBook "10 Programming Tips That Changed Everything" when you subscribe!
No spam. Unsubscribe anytime.