Backup and recovery in Oracle 10g

Learning objective

After completing this topic, you should be able to configure a database for backup and recovery.

Exercise overview

In this exercise, you're required to configure a database for backup and recovery.

This involves the following tasks:

• verifying multiplexed control files
• multiplexing redo log groups
• placing a database in ARCHIVELOG mode

Task 1: Verifying multiplexed control files

Your database is ready to move from testing into production, so you need to configure it to reduce the chances of failure or data loss.

The first thing you need to check is whether you have three control files in place to ensure redundancy.

Starting from the Home page, open the page that allows you to verify that you have three control files in place to ensure redundancy.

Steps list

Instructions
1. Click the Administration tab
2. In the Storage section, select the Controlfiles link

Task 2: Multiplexing redo log groups

You next need to add a second member to one of the redo log groups to enhance recoverability in the event of hardware failure or file corruption.

Starting from the Home page, create a new member of Redo Log Group 1 called redo0102.log and add it to the default file directory.

Steps list

Instructions
1. Click the Administration tab
2. In the Storage section, select the Redo Log Groups link
3. Ensure that Redo Log Group 1 is selected and click Edit
4. Click Add
5. In the File Name field, type redo0102.log
6. Click Continue
7. Click Apply

Task 3: Setting the database to ARCHIVELOG mode

You need to place the database in ARCHIVELOG mode.

Starting from the Administration tabbed page, place your database in ARCHIVELOG mode and configure a redundant archive log destination of

/home/oracle/orcl2/archive/

Steps list

Instructions
1. Click the Maintenance tab
2. Select the Configure Recovery Settings link
3. In the Media Recovery section, select the ARCHIVELOG Mode checkbox
4. Type /home/oracle/orcl2/archive/ in the Archive Log Destination 1 field
5. Click Apply