Recover from a loss of all redo log members of the CURRENT group

The most crucial and vital structure for recovery operations is the online redo log, which consists of two or more pre-allocated files that store all changes made to the database as they occur. Every instance of an Oracle database has an associated online redo log to protect the database in case of an instance failure. […]

Read More

Recover from a loss of all redo log members of an ACTIVE group

In the last post, we have learned about multiple kinds of a recovery scenario. Now in this article, we are going to learn about the steps which are used How to recover from a loss of all redo log members of an ACTIVE group.  As we all know what is active group ACTIVE status means that there are […]

Read More

Recover from a loss of all redo log members of an INACTIVE group

We all know that redo log has three kinds of a group like active, inactive, current. They all have different use and as well as different meaning.Let’s simulate a loss of all redo log members of an inactive group. If you have completely lost one redo log group your database won’t be able to open. […]

Read More

Recover from a loss of the SYSTEM tablespace on different location

This post is about the steps used for recover as from a loss of the SYSTEM tablespace on a different location. As DBA we all are aware of system tablespace that it always contains the data dictionary tables for the entire database. In particular, this example will restore the lost tablespace to another location, just […]

Read More

RMAN Configure Backup Optimization Features with Example

RMAN backup optimization is another feature to minimize backup size. Enabling this feature, RMAN BACKUP will skip backup of files that comes in certain condition or exactly identical to the file already backup up. As the name indicates the feature is for optimizing the RMAN backups. When you turn on this backup optimization parameter, RMAN […]

Read More

Recover from a loss of the SYSTEM tablespace on the original location

Recovery is an important process for any kind of organization.   if the database can not recover properly   That is the worst condition of any DBA‘s professional because it causes unlivable loss of an organization.  We have many kinds of solutions to restore the database according to the loss of database. We are going to have […]

Read More