Google Ads

Thursday, 06 December 2012 00:00

Configure Oracle 10g Recovery settings

Rate this item
(0 votes)

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

Read 25665 times Last modified on Monday, 28 December 2015 12:05
Published in Blog
More in this category: « Deploy a second domain controller Windows 2012 Cisco 2960 catalyst basic configuration commands »
back to top
  • You are here:  
  • Home
  • Blog
  • Configure Oracle 10g Recovery settings