Dear teacher,
I have an Oracle database, which combined with the middle table for nearly 500 tables, some list hundreds of millions of the amount of data, the data quantity is large, now want to transfer to another server, any good solution for, , hope everybody the teacher guidance,

CodePudding user response:

Try to consider physical methods, the use of oracle tools to migrate

CodePudding user response:

A total of how many T have roughly statistic data? The original server and data migration, can be stopped?

CodePudding user response:

The original server is best,

CodePudding user response:

If you can stop, with a cold backup way is the most save time, operation is simple,
Don't stop, using rman to do different machine,

CodePudding user response:

reference lyphpner reply: 3/f

, best original server

The amount of data? This is an important parameter

CodePudding user response:

reference 5 floor baidu_36457652 reply:

Quote: refer to the third floor lyphpner response:

, best original server

The amount of data? This is an important parameter

Hello, data volume nearly 1 t

CodePudding user response:

The data pump
And rman Duplicate should, 1 t good estimated 10 hours

CodePudding user response:

Can use rman, almost non-stop, look at your system is busy degree (also the generation of archive speed), well-prepared, a few minutes of down time is enough, of course, if allowed to have downtime, and used by the server are stored in the network conditions, convenient point to pull data directly with impdp + dblink can also, if the exp/imp, expdp/impdp these tools, suggest new library set redo, undo, temporary table space while waiting for the import may strain of database resources, and close the archive mode, import the first don't import index, after waiting for all table data import, and then use the nologging + parallel unity create index (need to be closed after), and then open the database archive mode, 1 t data, half a day to day should be done,