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

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 […]

Read More