Oracle Backup & Recovery Hands-on Practice – Oracle Database 18c VM

Posted on by Ahmed Abdel Fattah

Do you want to practice recovering from the following common failures (with a guided step-by-step procedure)?: Recovering from a critical file loss (SYSTEM , UNDO)Recovering from a non-critical file lossRecovering from the loss of the control fileRecovering from the loss of all control filesRecovering from the loss of an inactive redo log fileRecovering from the … Continue reading Oracle Backup & Recovery Hands-on Practice – Oracle Database 18c VM

Advertisement

How to Enable Archivelog Mode for an Oracle database

Posted on by Ahmed Abdel Fattah

This is a quick post about the steps required to enable the ARCHIVELOG mode for an oracle database (Single Instance or RAC) To check if the archive log mode is enabled or not, use the following command: SYS@XPS 01-SEP-18 SQL> archive log list Database log mode               No Archive Mode … Continue reading How to Enable Archivelog Mode for an Oracle database

How do Nologging Operations affect Recovery and Data Guard?

Posted on by Ahmed Abdel Fattah

What is Redo Information: Each Oracle Database instance has redo logs, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure. What is Nologging: NOLOGGING can be used to prevent bulk operations from … Continue reading How do Nologging Operations affect Recovery and Data Guard?