posted 22 Jul 2011, 08:10 by Alan Nolan-Davies
1. Create a Directory in ASM for the dumpfile
$ su - grid
$ asmcmd
$ ls DATA FRA OCR_VOTING
$ cd data
$ mkdir dpdump
2. Create an Oracle Directory in the database to use the dumpfile
$ sqlplus / as sysdba
SQL> create or replace directory ASM_DUMP as '+DATA/dpdump';
SQL> grant read,write on directory asm_dump to system;
3. Create a Unix directory for the logfile
$ mkdir /home/oracle/log
4. Create an Oracle Directory for the logfile
$ sqlplus / as sysdba
SQL> create or replace directory LOGDIR as '/home/oracle/log';
SQL> grant read,write on directory logdir to system;
5. create a parameter file for the datapump export
$ vi expdp_full.par
userid=system/password directory=asm_dump logfile=logdir:import.log full=y
6. run datapump export
$ expdp parfile=expdp_full.par
|
|
