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 […]
All posts by Anuradha Mudgal
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 […]
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 […]
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 […]
Recover loss of a non-system tablespace with the RMAN Data Recovery Advisor
These steps are for recovery in which we will know about how to recover from a loss of a non-system tablespace on the same location while the database is closed. Normally our database is always in open mode. In some cases we can face error ORA-01157: cannot identify/lock data file %s – see DBWR trace file” […]
Recover from a loss of a non-system tablespace on the same location while the database is open
We are going to have a look on the steps which are followed by DBA to recover a loss of a non-system tablespace on the same location while the database is open. When we lose a non-system tablespace you cannot access and query only objects that were created on their datafiles Meanwhile users can continue to […]
Recover from a loss of a temporary tablespace
This article is about a recovery of temporary tablespace. As we know that Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory (see SORT_AREA_SIZE initialization parameter), space will be allocated in […]
Recover from a loss of a read-only tablespace
Being an Oracle DBA we are aware that there are many types of backups are available for Oracle database maintenance in the same way we have multiple ways to restore our database. One question raises here that why do we need have a different kind of ways to backup and recovery in Oracle database? Answer of this question […]
Restore lost non-system datafiles on a different location while the database is closed
With the help of this article today we are going to learn about those steps which are going to use during the restore lost non-system datafiles on different location the database is closed. In our previous post, we have discussed the restore lost non–system datafiles on a different location while the database while the database is open. We […]
Restore a lost non-system datafile on a different location while the database is open
We are going to have a look on those steps which are required to restore a lost nonsystem datafile on a different location during the Oracle a database is in open stage. We are going to lose datafiles of a non-system critical tablespace and restore them, while the database is open, to a location other […]