:

RSSScripts

Using Oracle LogMiner

Log miner is an amazingly useful Oracle utility. I love to use it when there is a dispute about what transactions happened and when. Alert Log Transaction Information If you have been looking in your alert log, and perhaps you are even using CDC, and have seen a number which has the format 0040.027.002c8951, then […]

Continue Reading

ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

The Problem You are receiving the error message: ORA-00257: archiver error. Connect internal only, until freed. You log into the database and try to archive the redo log files and get another error: sys@TEST> archive log all; ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST The Solution alter system set log_archive_dest_state_1=’ENABLE’ scope=both; sys@TEST> archive log […]

Continue Reading

The Job Coordinator and Job_queue_processes

If you are running jobs within the database by using the DBMS_JOB package to submit your jobs to the job queue, you will no doubt know that the job_queue_processes parameter is responsible for determining how many jobs can run at the same time. Each job which runs within the database will be viewable from the v$session dynamic view. […]

Continue Reading

ORA-00600 Internal Error Code, arguments [3020], [9]

The Problem We are running Windows Server 2003, Sp2 on both the primary  and standby DB servers, using Oracle 11.2.0.2. We are using a data guard  physical standby DB, also. We have a large tablespace due to a migration that we had completed as a one-off to load the data into the new database. I attempted […]

Continue Reading

ORA-38701: Flashback database log, ORA-27070: async read/write failed

The Problem I had created a guaranteed flashback restore point in my 11g (11.2.0.2 base release) database and I was running in some updates which were very intensive in terms of I/O resource. I should point out that this is on a Windows Server 2003 R2 OS. I noticed that there were disk queues showing […]

Continue Reading

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