Packt+ | Advance your knowledge in tech

You're reading from Oracle Database XE 11gR2 Jump Start Guide Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide with this book and ebook.

Product type Paperback

Published in Jul 2012

Publisher Packt

ISBN-13 9781849686747

Length 146 pages

Edition 1st Edition

Languages

Java

Tools

Oracle Database

Concepts

Database Programming

Author (1):

Asif Momen

View More author details

Table of Contents (20) Chapters

Oracle Database XE 11gR2 Jump Start Guide

Credits

About the Author

Acknowledgement

About the Reviewers

1. www.PacktPub.com

2. Preface

1. Database Editions and Oracle Database XE FREE CHAPTER

2. Installing and Uninstalling Oracle Database XE

3. Connecting and Configuring Oracle Database 11g XE

4. Accessing Table Data, DML Statements, and Transactions

5. Creating and Managing Schema Objects

6. Developing Stored Subprograms and Triggers

7. Building a Sample Application with Oracle Application Express

8. Managing Database and Database Storage

9. Moving Data between Oracle Databases

10. Upgrading Oracle Database 11g XE to Other Database Editions

11. Backup and Recovery

12. Tuning Oracle Database 11g XE

Features Available with Oracle Database 11g XE

The ARCHIVELOG mode

Databases can be run in one of two modes — the ARCHIVELOG mode or the NOARCHIVELOG mode. In NOARCHVIELOG mode, the redo log files are reused by the Oracle database engine without being copied to an offline location. In ARCHIVELOG mode, Oracle copies the filled online redo log files to one or more offline locations before they are reused. These redo log files, which are saved offline, are called archived redo log files. The ARCH process is responsible for archiving when automatic archiving is enabled. You use the archived redo log files to recover a database and update a standby database.

The ARCHIVELOG mode is very important for mission-critical production databases. Databases can be backed up in the open mode when running in the ARCHIVELOG mode. Also, the ARCHIVELOG mode provides point-in-time recovery. It is generally not necessary for test and development databases.