OCP 1Z0 053 181

181.Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. 
This is the only backup you have. You have lost all the archived redo logs generated since the previous 
Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need 
to restore your backup due to database loss. To which point can you restore your database? 
A. 13:00 on Tuesday. 
B. 15:00 on Tuesday. 
C. Up until the last available archived redo log on Sunday. 
D. To any point; all the redo should still be available in the online redo logs. 
E. The database is not recoverable. 
Answer: E

数据库open状态下的备份是非一致性备份,需要应用归档日志做recover。现在归档日志丢失,所以不能还原数据库。

file:///G:/book/Oracle/E11882_01/backup.112/e10642/rcmcncpt.htm#BABIHBBE

Consistent Backups

You can use the BACKUP command to make consistent and inconsistent backups of the database. A consistent backup occurs when the database is in a consistent state. A database is in a consistent state after being shut down with the SHUTDOWN NORMALSHUTDOWN IMMEDIATE, or SHUTDOWN TRANSACTIONAL commands. A consistent shutdown guarantees that all redo has been applied to the datafiles. If you mount the database and make a backup at this point, then you can restore the database backup later and open it without performing media recovery.

Inconsistent Backups

Any database backup that is not consistent is an inconsistent backup. A backup made when the database is open is inconsistent, as is a backup made after an instance failure or SHUTDOWN ABORT command. When a database is restored from an inconsistent backup, Oracle Database must perform media recovery before the database can be opened, applying any pending changes from the redo logs.

Note:

RMAN does not permit you to make inconsistent backups when the database is in  NOARCHIVELOG mode. If you employ user-managed backup techniques for a  NOARCHIVELOG database, then you must not make inconsistent backups of this database.

If the database runs in ARCHIVELOG mode, and you back up the archived redo logs and datafiles, inconsistent backups can be the foundation for a sound backup and recovery strategy. Inconsistent backups offer superior availability because you do not have to shut down the database to make backups that fully protect the database.


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL 8 OCP (Oracle Certified Professional)1Z0-908是一套关于MySQL数据库的考试题库。MySQL是一种流行的开源关系型数据库管理系统。此考试题库旨在评估考生对MySQL数据库的知识、技能和能力。 MySQL 8 OCP 1Z0-908题库包含了多个主题,涵盖了MySQL数据库的各个方面。主要的考题包括: 1. MySQL 8的新功能和改进:考核考生对于MySQL8版本中新增的新功能和改进的理解和应用。 2. 数据库设计和建模:考核考生在设计和建模数据库时的能力,包括定义和优化表、索引、视图、存储过程和触发器等数据库对象。 3. 查询和数据操作:考核考生编写和优化SQL查询和数据操作的能力,包括基本查询、多表联接、子查询、聚合函数和事务处理等。 4. 数据库安全和性能优化:考核考生在数据库安全性和性能优化方面的知识和实践,包括用户和权限管理、备份和恢复、性能调优和查询优化等。 5. 数据库监控和维护:考核考生对于数据库监控和维护的能力,包括定期备份、日志分析、故障排除和性能调优等。 通过MySQL 8 OCP 1Z0-908的考试,考生可以证明自己在MySQL数据库管理方面的专业能力和水平。对于数据库管理员、开发人员和其他与数据库相关工作的人员来说,持有MySQL OCP认证可以提升职业竞争力,获得更好的工作机会。因此,掌握和熟悉MySQL 8 OCP 1Z0-908题库中的内容对于有意考取MySQL OCP认证的人来说是非常重要的。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值