北京建设企业协会网站首页,微博推广渠道,设计素材网站无版权,电影网站建设需要多少钱–管理员方式登录#xff0c;新建表空间和用户#xff0c;并建立文件夹映射路径并授权 CREATE DIRECTORY directory_name AS ‘path_to_directory’; grant read,write on directory directory to backup
**
—EXPDP多线程备份数据库脚本–dblink–可以修改为命令行
echo …–管理员方式登录新建表空间和用户并建立文件夹映射路径并授权 CREATE DIRECTORY directory_name AS ‘path_to_directory’; grant read,write on directory directory to backup
**
—EXPDP多线程备份数据库脚本–dblink–可以修改为命令行
echo offset curdate%date:~0,4%%date:~5,2%%date:~8,2%expdp backup/backup directoryjndx schemasccense dumpfile%curdate%jndx%%U.dmp logfile%curdate%jndx.log network_linkjndx_public_dblink compressionALL parallel8forfiles /p D:\backup /s /m *.dmp /d -4 /c cmd /c del fileecho 删除2天前的备份记录forfiles /p D:\backup /s /m *.dmp /d -4 /c cmd /c del pathforfiles /p D:\backup /s /m *.log /d -4 /c cmd /c del pathexit –IMPDP-多文件还原数据库 impdp可以导入多个数据文件
impdp backup/backup directoryjiangnan schemasccense dumpfile20231008jndx%U.dmp logfileimpdpjndx.log
