【DB笔试面试125】在Oracle中,Why 。。。 execute 。。。 report obsolete 。。。()

【DB笔试面试125】在Oracle中,Why 。。。 execute 。。。 report obsolete 。。。()


【DB笔试面试125】在Oracle中,Why 。。。 execute 。。。 report obsolete 。。。()


Q          题目如下所示:

Why would you execute the report obsolete command?

A、To list all backups that were no longer available for restore operations.

B、To list all backups that had aged beyond the RMAN retention criteria.

C、To  list  all  backup  set  pieces  listed  in  control-file  or  recovery-catalog  metadata  that  are  not  on  the backup media.

D、To list all datafiles that are no longer part of the database and thus do not need to be backed up.

E、To list all archived redo logs that are no longer needed for any database recovery.



     
A          答案如下所示:          



答案:B。

REPORT OBSOLETE命令是为了列出所有超出RMAN保留策略的备份,显然答案为B。


上一篇:Linux Crontab实现定时备份和删除Docker中的Mysql数据库


下一篇:Gitlab备份和恢复操作记录