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 […]
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 […]
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> […]
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 […]
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 […]
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: […]
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 […]
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 […]
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, […]
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 […]
