Author: Michael Dinh

How do you test your Oracle database backup?

From my experience, the one area where a DBA cannot afford to make errors is in database backup. When was the last time database backup was tested? Was it successful? How often is backup tested? Is testing automated? I was…

Read More >

Troubleshooting a GoldenGate error code

After applying Oracle GoldenGate V12.2.0.1.170919 for Oracle Database 12c OPTIMIZER Patch for Bug# 26849949, starting GoldenGate extract failed with OGG-00303: Unable to open credential store. Error code 43,490. Here is what the report looks like. $ head -50 E_LAX6.rpt ***********************************************************************…

Read More >

Troubleshooting a datapatch error in Oracle

As part of patching preparation, the following command was executed and failed: Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/db Following step failed during analysis: /bin/sh -c ‘cd /u01/app/oracle/product/12.1.0/db; ORACLE_HOME=/u01/app/oracle/product/12.1.0/db ORACLE_SID=cdb /u01/app/oracle/product/12.1.0/db/OPatch/datapatch -prereq -verbose’ Let’s run datapatch -prereq -verbose manually. $ORACLE_HOME/OPatch/datapatch…

Read More >

Efficiency by design when creating backup strategies

Most backup implementations to not take log management into consideration. Example: Have you seen thousands of backup logs or backup log dating back to 2017? Is it necessary? Worse, paged in the middle of the night for disk filling up….

Read More >

Troubleshooting RAC GoldenGate relocation

During RAC online patching, GoldenGate resource is required to be relocated to surviving node. When relocation fails, there are a few logs which can be useful for troubleshooting. Oracle Grid Infrastructure Standalone Agents for Oracle Clusterware (XAG) was not installed…

Read More >

How to efficiently back up and restore crontab

When a database environment is being patched, entries from crontab are commented and then removed when patching is completed. The process works well when there are only a few entries from crontab, but it does not scale when crontab has…

Read More >

Create Windows Service for Oracle RAC

It’s my first time on RAC system for Windows and I’m happy to learn something new to share. I created a new service for database (restoredb) only to find out the ORACLE_HOME for the service is “c:\\oracle\\product\\10.2.0\\asm_1” Any ideas as…

Read More >

Exploring options of using RMAN configure to simplify backup

I am a simple person who likes simple things, especially RMAN backup implementation. I have yet to understand why RMAN backup implementation does not use configure command, and if you have a good explanation, please share. Examples for RMAN configure…

Read More >

How To correlate Oracle Database transaction with GoldenGate

So there I was troubleshooting GoldenGate issue and was puzzled as to why GoldenGate transactions were not seen from Oracle database. I had the transaction XID correct; however, I was filtering by ACTIVE transaction from Oracle which was causing the…

Read More >

What Does oracle-rdbms-server-11gR2-preinstall Not Do?

I was working on a project to clone Oracle install to a new Linux server and this should be simple as oracle-rdbms-server-11gR2-preinstall RPM can be used to configure the server, right? So simple that I did not read the documentation….

Read More >
Page 7 of 8« First Page...45678