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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top