Oracle 디비 백업 – expdp

expdp system/oracle@orcl directory=MY_DATA_PUMP dumpfile=shopmall.dump logfile=shopmall.dump schemas=shopmalljob_name=shopmall001

이 명령을 실행시키면..

Export: Release 12.1.0.2.0 - Production on Tue Dec 13 15:04:01 2016

Copyright (c) 1982, 2015, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3905
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5203
ORA-06512: at line 1

다음 경고가 뜨면서 처리되지 않는다.

 

1. 이미 처리중이던 녀석이 남아있으면 안될 수 있다고

이걸 확인 해 보라는데…

select * frmo dba_datapump_jobs

데이터가 있을 경우 삭제
drop table ownername.jobname

 

또 안되네

2. 스트림 풀 사이즈를 늘려보라는데

SQL> show parameter streams_pool;

NAME                                 TYPE             VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer      0


SQL> alter system set streams_pool_size=1G scope=both;

SQL> show parameter aq
 
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
SQL> alter system set aq_tm_processes=1 scope=both;

안된다

3. DBA 디렉토리 등록

SQL> select * from dba_directories;

OWNER
--------------------------------------------------------------------------------
DIRECTORY_NAME
--------------------------------------------------------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
ORIGIN_CON_ID
-------------
SYS
MY_DATA_PUMP
/data2

이건 등록되어있는 상태다

신규등록하려면
SQL> create directory MY_DATA_PUMP as '/home/datapump'
SQL> grant read, write on directory MY_DATA_PUMP to SYSTEM;
SQL> GRANT CREATE ANY DIRECTORY TO SYSTEM;
SQL> SELECT * FROM DBA_DIRECTORIES;
확인~

 

https://oracleexamples.wordpress.com/2010/02/17/expdp-error-31623-and-ora-12805-in-cluster-10-2-0-4/


-
 
@$ORACLE_HOME/rdbms/admin/catdph.sql
 
@$ORACLE_HOME/rdbms/admin/prvtdtde.plb
 
@$ORACLE_HOME/rdbms/admin/catdpb.sql
 
@$ORACLE_HOME/rdbms/admin/dbmspump.sql
 
@$ORACLE_HOME/rdbms/admin/utlrp.sql

안되네.. 중간중간오류

아직안됨…디비 깨짔나

 

질문할만한사이트가…

http://www.gurubee.net/
http://www.dator.co.kr/
http://www.dbguide.net/
http://database.sarang.net/

 

몇가지 더 확인 필요해 보이는 부분

http://www.dba-oracle.com/t_ora_31623_job_not_attached_to_session_via_specified_handle.htm

http://theone79.tistory.com/837