:

The Latest Oracle Posts

RMAN – A Cumulative Incremental Backup Problem?

We were using a cumulative incremental backup strategy in Oracle version 9.2.0.8, patchset 21. We thought that each cumulative level 1 backup plus the level 0 which was taken prior to it, would be sufficient to restore the database. However, we found out while restoring the database to a DEV environment that this is not […]

Continue Reading

File Added to Control File as ‘UNNAMED’ Because it was Created Under Name Already Used in this Database

Platform: Windows server 2003, SP2 Oracle: 10.2.0.4, patchset 3 (base release) The Problem You have a primary database and a physical standby database which has the standby_file_management parameter set to AUTO. You have been adding files to your primary database, and are expecting them to be added to the physical standby database automatically. Unfortunately, you notice […]

Continue Reading

ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0

If you experience the following error messsage when starting up your database, try changing the “COMPATIBLE” parameter to a 5 digit one. For example, I was running Oracle 11g and originally the COMPATIBLE parameter was set to 11.2.0. I changed it to 11.2.0.3.0, attempted another STARTUP MOUNT command and it worked without a problem. SQL> […]

Continue Reading

Change the RMAN Date Format

Question: I’m using Oracle’s RMAN and when I run scripts the date format is truncated, but I want to know the exact time my script started and stopped. Answer: Follow one of the below, depending upon which platform you are using. RMAN Date Format on UNIX Use the SETENV command to set the NLS_DATE_FORMAT variable […]

Continue Reading

Useful Commands in RMAN

Note: If you want the date in RMAN to be formatted in a specific way, different to the default, have a read of my other article on how to change the RMAN date format. # Find out the tag for the backup set that you want RMAN> LIST BACKUP SUMMARY COMPLETED BETWEEN ’25-04-2013 21:00:00′ AND ’25-04-2013 22:00:00′; # List the backup […]

Continue Reading

ORA-16037: Message 16037 not found

These errors were appearing very regularly on our physical standby databases. They are shown when you stop the recovery operation on the  standby database and we were doing this at regular intervals per day to open the physical standby database for read only access. These errors are not an issue and no further action is required. MRP0: […]

Continue Reading

SP2-0734: unknown command beginning “purge dba_” – rest of line ignored

The SP2-0734 error certainly made me scratch my head for a while. First off, I thought I had got the command wrong because I don’t execute it that much because we have all of our DEV environments configured with the recyclebin off. So I went to the Oracle documentation and realised that I had entered it correctly. Then […]

Continue Reading

ORA-15590: encountered incomplete workload capture files

The Problem I had captured the workload from our production database, copied the workload  capture files to a development database server, upgraded the development database from 10g to 11g  and then attempted to run in this procedure and received the error below: SQL> BEGIN 2    DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE  (capture_dir => ‘WRC’); 3    END; 4    / BEGIN * ERROR at line […]

Continue Reading

Oracle Schema – What is an Oracle Schema? Is it a User?

Oracle Schema – What is an Oracle Schema? Is it a User?

What is an Oracle Schema? In simple terms a schema in an Oracle database is another name for a user. So a schema and a user are the same thing. SCHEMA = USER The purpose of a schema in Oracle is to house database objects. The objects could be physical segments, like tables and indexes, […]

Continue Reading

Real Application Testing Hangs on Replay

Oracle Version: 11.2.0.3 Platform: Windows Server 2003 SP2 The Problem I was using Real Application Testing, and more specifically the Database Replay tool to get some performance comparison testing done. When running the replay it appeared to hang. I had changed one thing, and that was the following hidden parameter “_disable_flashback_archiver”. This is a hidden […]

Continue Reading