Restoring with RMAN and using the Data Recovery Advisor

In July this year I created a blog post focusing on Three steps to getting started with RMAN and if you have not read it yet I do recommend you take a quick look, as getting the basics … [Read more...]

Three Steps to Getting Started with RMAN

One area that is critical to any database environment is backup and recovery, but too many times I have seen DBA's neglecting backups.  A perfect example of this is when backups are … [Read more...]

Lost an Archive Log File? Use RMAN Incremental Backups to Resync Your Standby Database

Anyone who has done time on the "tech frontline" knows that there are occasions in production systems when the unexpected transpires. Whether such events are of human origin, for … [Read more...]

Creatively Using Log File Sync Time (Guest Post by Craig Shallahamer)

A while back I was developing predictive performance models with a customer (super senior Oracle DBA) when his phone rang. The caller said the application was taking too long to save an … [Read more...]

Pearls of Wisdom and the Wisdom of Perl

DBA? Why you should skip Codecademy and give Perl a try There has been a lot of publicity recently about the increased interest in learning to ‘code’, partly brought about by the … [Read more...]

Dbvisit Standby: Connect failover to standby database

After a switch-over or fail-over to an Oracle Standby database using Dbvisit Standby, the Oracle Database Administrator (DBA) faces the challenge of switching clients to the new activated … [Read more...]

Upgrading an Oracle database with DBUA

Oracle provides the Database Upgrade Assistant (DBUA) to automate the upgrade process and makes appropriate recommendations for configuration options such as tablespaces and redo logs. … [Read more...]

What You Need to Know About Back Ups as a Complement to Dbvisit Standby

We definitely promote using RMAN for backups of your Oracle database. With RMAN you are able to recover up to the last moment before failure (if you have archive log mode enabled). This … [Read more...]

ORA-01195 and ORA-01194 – in Standby Database

One of our customers attempted to activate the standby database in a test scenario and received the following message: SQL> alter database activate standby database ERROR at line … [Read more...]

FQFN – Fully Qualified Filenames in ASM

Considerations for Standby Databases using Automatic Storage Management (ASM) Every file created in ASM gets a system-generated filename, otherwise known as a fully qualified filename … [Read more...]