Windows:
exp:10G可用查看网盘
expdp:11G使用
使用这个的时候总是提示找不到日志文件,知道是因为权限的原因,但是总是解决不了
后来发现可以同过SQL语句解决。
打开PL/SQL
然后执行
select * from dba_directories
表示的都是oracle有访问权限的文件夹
我很懒,就在这选择了一个文件夹作为备份的文件夹。
勤快的解决方法
create or replace directory moridir as '/home/oracle/files';
grant read,write,execute on directory moridir to hr;
没试过,以后再说
备份语句
@echo off
rem set backupfile=f_database_%date:~0,4%-%date:~5,2%-%date:~8,2%.dmp
rem set logfile=f_database_%date:~0,4%-%date:~5,2%-%date:~8,2%.log
rem delete 30days files
forfiles /p "F:\oraold" /d -30 /c "cmd /c echo deleting @file ... && del /f @path"
cd F:\oraold
rem backup schemas
set backupfile=back_%date:~0,4%-%date:~5,2%-%date:~8,2%.dmp
set logfile=back_%date:~0,4%-%date:~5,2%-%date:~8,2%.log
expdp user/pass directory=DIR dumpfile=%backupfile% logfile=%logfile% schemas=user
Linux:
expdp:还没尝试不写。