dbca删库的陷阱

SQL>select * from dba_directories
OWNER       DIRECTORY_NAME          DIRECTORY_PATH
---------- ------------------------------ ----------------------------------------------------------------------------------------------------
SYS       SUBDIR                    /u01/app/oracle/product/11.2.0/db_1/demo/schema/order_entry//2002/Sep
SYS       SS_OE_XMLDIR              /u01/app/oracle/product/11.2.0/db_1/demo/schema/order_entry/
SYS       LOG_FILE_DIR              /u01/app/oracle/product/11.2.0/db_1/demo/schema/log/
SYS       MEDIA_DIR                 /u01/app/oracle/product/11.2.0/db_1/demo/schema/product_media/
SYS       XMLDIR                    /u01/app/oracle/product/11.2.0/db_1/rdbms/xml
SYS       DATA_FILE_DIR             /u01/app/oracle/product/11.2.0/db_1/demo/schema/sales_history/
SYS       DATA_PUMP_DIR             /u01/app/oracle/admin/test/dpdump/
SYS       ORACLE_OCM_CONFIG_DIR      /u01/app/oracle/product/11.2.0/db_1/ccr/state

expdp directory=DATA_PUMP_DIR dumpfile=20150511_emp.dmp logfile=20150511_emp.log schema=emp
cd /u01/app/oracle/admin/test/dpdump/
ls
20150511_emp.dmp  20150511_emp.log  dp.log

DBCA删库

/u01/app/oracle/admin/test/dpdump
ls -l

大家要小心啦~~~dbca会清空dump路径的，测试环境11.2.0.3，低版本的也会
同时spfile initSID.ora也会删除

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29990276/viewspace-1647524/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29990276/viewspace-1647524/