Database refresh

Hi ,

Could you please suggest how to perform a full database refresh when the count of users in source and target databases are dissimilar.

Source oracle version is 12c

Target oracle version is 19c

OS version is Linux

Env is Dev to Dev

Regards,

Balaji

3 answers0 replies

3 Comments

Piyush Ranjan

Nov 14, 2022

•

Hi Balaji, You have to clean the target database if you want the full database to refresh from the source. The refresh may then be processed using the Oracle Data Pump utility.

For comprehensive instructions, please see our support post.

www.support.dbagenesis.com

Oracle Database Refresh

Oracle database refresh is the most common activity in any environment. There are multiple ways to perform the database refresh. Here you will find most common methods that are used for refresh activity. Oracle Data Pump Full DB Refresh (Same Version) Oracle Data Pump Full DB Refresh (Different Version) Oracle Data Pump Full DB Refresh (Same Version) If you have few schemas to refresh, then go with schema level refresh. On source expdp schemas=QBR directory=DUMPDIR dumpfile=QBR.dmp logfile=expor

Balaji

Nov 14, 2022

•

Replying to

Hi Piyush,

Thank you for the steps. But the issue between source and target is the count of users is mismatched. In source, there are 80 users whereas in the target, there are 101 users. Please suggest how to perform DB refresh in this case.

Regards,

Balaji

Nov 20, 2022

•

Replying to

Thank you for your suggestions