Q

Backing up a 1.4 terabyte database

What is the best method of taking backups? We have a database that is 1.4 terabytes with more than 1000 data files.

We use the GTAR utility but we don't always get successful backups. Is there a better way of taking backups of such a huge database?

For a database this large, I'd use RMAN to back up the database and perform recovery. If you want an overview of RMAN, I have a paper on my web site (http://www.peasland.net) that gives some notes on setting up and using RMAN. I would also recommend reading the Oracle documentation.

The first thing I'd recommend is to take any tablespaces that have static data and setting them to READ ONLY. In a database that is bigger than one terabyte database, it is highly unlikely that most of that data changes. You can backup a single tablespace quite easily with RMAN. When you back up the full database, you can instruct RMAN to skip those tablespaces marked as READ ONLY, because you've already backed them up!

Another big time saver for the more dynamic tablespaces is to use RMAN's ability to perform incremental backups. This way, RMAN only backups those blocks that have changed since the last backup. With skipping READ ONLY tablespaces and incremental backups, you'd be surprised how quickly you can back up your 1.4 terabyte database.

This was first published in October 2004

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close