Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Check RMAN Backup status
Published by :
Obay Salah , December 4, 2024
Query to check RMAN Backup status:-select SESSION_KEY, INPUT_TYPE, STATUS,to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,to_char(END_TIME,'mm/dd/yy... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Recover a Corrupted Block Using RMAN
Published by :
Obay Salah , November 19, 2024
The process of recovering corrupted blocks is one of the features of RMAN. If a database administrator performs a backup using User-Managed Backu... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
RMAN Archived Redo Log Files Backup
Published by :
Obay Salah , November 19, 2024
RUN{ ALLOCATE CHANNEL D1 DEVICE TYPE DISK; ALLOCATE CHANNEL D2 DEVICE TYPE DISK; ALLOCATE CHANNEL D3 DEVICE TYPE DISK; BACKUP AS copy archiv... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
RMAN Tablespaces Backup
Published by :
Obay Salah , November 19, 2024
RUN{ ALLOCATE CHANNEL D1 DEVICE TYPE DISK MAXPIECESIZE 1G; BACKUP AS COMPRESSED BACKUPSET TABLESPACE USERS; } We created a backup copy for the USER... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
RMAN Data Files Backup
Published by :
Obay Salah , November 19, 2024
You can create a backup of the Data Files using RMAN, provided that the database is in the Mount or Open state.The Recovery Catalog Database mus... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
RMAN Backups
Published by :
Obay Salah , November 19, 2024
RMAN provides the ability to perform backups for all of the following: Database, Tablespaces, Data Files, Control Files, and Archive Log Files.B... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Recovery Catalog
Published by :
Obay Salah , November 19, 2024
Before discussing Backup and Recovery through RMAN, it's essential to talk about the Recovery Catalog because it is preferred for the database adminis... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
RMAN Configuration Setting
Published by :
Obay Salah , November 19, 2024
In fact, configuring RMAN options greatly assists the database administrator in their work, especially if they have a clear strategy in place for thei... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
RMAN Backup Options
Published by :
Obay Salah , November 19, 2024
RMAN provides a set of options for backups:1- Backup Strategy:Whole: This involves taking a backup of all Data Files, including at least one Cont... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
RMAN Connections Types
Published by :
Obay Salah , November 19, 2024
Of course, RMAN can be run without connecting to any of the databases by executing the RMAN.EXE file or by typing the RMAN command... Continue Reading