export 백업방법... 0 8 4,773

by 개성주 [2013.02.05 09:08:55]


export 백업에대해 실습과 테스트를 해보려합니다...

이것저것 뒤져가보며 해보았습니다...

결론은 안됩니다...

죽어도 안됩니다...

테스트서버가 말을 안듣습니다... 뉴 _ 뉴


export 백업하는 방법좀 알려주셔요...
by 약쟁이총각 [2013.02.05 09:33:49]


exp 계정/패스워드  file=파일명.dmp log=로그명.log   <==== 기본적으로 이러면 될껀데요..


====== 실 습 ======
[ORACLE]:/oracle> exp scott/tiger file=test.dmp log=test.log

Export: Release 10.2.0.1.0 - Production on Tue Feb 5 09:32:39 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses KO16KSC5601 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table   BONUS   0 rows exported
. . exporting table    DEPT   4 rows exported
. . exporting table     EMP 14 rows exported
. . exporting table    SALGRADE   5 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.


by 약쟁이총각 [2013.02.05 09:37:46]

오라클이 죽었을때...

살리고 하세요
==== 실습 ====
[ORACLE]:/oracle> exp scott/tiger file=test.dmp log=test.log

Export: Release 10.2.0.1.0 - Production on Tue Feb 5 09:36:58 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


EXP-00056: ORACLE error 1034 encountered
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
EXP-00005: all allowable logon attempts failed
EXP-00000: Export terminated unsuccessfully


by 약쟁이총각 [2013.02.05 09:59:09]

이 경우는 아닌 것 같은데.. 비슷한 경우가 있어서 적어 봅니다.

==== 상황 ====
sqlplus가 작동을 안함

==== 원인 ====
서버에 문제가 있어서 kill로 오라클 프로세스를 다 죽인것이 원인같음.
==> 메모리나 기타 문제가 발생함으로 sqlplus작 작동을 안한것으로 보임

==== 처리 ====
서버 리브팅으로 처리

서버 리브팅을 해보심이 어떨련지요..


by 개성주 [2013.02.05 11:54:50]

약쟁이님... 훗
expdp라는건 10g 부터 되는걸로 아는데 후훗
exp자리에 expdp 요것만 들어감 되나요?? 후훗 이것도 알려주시죠
그러면감사가 2배 ㅠ

by 약쟁이총각 [2013.02.05 12:27:09]

저도 첨 써보는데..

인터넷 상에서는 exp 보다 더 빠르다고 하는데.. 전 그닥 빠르지 않네요.. 아마도 장비 문제인것 같네요.

옵션을 보니.. exp에 없던 기능 몃가지가 더 있는데.. 확인해 보세요..

==== 실습 ====

[ORACLE]:/oracle> expdp scott/tiger dumpfile=111.dmp

Export: Release 10.2.0.1.0 - Production on Tuesday, 05 February, 2013 12:21:35

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SCOTT"."SYS_EXPORT_SCHEMA_01":  scott/******** dumpfile=111.dmp
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 192 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."DEPT"   5.656 KB    4 rows
. . exported "SCOTT"."EMP"    7.820 KB   14 rows
. . exported "SCOTT"."SALGRADE"   5.585 KB    5 rows
. . exported "SCOTT"."BONUS" 0 KB    0 rows
Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:
  /oracle/product/10.2.0/dba_1/rdbms/log/111.dmp
Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:22:00


by 마농 [2013.02.05 15:11:22]

exp help=y
expdp help=y


by 개성주 [2013.02.05 16:06:15]
감사감사합니다
마농님...음... 영어... 음.... 나쁘다... ㅠ

by 마농 [2013.02.05 18:36:10]

오라클 PC에 한글로 깔았는데.. 한글로 보이네요.

댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.
로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입