Export / Import Oracle database

Toad for Oracle & DevOps Toolkit
1

I am new to the Oracle world and new to using TOAD.

We are planning to replace our Oracle Database Server. The old server is using Windows server 2016 with Oracle 19c and the new server that has Windows 2022 and Oracle 19c.

My task is to migrate the Oracle database from the old server to the new server. I want to perform the task without taking the old database off line and thought using the TOAD export/import feature. My questions are:

A: Is the TOAD feature reliable and easy to use - will it do the job
B: Is there an article or video that shows the step by step process of performing this task.

The database is about 20GB

Any feedback is appreciated.

2

Import/Export would be too slow.

If....

  • This is a pluggable database
  • You just need to move one of the pluggables
  • The source/target database version and character set is the same
  • You can create a database link from the new to old container database
  • You have archive log mode enabled on the source database
  • You have the DB Admin module in Toad

then it is probably easiest and fastest to:

  1. Install Oracle on the new server
  2. Connect to the container database on the old server
  3. Create that DB Link if it doesn't already exist.
  4. Go to database browser, select the container database and go to the "Pluggable DBs" tab.
  5. Click "Create Pluggable Database"
  6. In the dialog that appears, choose "Create from clone (accessed through DB Link)"
  7. Follow the steps in the GUI. It'll create a script for you at the end, then you can run it when you are ready.

If you don't have the DB Admin module and want to give it a shot with SQL commands, look up the documentation for "Create Pluggable Database". You'd want to use the "as clone" clause. You can specify your DB Link in there. Here's the doc. CREATE PLUGGABLE DATABASE

If that doesn't work for you, another option is DataPump. I don't have a document for you, but you should be able to find something online easily by googling "copy a database using datapump". I'm not as familiar with this process, but Toad does have a GUI for datapump to help.

3

Thank you very much for the reply,

I will give it a try