Oracle 9i Database Administration in 10 Minutes

- Asim Abbasi (Author)

CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning

Chapter 9: Oracle Backup & Recovery -Simple Technique

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7

 

Difference between Recovery in ARCHIVELOG mode & NOARCHIVELOG mode

In NOARCHIVELOG mode, the transactions that got processed after the last complete backup, will get lost where as in ARCHIVELOG mode no data will get lost i.e. everything that you entered or changed after the last whole database backup will get recovered by Oracle by applying all the redo log files including the ones got archived by the Archiver process.



Chapter 9: Oracle Backup & Recovery -Simple Technique

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7

CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning

Share with others: