Google Ads

Introduction

In this article we enable the archivelog and flashback in Oracle database 10g. The benefits of archivelog and flashback are:
1. We can able to take database backup online.
2. No Need to Down Oracle DB Server
3. We can better Manage our Backup Policy through RMAN
4. Limited DBA task
5. We can able to recover our database to a specific point-in-time

Enable Archivelog mode and Flasback

In order to configure recovery settings option in oracle 10g, We login to oracle enterprise manager as sys account (Picture 1).

Picture 1: Login as Sys

 

In the maintenance tab click recovery settings under backup settings (Picture 2).

Picture 2: Click on recovery settings

 

Then We scroll down to the flash recovery area and check enable flash database (Picture 3) which can be used for fast database point in time recovery. We can also change flashback retention time to 48 hours and flash recovery area size to 3GB

 

 

Picture 3: Enable flashback database

 

Next, We scroll up to the screen and check archivelog mode (Picture 4). We Scroll up again on the top of screen and then we click apply and reboot the database in order to make the changes effective.

Picture 4: Enable archivelog