Forum Stats

  • 3,770,132 Users
  • 2,253,073 Discussions
  • 7,875,337 Comments

Discussions

Moving 1TB Oracle 9i Database on Solaris to Oracle 12c on Linux

User_GU1HH
User_GU1HH Member Posts: 1 Green Ribbon

We will be modernizing an Oracle 9i Database on Solaris to a supported version of Oracle on Linux. We already have successfully done Dev modernization using exp/imp, but now with Production being over 1TB in size, we are looking for advice on the best method to complete this migration with the least amount of downtime and room for error. We know we cant use RMAN because we are going from Solaris to Linux, and we cant use Data Pump because we are currently on Oracle 9. We could use EXP/IMP, but I am worried about time and risk of error when using exp/imp on a 1TB + Database in size. Do you have any recommendations on how we can proceed with our modernization?

Tagged:

Answers