dbca刪庫的陷阱

哎呀我的天吶發表於2015-05-11
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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章