Resynchronize a duplicated remote database using RMAN backups

This post is about re-synchronized a duplicated database: the source database is PROD@vsi08 server and the target database will have the same SID, but located @vsi10 server. All the steps to set up a duplicated database are already explained in this previous post. Let’s duplicate for the first time our target database PROD located on […]

Read More

Categories of Failures in Oracle Database

Today we are going to have look on Categories of Failures in Oracle Database.  This information helps to DBA solve the issue as soon as possible.   Statement Failure Statement failure transpires when there is a logical failure in the handling of a statement in an Oracle program. If a statement failure occurs, then the Oracle software or operating […]

Read More

Restore from a loss of all current control files to a non default location using a backup piece

This post is about the steps which use restore from a loss of all current control files to a non-default location using a backup piece. First of all just create a location outside the flash recovery area where to save the backup piece containing the current control file:    

Now it’s time to create […]

Read More

Perform a time-based incomplete recovery

Every incomplete recovery is followed by a resetlogs command before opening the database: each time you use a resetlogs command, a new incarnation of the database is created. While performing incomplete recovery it should be known the target point at which the recovery process needs to terminate: there are several ways to establish and set […]

Read More

Duplicate a database on the same host

This post explains the steps which are used for RMAN: how to duplicate a database on the same host. We need to duplicate a database. There are many possibilities to complete this task and I choose to use RMAN and its commands: in particular, I decided (to be honest it was just a poor notebook configuration […]

Read More

Recover corrupted data blocks using DBVERIFY

As we know that SYSTEM – stores the data dictionary.  Being an Oracle DBA we all know the importance of SYSTEM tablespace.  In these below lines, we can have actual technical knowledge about system’s information. SYSTEM – a tablespace that is always used to store SYSTEM data that includes data about tables, indexes, sequences, and other objects – this metadata […]

Read More

Recover sparse corrupted data blocks one several datafiles

Being an Oracle DBA we all are known about data block. Here this line explains the technical definition of data block A data block is the smallest unit of storage in an Oracle database. Every database has a default block size (specified when the database is created), although blocks in different tablespaces may have different […]

Read More

Recover a never backed up tablespace after losing its datafile

In this post, we are going to learn steps which are use recover a never backed up tablespace after losing its datafile and even the current controlfile after the autobackup feature completes its job. This crash involves the lost of the “never backed up” tablespace and of the current controlfile. Let’s start with an example. Our […]

Read More

Retrieve the DATABASE IDENTIFIER from datafiles or online logs

This article is about the steps which require recovery when we retrieve the DATABASE IDENTIFIER dumping it from datafiles or online and archived redo logs . DBID stands for database identifier, which is a unique identifier for each Oracle database running. It is found in control files as well as datafile header. If the database is open […]

Read More