Migrating an Oracle database from temp server to actual server.
Hi,
I am a beginner in Oracle database administration and lately, I was assigned to migrate an existing Oracle database from a temporary server to the actual server (AIX on Power 7 server) to be used for production. The existing database is 11g R2 and is already populated with several data.
Two weeks ago, we hired a oracle database consultant which suggested that we use datapump in exporting/importing data. However I just read today regarding the use of database template which includes existing data (database seed).
Can I use oracle database template to replicate the database of the test server to the actual server or it is the datapump export/import which is the proper way of migrating?
I am a beginner in Oracle database administration and lately, I was assigned to migrate an existing Oracle database from a temporary server to the actual server (AIX on Power 7 server) to be used for production. The existing database is 11g R2 and is already populated with several data.
Two weeks ago, we hired a oracle database consultant which suggested that we use datapump in exporting/importing data. However I just read today regarding the use of database template which includes existing data (database seed).
Can I use oracle database template to replicate the database of the test server to the actual server or it is the datapump export/import which is the proper way of migrating?
0