Correct 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
Discussion & Comments