Ask the Expert

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

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: