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