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 […]
Articles Tagged: backup optimization
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: [oracle@localhost oracle]$ pwd /home/oracle/app/oracle/ [oracle@localhost oracle]$ […]
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 […]
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 […]
Recovery when the first block of a datafile containing the datafile header becomes corrupt
Here some lines explain about the header of a block. Normally we know have seen block corrupt but what if when the first block of a datafile containing the datafile header becomes corrupt. The header of a block contains information like the type of segment the block belongs to and the SCN of the last […]
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. […]
Recover from a loss of one current redo log member of a multiplexed group
Today we are going to learn about the recovery from a loss of one redo log member of a multiplexed group. Being the Oracle DBA we all know the importance of change in normal life as well as database life. A single change in the database makes a huge difference. We all are well known […]
Recover from a loss of the system critical UNDO tablespace on the original location
In this phase of recovery, we are going to have a look on recover from a loss of the system critical UNDO tablespace on the original location. I hope this phase will be useful for you. As we all know that UNDO tablespace stores undo segments, generally used to explicitly (ROLLBACK command) or implicitly (a failed […]