Q

Increasing Oracle storage capacity by moving to a new storage with minimum downtime

Looking to move to a higher Oracle storage capacity with minimum downtime? Read this tip from expert Brian Peasland.

We are currently using Oracle 8i OLTP database and the size is around 120TB.

We are planning to move the entire database from one storage unit to a higher capacity storage unit.

I am planning to create a standby database for the new storage and then switch over the database roles.

Can you suggest an alternative that will leave us with minimum downtime?

While you have a 120TB database, I would bet that most of the data rarely changes. Move the static data to a READ ONLY tablespace. At this point, you can use OS commands to copy the datafiles to the new storage. Then a quick OFFLINE, RENAME, and ONLINE will point the database to the file's new location, similar to the following:

ALTER TABLESPACE ts_name OFFLINE;
ALTER DATABASE RENAME FILE '/old_dir/file_name' TO
'/new_dir/file_name';
ALTER TABLESPACE ts_name ONLINE;

The above can be put into a script and run from SQL*Plus. It does not take long to do the above operations.

This was first published in August 2008

Dig deeper on Oracle database administration

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