EOB之间的两个Oracle RMAN备份
我需要在一天结束过程之前和之后进行两个备份。如果EOD过程从10.00 pm开始，则备份应在开始EOD之前在10.00 PM的所有数据中包含所有数据，并且备份过程也不应影响EOD过程。有办法实现这一目标吗？
请注意，我需要检索磁盘的RMAN备份，然后胶带。
I need to take two backups before and after the day end process. If the EOD process starts at 10.00 p.m. The backup should contain all the data right at 10.00 p.m. before starting the EOD and the backup process should not impact the EOD process as well. Is there a way to achieve this?
Please note that I need to retrieve RMAN backups for disk and then tape.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
仅当您以Noarchivelog模式运行时，“快照”类型的备份类型才有必要在数据库打开时进行日志以读/写活动）。这大概会影响您的一天结束过程。
假设数据库处于Archivelog模式，并且您可以在数据库启动和运行时作为“热”备份运行备份，那么您根本不必担心备份的时机。
根据系统负载或活动有意义（请确保备份存档日志），并且在备份时运行备份，并且如果您需要以后从备份中恢复，然后恢复到您需要的确切时间点 - 一天结束过程。请参阅文档以获取时间点恢复选项： https://docs.oracle.com/en/database/oracle/oracle/oracle-database/19/bradv/rman-performing-flashback-dbpitr.html
恢复和恢复操作将恢复从备份，然后重新应用所有交易，以使数据库回到所需的时间点。备份作业的时间唯一会影响的是在恢复数据文件后可能需要重新应用的交易数量。
A "snapshot" type of backup would only be necessary if you are running in NOARCHIVELOG mode, and you'd have to shutdown the entire database to do it as a "cold" backup (you can't get a logically consistent backup without transaction logs while the database is open for read/write activity). This would presumably impact your end-of-day process.
Assuming that the database is in ARCHIVELOG mode, and that you can run your backup as a "hot" backup while the database is up and running, you do not need to worry about the timing of your backup at all.
Run a backup whenever it makes sense based on system load or activity (being sure to backup the archive logs too), and if you need to recover from a backup later then recover to the exact point in time that you need - before or after your end-of-day process. See the documentation for Point in Time Recovery options: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing-flashback-dbpitr.html
The restore and recovery operation will restore from the backup and then re-apply all transactions to bring the database back to the desired point in time. The only thing the timing of the backup job would affect would be the number of transactions that might need to be re-applied after the data files are restored.