Q:
Whar are the Difference between online and offline backups?
Answer
- Online backup is one which is taken at the time the database is running in the ARCHIVELOG mode.
- Following files should be backed up during the Offline Backup: All data file, all control file and all online redo log file. But in the case of the online backup following files is backed up: All data files all archived redo log files and one control file via the alter database command.
- Offline database we cannot rely upon but in case of online database no issues.
- Offline backup no archived mode is required but in the online backup it is must.
View answer
Workspace
Report Error
Discuss