To change a database server,
Can put the original ORACLE_HOME directory directly copied, the new server installation path,
25 g of libraries, exp/imp way slower export import data?

CodePudding user response:

Data file under $ORACLE_HOME just software, such as the database file by default in $ORACLE_BASE/oradata/$ORACLE_SID directory, not the default, you can check the v $datafile views, such as data files, log files, control files, such as the three core file can be directly will have a cold backup database is copied to the new environment, of course, if the operating system is changed, it depends on the situation,

CodePudding user response:

Fastest possible, direct copy the file

1. On the new server, installed with a version of the database software, create listening, do not need to create database;
2. The old database instance is turned off, the data files, control files, and redo files, such as copy to the new server, the new best path and the original path is consistent, or need to modify the parameters;
Environment variable oracle_sid (3), oracle_home and after the original library is consistent, the rest is some finishing touches in the Linux/Windows, then start

CodePudding user response:

Is no problem in theory, the equivalent of a cold backup

CodePudding user response:

Tomorrow ready to have a try,
Any data link for everyone a great god, send a bai,

CodePudding user response:

reference 4 floor winter_sui response:

tomorrow ready to have a try,
Any data link for everyone a great god, send a bai,

A few years ago, I upload a document, you can consult,

Download the channel, to find I had directly,

CodePudding user response:

Can copy the files directly, but the configuration is complex, and the late operation and maintenance easy problems,
If the original business and small amount of data in the database, suggestion:
1. The whole database backup data was derived, using the data pump
2. Install the same version of the data on the new machine,
3. Use a data pump import data, back to the database before,
Do so, the operation is simple, and the probability of problems are very few,