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 […]
All posts by Anuradha Mudgal
Anuradha Mudgal
Recover a never backed up tablespace after losing its datafile
This post is about the steps which are used to recover a never backed up tablespace after losing its datafile and even the current controlfile but before the autobackup feature completes its job. All the required information is still available and written in your archived or online redo log. So the solution of the first question […]
Restore the spfile while using the flash recovery area and not the recovery catalog
We all are aware of spfile and pfile in Oracle. Oracle requires an initialization file to define the attributes and characteristics of the starting instance and the connecting sessions there of. We are aware of the Initialization parameter file (also referred as init.ora file or PFILE). This file holds the setup parameters that define the attribute […]
Restore from a loss of all current control files to a non default location
This post about to restore from a loss of all current control files to a non-default location using autobackup. One of the many features included in RMAN is the ability to automatically backup your control file. It is very important for (some) recovery purposes to ensure you have a recent copy of your control file, especially if […]
Restore from a loss of all current control files to the default location
Recovery of the most crucial element in Oracle database plays an important role. with the help of show parameter control_files we can find the default location of controlfile in our database. Being an Oracle DBA we must know that why do need oracle controlfile in any oracle. There are some main points which remind us to […]
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 […]
Restore from a loss of a subset of the current control files
Oracle database without control file is just like a human body without a backbone. Control file plays the role of the backbone of the database . Being an oracle dba we must know about controlfile . The control file is a file that the Oracle DBMS maintains to manage the state of the database, and it is […]
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. […]
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 […]
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. […]