Consult everybody bosses how to put the production database backup restore to low test machine, hope to change parameters of some detailed point!

CodePudding user response:

To study the building Lord, exp, expdp, rman backup to restore the three methods, see which is suitable for you,

CodePudding user response:

You say low match should be the rman, you produce library generated pfile file, and then the main modification memory_target size

CodePudding user response:

Choice of technology depends on application scenarios,

CodePudding user response:

Oracle backup is my personal use more exp, imp

CodePudding user response:

More than 10 g environment, is the most simple rman duplicate, of course, if it is a part of the migration test table, can imp/exp, smoke number dblink production base

CodePudding user response:

From the production library cloning to low configuration testing library? Parameter adjustment backup and restore, major adjustment is a database instance running parameters,

CodePudding user response:

In low match first installed on the server, and oracle installation through oracle check items, and then formally database server data through expdp DMP, derived the DMP through impdp imported into the low with the server,