Version 12 c, want to have in the use of the database, as a whole have been moving to another installation have the same version of Oracle database, including the data in table with, two database is not connected, in different cities,

Before using SQL, MDF and LDF files directly to copy the past, Oracle excuse me how to operate?

CodePudding user response:

Seems to need to stop no matter what, now that is beyond the need to move data manually, you can consider cold standby migration, copy data files (v $datafile), log files (v $logfile), the control file (v $controlfile) is ok, the trouble, then built on the same directory as the source library, also can bring the parameter file, this anyway also not time consuming space,

CodePudding user response:

Use expdp, more convenient

CodePudding user response:

The two upstairs, can you specifically talk about how to operate? Oracle novice!

CodePudding user response:

refer to the second floor to learning turn response:

use expdp, convenient

Please advice in detail how to operate, thank!

CodePudding user response:

The building Lord baidu "Oracle cold backup",

CodePudding user response:

Baidu a backup migration