DATA PUMP SOURCE STEPS
<Source DBName>
<Client Name>
Oracle Database Migration
Author: Ananda Ghosh Dastidar
Creation Date: July 9, 2021
Last Updated: July 9, 2021
Version: 1.2
Template Version: 1.2
Data pump Source Steps
Error: Reference source not found
1 DOCUMENT CONTROL
1.1 Change Record
3
Date Author Version Change Reference
1.2 Reviewers
Name Email
1.3 Template Change
Record
3
Date Author Version Change Reference
Oracle Database Migration Process 3 of 5
File Ref: 532845999.doc(v. 1.2 )
Data pump Source Steps
Error: Reference source not found
Contents
1 Document Control..................................................................................................... ii
1.1 Change Record........................................................................................................... ii
1.2 Reviewers.................................................................................................................... ii
1.3 Template Change Record............................................................................................ ii
2 Introduction............................................................................................................... 1
2.1 Purpose....................................................................................................................... 1
2.2 Background................................................................................................................. 1
2.3 Scope.......................................................................................................................... 1
3 Process...................................................................................................................... 2
4 Open and Closed Issues........................................................................................... 5
4.1 Open Issues................................................................................................................ 5
4.2 Closed Issues.............................................................................................................. 5
Oracle Database Migration Process 3 of 5
File Ref: 532845999.doc(v. 1.2 )
2 INTRODUCTION
2.1 Purpose
This “Datapump” Source Steps document provides the steps that need to be executed on the source
database.
2.2 Background
As the outcome of the Analysis phase, the “Datapump” approach was finalized for migrating the
source Oracle database “<Source database>” to target database “<Target_DBName> “.
This document has been developed to provide steps commands/SQLs that needs to be executed by
the customer DBA on the source database
2.3 Scope
The scope of this document is to:
Provide the steps to be executed on the source database
Process 3 of 5
File Ref: 532845999.doc(v. 1.2 )
3 PROCESS
This component contains steps that need to be executed on Source.
Sl.
Source Information Details
No.
1 Source Database Name <Source_DBName>
2 Source Database Version <Source_DBVer>
[e.g. 11.2.0.3]
3 Server Name <Server_Name>
Below Source Steps to be performed by DBA Team
Source_export_scripts.zip
It is assumed that :-
1. Directory will be created like /local_path/<DB_NAME> than
2. Copy the given zip file at this location and unzip it like $ unzip Source_export_script.zip
3. Execute the respective SQL/command as per the instructions given below
4. This will generate .sql, log,.csv and .dmp files
5. Once completed, please upload all files to us
Total
Sl. Co End
Start Time
N Step Information Details mm Tim Output/Log Details
Time Take
o. ents e
n
1. Generates ddl for MF_AF_IMPDP_GRANT_O
To execute the script : BJ_PRIVS_DDL.SQL
users, roles and
privileges, $ sqlplus "/ as sysdba" MF_AF_USR_GRANT_ROL
tablespaces, ES_DDL.SQL
synonym, db_link, SQL> @MF_DP_Source_Gen_Ddl.sql
Process 3 of 5
File Ref: 532845999.doc(v. 1.2 )
directory and SQL> MF_BF_USR_CREATE_RO
LES_DDL.SQL
parfile for export
on source database MF_CREATE_DBLINK_DD
L.SQL
MF_CREATE_DIRECTORY
_DDL.SQL
MF_CREATE_PUBLIC_SY
NONYM_DDL.SQL
MF_CREATE_TBS_DATA_
DDL.SQL
MF_CREATE_TBS_TEMP_
DDL.SQL
Note: MF_CREATE_USER_PROF
This will also generate the parfile required to ILE_DDL.SQL
execute expdp. Below is the sample parameter file
which will generate out from the above script. MF_CREATE_USERS_DDL
.SQL
USERID='/as sysdba'
LOGFILE=TMW_DIR:TMW_APP1_EXPDP.log MF_RECYCLEBIN_LIST.L
JOB_NAME=APP1_07072021_1144 OG
DUMPFILE=TMW_DIR:TMW_APP1_%U
PARALLEL=2 -> This can be changed as per TMW_APP1_EXPDP.PAR
requirement
CLUSTER=N TMW_invalid_details_<<dd
METRICS=Y mmyyyy_miss>>.lst
REUSE_DUMPFILES=YES
FULL=Y
2. Capture Source source_data.csv
Objects counts & To execute the script :
Metadata for
$ sqlplus "/ as sysdba"
Reconciliation after
Migration/Upgrade SQL> @MF_DP_Recon_Source.sql
Database SQL>
Expdp command TMW_APP1_EXPDP.log
on source database To execute export :
TMW_APP1_%U.dmp
$ expdp parfile=ADW_CIMEIS2R_EXPDP.PAR
Process 3 of 5
File Ref: 532845999.doc(v. 1.2 )
4. FINAL NOTE Ensure to have the outputs of the above steps and export dump Above all files
files get uploaded to OCI Object storage bucket
Process 3 of 5
File Ref: 532845999.doc(v. 1.2 )
4 OPEN AND CLOSED ISSUES
4.1 Open Issues
ID Issue Resolution Responsibility Target Date Impact Date
4.2 Closed Issues
ID Issue Resolution Responsibility Target Date Impact Date
Process 3 of 5
File Ref: 532845999.doc(v. 1.2 )
