Oracle 11g数据库备份 [英] Oracle 11g Database Backup

问题描述

现在，我正在使用Oracle 11g数据库.我想每天晚上10.00自动进行数据库备份.这意味着Oracle 11g数据库架构将每天晚上10:00自动导出.我该怎么做?请帮助我，尽快提供解决方案.对不起，我的英语不好.所以，请帮助我！
谢谢你
TMSRANA

Hi,

Now I am working in Oracle 11g Database. I want to take database Backup everyday at 10.00pm automatically. That means the The Oracle 11g Database Schema will automatically export everyday at 10.00pm. How Can I do it? Please, help me by giving solution as soon as possible. Sorry for my poor English. So, please help me!!!!

Thanking You
TMSRANA

推荐答案

您有几种选择.根据存档日志设置，您必须考虑是仅导出还是完全备份，还是还要进行日志备份.

您可以使用的一种备份工具是RMAN.要了解RMAN，建议阅读使用RMAN备份和还原文件 [ ^ ].

另一种方法是使用数据泵(在这种情况下为expdp)进行基本导出.要了解有关expdp的更多信息，请参见数据泵导出 [

You have several options. Depending on the archivelog setting you have to consider if you rake just exports or full backups or do you take log backups also.

One backup tool you can use is RMAN. To get to know RMAN I suggest reading Using RMAN to Back Up and Restore Files[^].

Another way is to do a basic export using the data pump, expdp in this case. To know more about expdp, see Data Pump Export[^]

With both tools you would need a mechanism to schedule the backup. For this you can use the scheduling mechanism of the operating system (Windows scheduler, crontab etc) or you can use the Oracle database scheduling mechanism to fire the backup on desired intervals.

这篇关于Oracle 11g数据库备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！