Just finished installing Oracle 12c on Cent OS 6.3. From the looks of it 12c looks like a winner. Oracle…
Category Script
GoldenGate is touted by Oracle as its future for data replication. It will slowly phase out Oracle Streams and will…
Guaranteed Restore Points are a life-saver when it comes to Application changes.It can ensure that you can rewind the database…
I had a block corruption of my primary database, though we had a standby build we wanted to recover the…
Flashback Technology provided by Oracle is one of the most useful in a production environment. It is a life saver.…
Sometimes on a system it is important to know the maximum user processes does not increase so much that it…
################ Configure Solaris 10 machine to be on DNS############## 1. Check for file resolv.conf in /etc directory, if it doenst…
Below is the Solaris user profiles for “grid” and “oracle” user. If you have followed Oracles official documentation for installation…
In this scenario,the standby database lost contact(connection) with primary database for few days and hundreds of redo log was switched…
RMAN Point-In-Time Recovery Example There are many ways to restore a database using an RMAN backup – this example assumes…
ORA-01578: ORACLE data block corrupted (file # 19, block # 461509) ORA-01110: data file 19: ‘E:\ORACLE\ORADATA\PLACID\CARA_NS.ORA’ You are getting the…
Restoring a controlfile without rman _____________________________________ suppose you lost a controlfile say control01.ctl. The controlfile got deleted but you have…
I had installed Oracle Database 11g on Solaris 10 few days back. I thought of documenting the steps for easy…
Automatic Storage Management (ASM) in Oracle Database 10g Automatic Storage Management (ASM) is a new feature was introduced in Oracle…
The following is a basic steps for an automatic start up and shutdown Oracle instances during UNIX system startup or…
Many times it becomes necessary to append date stamp on your export dumps. In Unix systems, shell scripting is very…
Dedicated to Gwen Shapira It’s a tale of woe and malice, a tale of a DBA That the users learned…
The following INIT.ORA/SPFILE parameter can be used if your current redologs are corrupted or blown away. It may also be…
Directions :: First do gunzip then cpio of the file you downloaded from oracle.com 1. Run “gunzip <filename>” on all…
UNIX Commands for DBAs Basic File Navigation The “pwd” command displays the current directory: root> pwd /u01/app/oracle/product/9.2.0.1.0 The “ls” command…
By Uwe Hesse Link to original post: http://uhesse.wordpress.com/oracle-database-ha-architecture/ A very popular topic in many of my courses is Oracle Database…
The database does not startup, and gives errors like: ORA-38737: Expected sequence number 2483 doesn’t match 2304 ORA-38701: Flashback database…
Sometimes when your running an Oracle database, it becomes necessary to automate some tasks like cleaning your archivelogs. Since in…
How to backup the Oracle Control File? There are two approaches: you either generate a binary image of the Control…