Backup and recovery in Oracle 10g
After completing this topic, you should be able to configure a database for backup and recovery.
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.
|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.
| 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 |
|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
|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 |
|5. Click Apply|