Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Damage Online Logfile Member
Published by :
Obay Salah , November 19, 2024
We mentioned earlier that the database works on at least two Redo Logfile Groups and each Group contains at least one Member. Let's assume that... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Damage Temporary Tablespace
Published by :
Obay Salah , November 19, 2024
What is the best solution for a database administrator who has a Temporary Tablespace failure? By the way, there may be more than one Temporary... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Damage Oracle Tempfile
Published by :
Obay Salah , November 19, 2024
Let's assume that your database is working on a Temporary Tablespace called Temp and contains one Tempfile called Temp02.dbf and let's assume th... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Loss of Control Files
Published by :
Obay Salah , November 19, 2024
In this scenario, imagine that you have lost all the Control Files. Of course, the database does not work without the Control File. If you had lost on... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Loss of an Un-archived Online Log Files
Published by :
Obay Salah , November 19, 2024
Imagine with me that you are working on the database and suddenly a disk failure occurs, which causes the loss of all the online log files,knowing tha... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Loss of a SYSTEM Data File
Published by :
Obay Salah , November 19, 2024
Imagine with me in this scenario that you lost the SYSTEM01.DBF DATAFILE which belongs to the SYSTEM TABLESPACE, what do you expect to happen of... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Loss of a Non-SYSTEM Data File
Published by :
Obay Salah , November 19, 2024
It is a Datafile that does not belong to System Tablespace or Undo Tablespace, the moment Non-SYSTEM Datafile is lost, users receive error messages st... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Full Database Recovery
Published by :
Obay Salah , November 19, 2024
In this scenario we assume that we have lost all the database files (Data Files & Redolog Files & Control Files), the database is runnin... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Cold Backup
Published by :
Obay Salah , November 19, 2024
The figure above explain the cold backup and recovery process.1- Shutdown: As we mentioned earlier, the cold backup process is done after t... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Enabling Archivelog Mode
Published by :
Obay Salah , November 19, 2024
1- Make sure that the database is running in NOARCHIVELOG mode by running a query on the database.ARCHIVE LOG LIST SELECT LOG_MODE FROM V$DATABA... Continue Reading