Best way to Refresh a tera byte TB

All posts relating to Oracle database administration.

Moderator: Tim...

Best way to Refresh a tera byte TB

Postby sivakumarocp » Thu Jul 25, 2013 4:47 am

Hi Tim,

this is just a Interview question.

what is the best way to refresh Multi Terabyte database into another Host. (best way in the sense it should minimize the outage time during the refresh)

what would be the optimal solution for this.
Posts: 256
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: Best way to Refresh a tera byte TB

Postby Tim... » Thu Jul 25, 2013 6:52 am


There is no one solution that is optimal. Those sort of questions are meant to be open, allowing you to discuss the alternatives, including the pros and cons. For example:

- Setup dataguard, with the new server as the standby. When you are happy to do the move, switchover gracefully and you are now running on the new environments. This impacts licensing and means both hosts need to be on the same version of the database and platform, but it is very quick.

- Transport Database, like doing transportable tablespace, but for the whole database. Only takes as long as the time it takes to copy the datafiles, but restricts to same endian plaform.

- Transportable tablespace. The piecemeal version of the above. More work, but allows a switch between endians.

- Perform image copy backups from primary. Move to secondary location. Start up database and manually recover with latest archived redo logs. Not dissimilar downtime to Data Guard, but a manual process.

- Export/import. Very slow, but logically very simple and allows you to completely change platform and endian without any messing about.

You get the idea. None are "best". All have pros and cons.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:
Site Admin
Posts: 17970
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 3 guests