DataArchiving2

What are best practices while using data warehouse recovery methodology?

In data warehouses backup and recovery can be very crucial task when you have 100’s of terabytes of data. some of the best practices that can be implemented are using ARCHIVELOG mode.

First of all what is the difference between ARCHIVELOG and NOARCHIVELOG mode

In ARCHIVELOG mode oracle archives filled online redo log files before reusing them and in NOARCHIVELOG mode oracle doesn’t archives online redo log files before reusing them.

Running the database in ARCHIVELOG mode has following benefits:

1.The database can be completely recovered from both instance and media failure.

2. Backups  can be performed while database is open.

3. Oracle supports multiplexing of archive log files to avoid single point of failure of archivelogs.

Running the database in NOARCHIVELOG mode has following has following restrictions

1.Database can only be backed up when it  is completely closed after normal shutdown

Some enterprises can afford downtime as it requires shutting down of database(NOARCHIVELOG) mode. If organization cannot afford  downtime then backup strategy implemented is in ARCHIVELOG  mode.

How to enable database in ARCHIVELOG mode?

 

Archivelog

Author Profile

Tejas
Tejas
Passionate traveller,Reviewer of restaurants and bars,tech lover,everything about data processing,analyzing,SQL,PLSQL,pig,hive,zookeeper,mahout,kafka,neo4j
Like
Like Love Haha Wow Sad Angry
2
Summary
What are best practices while using data warehouse recovery methodology?
Article Name
What are best practices while using data warehouse recovery methodology?
Description
Hot and cold backup concepts using -pkworlz
Author

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.