Walkthrough ORACLE 11g: Configuring for Recoverability

In the previous article “Shortcuts to losing your data” explained why organizations expect zero data loss and importance of backup solutions. Not only for data protection, Backups also used for data preservation and historical retention as well.  However the main purpose of backup and recovery is to restore a failed database.

There are two types of Archive log modes ;

•  * NOARCHIVELOG mode
•  * ARCHIEVELOG mode 

NOARCHIVELOG is default mode and database runs normally, in this event you have to shut down the database in order to take the backup also which backups and recover to the point of the last backup only. Therefore before take the backup configure your database in ARCHIVELOG mode, because it allows backup the database while it is open. Also if backups are taken in ARCHIVELOG mode can be used to recover a database to past point in time.

Walkthrough Practice – Configuring ARCHIVELOG mode

 

1. Setup the Environment

SET ORACLE_SID=orcl

2. How to determine the archive mode

SQL> archive log list 

According to the above illustration database running in “NOARCHIVELOG” mode

3.  Shutdown the Database

SQL> shutdown immediate

Note: You can configure the ARCHIVELOG mode only when the database is mounted. 

Therefore shutdown and mount the database.

4. Mount the Database

 SQL> startup mount

5. Alter the database to use ARCHIVELOG mode

SQL> alter database archivelog;

6. Open the database

SQL> alter database open; 

Now the Database in ARCHIVELOG mode.

Enjoy learning ! 
RinZi ..