by Willie Gray | Jul 10, 2020 | Backup and Recovery, Best Practices, Database, Oracle DBA
When it comes to Oracle database administration, one of the most revered parts of your database structure is the fast recovery area (FRA). This is an Oracle managed area where DBAs usually store some of the following files: Redo logs Archive logs Flashback logs...
by Robert Buda | May 12, 2020 | Database Architecture, Oracle, SQL Server
What is a schema as opposed to a database as opposed to an instance? And how do schemas differ between Oracle and MSSQL? Or between Oracle and PostgreSQL? Or between PostgreSQL and MongoDB? These terms can be confusing, but they are very important when planning a...
by Robert Buda | May 11, 2020 | Database, licensing, Oracle
Do I really need Oracle Enterprise Edition? Do I need Oracle Enterprise Edition in order to have a standby database? What version of Oracle do I need? We get questions like these a lot. Oracle’s editions and features can be a bit overwhelming. This post shares some...
by Scott Loudon | Apr 22, 2020 | Backup and Recovery, Database, Oracle, Oracle DBA
One of our customers had issues over the past several months with Oracle Active Data Guard replication to a standby server. The database on the standby server would intermittently fall out of sync with the database on the primary server, and log files were not...
by Robert Buda | Jul 8, 2016 | Backup and Recovery, Best Practices, Oracle, SQL Server
Another new client, Another bad backup I originally wrote this post in July but I am updating it today because it is so important. Yesterday we did an initial Oracle Database Health Check for another new client and found yet again that their backups are useless. This...