:

The Latest Oracle Posts

Data Guard Becomes out of Sync

If your Data Guard database gets out of sync and the archive log files are available, you can restore the log files at your primary DB (usually PRODUCTION), put the Data Guard database into recovery mode and then the logs will get shipped to your standby database automatically. If you still have the archive logs but they are […]

Continue Reading

ORA-31154 Invalid XML Document

The Problem During an 11g DB upgrade I got this error: ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-31154: invalid XML document ORA-19202: Error occurred in XML processing LSX-00020: unknown type “string” ORA-06512: at “XDB.DBMS_XDB”, line 528 ORA-06512: at line 55 The Cause Not quite sure… The Solution Use Metalink […]

Continue Reading

Use RMAN to Recover a Physical Standby Database

Read section 12.7.1 in the the Oracle documenttion first. I used this for a slightly different reason than is documented in that link, but it gives good details about what you need to do. I had attempted to flashback the database but after flashing back the DBs (one OLTP and one DataWarehouse) from being in a read/write state on our physical standby DBs, they […]

Continue Reading

ORA-15557 workload replay client cannot access replay directory

The Problem I have been starting to use the Oracle 11g feature called Real Application Testing (RAT) recently. More specifically, the Database Replay feature of RAT. This appears to be a great tool for testing real PROD load on a DEV system, tweeking some parameters or statistics and then running the load again. I was […]

Continue Reading

ORA-00600 Internal Error Code Arguments: kcratr_scan_lastbwr

The Problem I had refreshed one of our dev databases but the database we were refreshing it from was still open at the time when the disks were flushed at the SAN level and there must have been transactions still in process. One of the steps is to enable archivelog mode and it failed with […]

Continue Reading

ORA-32004 Obsolete and/or Deprecated Parameter(s) Specified

After modifying one or more database parameters you stop and start the database and get the error message: ORA-32004: Obsolete and/or Deprecated Parameter(s) Specified This could be when changing from a lower version database to a higher one, and some of the parameters that you had set are now deprecated. You can query the V$OBSOLETE_PARAMETER view […]

Continue Reading

ORA-01153 an Incompatible Media Recovery is Active

The Problem When running the command ALTER DATABASE OPEN RESETLOGS from an RMAN prompt, I got the error:                  ORA-01153: an incompatible media recovery is active I then tried from SQL Plus but got the same message. The Solution The solution was to close the RMAN session that I had open and then run the […]

Continue Reading

ORA-16146 Standby Destination Control File Enqueue Unavailable

When configuring your database using data guard, it is recommended in the Oracle documentation that you set the log_archive_dest_2 parameter on the physical standby database to a value that it will take if it were to be running in the primary role mode. This is so that at failover/switchover time, you have fewer things to worry […]

Continue Reading

ORA-39165: Schema SYS was not found

Oracle Version: 10.2.0.4 Platform: Windows Server 2003 R2 The Problem I was attempting to export a table from an Oracle version 10.2 DB running on Windows. I was using the data pump export utility instead of the older export utility. The table which I wanted to export resided in the SYS schema. When running the […]

Continue Reading