选择性表/对象 Oracle 备份
我需要自动执行当前通过 PL/SQL Developer 进行的选择性表/用户对象备份。
我目前的方式是通过工具/导出表和工具/导出用户对象，手动选择表/对象，然后设置选项，选择目标并导出。我在 Windows 笔记本电脑上执行此操作，数据库位于 suse Linux 服务器中，两者位于同一 LAN 中。 DB 24/7 全天候运行且无法关闭。另外，目前我的 Oracle 编程技能非常基础，因为我只对此解决方案进行维护。我想继续在 Windows 笔记本电脑中进行备份过程，但我也会考虑服务器端脚本解决方案，然后从服务器检索 .sql 文件。
提前致谢
I need to automate a selective table / user object backup I currently am doing via PL / SQL Developer.
The way I currently do it is via Tools/Export Tables and Tools/Export User Objects, manually select tables / objects, then set the options, choose destination and export. I do this from a windows laptop and the database is located in a suse linux server, both are in the same LAN. DB is running 24/7 and can not be shutdown. Also currently my oracle programming skills are very basic as I only do maintenance to this solution. I would like to keep doing the backup process in the windows laptop, but I would consider a server side script solution also and then retrieving the .sql files from server.
Thanks in advance
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我不会真正将其称为备份，但请查看 实用程序手册
I wouldn't really call it a backup, but look at exp/imp and expdp/impdp (data pump) in the Utilities manual
正如加里暗示的那样，exp/imp 实际上不是一个备份解决方案。如果此数据库对您或其他人很重要，请了解如何使用 RMAN ，通常配置为在不需要关闭数据库的模式下运行。尽管它在数据库主机上执行，并且对于非磁带目标必须将其文件写入连接到主机的文件系统，但它可以远程启动。
RMAN 旨在恢复/恢复整个数据库，因此如果您正在寻找的只是恢复孤立对象的能力，那么它可能不适合您。
As Gary implies exp/imp really isn't a backup solution. If this database is important to you or others, figure out how to use RMAN , which is usually configured to run in a mode that doesn't require the database to be shut down. Although it executes on the database host and for non-tape destinations must write its files to a filesystem attached to the host, it can be launched remotely.
RMAN is aimed at restoring/recovering the entire database, so if what you're looking for is only the ability to recover isolated objects it may not be for you.