ORA-00600 [LibraryCacheNotEmptyOnClose]
If you are running Oracle 10gR2 10.2.0.1 to 10.2.0.5 and encounter this error
on shutdown you ran into either unpublished bug 4483084 or bug 7572335. Both
bugs deal with objects left in the library cache at shutdown and do not
indicate a problem in the data or database and can be ignored.
Read more »
SP2-0768: Illegal SPOOL command
Recently I ran into a problem were executing a SQL script where I received an SP2-0768: Illegal SPOOL command.
Read more »
Creating a Physical Standby using RMAN DUPLICATE FROM ACTIVE DATABASE
Prior to Oracle Database 11g duplication was performed from an existing RMAN backup. Oracle Database 11g introduces Active database duplication which copies the live source database over the network without the need of an existing backup. As was the case in the backup based duplication, active duplication can be used to create a standby database.
Read more »
Removing Database Control (dbconsole) from a database
Oracle Database 10g introduced Database Control (dbconsole) to aid in day to day administration tasks and monitoring. When building a database for use as a repository for Oracle Enterprise Manager Grid Control or the recently released Oracle Enterprise Manager Cloud Control 12c, you will need to remove Database Control and its associated repository from the database.
Read more »
Quick Manual Database Creation
Using Oracle Managed Files you can quickly create a database manually with very little upfront effort. Oracle Managed Files greatly simplifies the database creation process because all that is needed is the location in which to write the database files.
Read more »
ORA-00354 corrupt redo log block header
I ran in to an issue recently where a database was reporting ORA-00257 archiver error, connect internal only, until freed. However when looking at the system I could not find evidence to support the ORA-00257.
Cloning an Oracle Database Home
Starting with Oracle Database 10g you are able to easily clone an existing Oracle Home. Why would you want to be able to do this? For one it is faster to clone an existing Oracle install than to install fresh. The clone includes all patches that might have been installed thus removing the problem of missing patches when building a new server.
Read more »
Numerous m000 trace files in which KEWROCISTMTEXEC encountered ORA-12899
While clearing up some space in diag/trace directory, I noticed numerous trace files were being generated by the Memory Monitor slave process (m000). These trace files were being generated at regular intervals. Read more »
ORA-04020 When Dropping Materialized View with a Spatial Index
While upgrading our GIS development database from 11gR1 to 11gR2 we found that we were getting deadlocks when dropping materialized views that had spatial indexes. The deadlock always occurred on the first attempt to drop the view and any further attempt to drop the view would report success. However; an attempt to recreate the materialized view would result in an ORA-00955.
Read more »
Flashback Data Archive (Oracle Total Recall)
Have you ever had to to perform a tablespace point in time recovery to retrieve data that was erroneously deleted? How many triggers have you had to create/troubleshoot in order to meet data retention or change control requirements?
Read more »
User Managed Online Backups (Hot Backup)
While Recovery Manager (RMAN) is highly recommended for database backup and recovery operations your organization may require you to perform backups using a custom process or you might have an interest in knowing what is required to perform a user managed backup.
Read more »
Read–Only Tables in Oracle Database 11g
Prior to Oracle Database 11gR1 in order to create a read only table you had to employ clever uses of triggers, constraints or other methods to prevent the data from being changed. In many of those cases only INSERT, UPDATE, and DELETE operations were prevented while many DDL operations were not. Oracle Database 11gR1 provides the ability to create read only tables with a simple ALTER TABLE statement.
Read more »
Remove a Database from a RMAN Recovery Catalog
There will come a time that you will need to remove a database from the recovery catalog. Removing a database from the recovery catalog removes all metadata for the database from the catalog.
Read more »
Automating Database Startup/Shutdown on Oracle Enterprise Linux
Oracle provides the ORACLE_HOME/bin/dbstart and ORACLE_HOME/bin/dbshut scripts that can be used to start the the databases when the Operating System boots and to stop the databases when shutting down the Operating System.
Read more »
Registering a Database with a Recovery Catalog
Registering a database with a recovery catalog records the existence of the database with the recovery catalog. Once the database is registered metadata about the database and its backups will be stored in the recovery catalog.
Read more »
Creating an RMAN Recovery Catalog
The RMAN Recovery Catalog is a database schema that holds the metadata detailing the RMAN backup operations performed on the target database. The metadata include the following information from about the target database: database structure, RMAN configuration, data file and archive log backups (backup sets, pieces and copies), archived redo logs and their copies. In addition to the metadata the recovery catalog can also store scripts that can be used by all registered target databases.
Read more »
Creating a Database using Database Configuration Assistant
Database Configuration Assistant (DBCA) provides a graphical interface for database creation and database configuration. This document will detail the creation of a database using the Database Configuration Assistant. The screen shots in this document were taken from an Oracle 11gR2 install on Oracle Enterprise Linux.
Read more »
Archival Backups RMAN Backups for Long-Term Retention
RMAN has the ability to make an archival backup that is exempt from the configured retention policy. An archival backup is an all inclusive self-contained backup of the database at specific point in time. Archival backups are commonly used to satisfy regulatory requirements such as end year or quarter backups.
Read more »
Dropping a Database via RMAN
In Oracle Database 10gR1 Oracle introduced the RMAN command DROP DATABSE. This one simple statement has the ability to completely remove a database including all RMAN backups with the optional INCLUDING BACKUPS clause.
Read more »
Backup Duplexing with RMAN
RMAN has the ability to write duplexed backup sets creating up to four identical copies of each backup piece in a backup set to different destinations. Duplexing provides an extra layer of protection against disaster, media damage and human error that is easy to configure.
Read more »