Best way to Refresh a tera byte TB

All posts relating to Oracle database administration.

Moderator: Tim...

Posts: 260
Joined: Sat Jun 27, 2009 3:53 am
Location: India

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.

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

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:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests