Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Recovery Manager (RMAN) - Components
Published by :
Obay Salah , November 19, 2024
The figure illustrates the components of RMAN:RMAN Executable: This is an executable file similar to the EXP.exe export file and also the I... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
RMAN - Introduction
Published by :
Obay Salah , November 19, 2024
(Recovery Manager (RMAN) is a tool created by Oracle starting with version 8 to be a qualitative leap in the field of backup and recovery (Backu... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Hot Backup in Oracle Database
Published by :
Obay Salah , November 19, 2024
What if your database cannot be closed even for a moment due to the nature of its work, such as the databases of telecommunications companies, as well... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Point in Time Recovery in Oracle Database
Published by :
Obay Salah , November 19, 2024
Let's assume that you have a database that you do a cold backup of daily at 5 pm, and on Tuesday at 2 am one of the users deleted the Employee t... Continue Reading
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