Archivelog mode concepts | Oracle Hot backup and cold backup

We take complete physical backup of database by copying physical database files including datafiles, control files, password file and parameter file. Backup can be online backup or offline backup. In online backup, our database is in open stage and datafiles have different SCN. Continue reading “Archivelog mode concepts | Oracle Hot backup and cold backup”

Introduction to Oracle Backup and Recovery | Oracle Flashback Features

Oracle has provided powerful mechanism to protect database in situation of data loss. This mechanism includes a range of methods to Backup and Recover your data. First step is to backup you data and second step is to recover required data. Broadly speaking, oracle supports two types of backups, Logical Backup and Physical database backups.

Continue reading “Introduction to Oracle Backup and Recovery | Oracle Flashback Features”