Category Archives: Oracle

ORA-00257: archiver error. Connect internal only, until freed.

Over the years I have learned that common sense goes a long way as a DBA. The other day I was running an ETL process when this error occurred. The following link outlines step to perform to recover from this … Continue reading

Posted in Oracle | Leave a comment

Avamar 7.3 RMAN configuration (Part 2)

Previously we looked at how to backup oracle using the Avamar plugin. So lets look at how I currently use the RMAN plugin for Avamar to test my database restores. Since we will be using a test server to restore … Continue reading

Posted in Oracle | Leave a comment

Oracle Uptime got to love it!

Then the VM host server went down.

Posted in Oracle | Leave a comment

RMAN backup server switching your ORACLE_UNQNAME

Normally we set the ORACLE_UNQNAME setting in our bash_profile. But in my case I use the backup server to restore both production and stage backupsets for testing.  It is very easy to forget setting this environment variable. Therefore I decided … Continue reading

Posted in Oracle | Leave a comment

Avamar 7.3 RMAN configuration

  The Avamar 7.3 for Oracle User guide is full of details on configuring RMAN and the avamar plugin. In attempting to use RMAN with the plugin I came across a few gotcha’s and this post will hopefully save others … Continue reading

Posted in Oracle | Leave a comment

Avamar Administrator 6.1 RMAN backup agent not showing instance on client

If you are running an Avamar RMAN backup on Linux Oracle Enterprise you may need to run avregister to re-activate the client with the Administrator server. Run from /usr/local/avamar/bin # ./avregister === Client Registration and Activation This script will register and … Continue reading

Posted in Oracle | Leave a comment

Automatic Memory Tuning in Oracle 11g

Automatic Memory Tuning in Oracle 11g is now possible by setting the memory_max_target parameter In 11g, all memory can be tuned automatically by setting one parameter. Prior to Oracle 11g, the DBA set the sga_target and sga_max_size parameters, allowing Oracle … Continue reading

Posted in Oracle | Leave a comment