Oracle database backup and recovery - Difference between online and offline
backups. posted by Babu
Kunwar
Difference between online and offline backups.
-
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.
More links
What is ODBC? Explain its purposes
Difference between ODBC and Net8.
What do I need to get ODBC to work?
Explain how to create a Data Source.
Explain how to trace ODBC calls.
What is ODBC SQLPASSTHROUGH option?
How to attach an Oracle table in MS-Access?
Explain how to get Oracle data into MS-Excel............
|
