Otherwise, the system can introduce an end of line characters that make this script fail. Make sure that the db2_export.sh script is saved in UNIX format if it is copied from your Windows laptop or desktop to the db server.(Where you want to create the dump tar file)ĭb2_export.sh -db=mdmdb -dbuser=mdm1 -dbpassword=passwd -backupdir=/u01/backup -bkpfile=july10bkp It is the parameter 'username' of the section in the env_settings.ini file.ĭbuserpassword: Password of the MDM database schema user that is getting exported.īkpdirectory: Name of the directory including PATH where you want to export the database schema. It also generates required SQL scripts to create tables, indexes and sequences with current values and exports everything and stores it as a tar file in the backup directory provided.ĭb2_export.sh -db= -dbuser= -dbpassword= -backupdir= -bkpfile=ĭatabasename: Name of the database from where you want to export the schemaĮxportuser: Name of the MDM database schema user to export. Using db2_export.sh (attached to this Technote) to export the MDM schema. Before using the parameter file, you need to modify the parameters please replace the DIRECTORY and SCHEMAUSER settings and adopt the parameter PARALLEL to your environment. Please check with support whether current version rows are sufficient. To minimize the size of the dump files, you might use following expdp parameter file to avoid provision of unneeded data. # - Contents of complete_export.par file. Include all the parameters for expdp in a file, say complete_export.par, and then you can invoke the expdp command as below:Įxpdp system/manager parfile=complete_export.par expdp%U.dmp FILESIZE=1g PARALLEL=30 SCHEMAS=mdmuser STATUS=300 LOGFILE=.logĮxpdp can also invoked by using a parameter file. The filenames should contain a substitution variable (%U), which implies that multiple files may be generated.Įxpdp system/manager DIRECTORY=dump_files1 DUMPFILE= 12345.999.000. Substitute the variables, , and appropriately. SELECT * FROM dba_objects WHERE object_type = 'DIRECTORY' Įxpdp / DIRECTORY=dump_files1 DUMPFILE=.expdp%U.dmp FILESIZE=1g PARALLEL=20 SCHEMAS= STATUS=300 LOGFILE=.export.log Make sure you have sufficient space and permission to use the directory object. You may already have directory objects available, you can verify those by using queries below. You can have any other name instead of dump_files1, this name should be used for expdp command later.ī. SQL> GRANT READ, WRITE ON DIRECTORY dump_files1 to public Ī. SQL> CREATE DIRECTORY DUMP_FILES1 AS '/u02/dbdumps' Login to SQLPlus or any SQL interface using the DB Admin user and execute the following statements: It is recommended to run these steps from your DB server and stop the MDM application.ġ) Create directory object in Oracle where you want to download the dump. Please use Oracle data pump for exporting database dump files. Create a logical copy of your database schema (Oracle/DB2)Ĭreating a copy of your DB schema on Oracle Upload the copy to the IBM Support FTP Server.ġ. Create a logical copy of your database schema.Ģ.
0 Comments
Leave a Reply. |