You are working on a database that must be functioning 24 hours a day, 7 days a week. The database i

You are working on a database that must be functioning 24 hours a day, 7 days a week. The
database is configured in ARCHIVELOG mode. Which two options do you have for performing
user-managed backups? (Choose two.)
选项
A.You can perform consistent backups only.
B.You can perform a complete database backup without shutting down the database instance.
C.You can back up data files only when all data files have the same SCN recorded in the control
file.
D.You can back up only those data files whose headers are frozen by using ALTER

TABLESPACE BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP commands.

Correct Answers: B D

【考点分析】冷备和热备的区别,如何手工创建备份 

【题意简述】管理的数据库是可用性要求7*24的,哪些场景下可以使用手工备份实现? 

【原理概念】 脱机备份:也称为冷备份或一致性备份,指在数据库关闭情况下执行的备份.之所以称为一致备份,是因为备份时,数据文件头中的SCN号 与控制文件中的SCN 一致,数据库启动时不需要做实例恢复. 联机备份:也称为热备份或非一致备份,指在数据库打开的情况下执行的备份,之所以称为非一致备份,是因为在数据库打开时不能确保数据文件与控制文件SCN一致,需要介质恢复. 手工备份:为了防止备份时读到的块是破碎的,执行复制期间必须冻结文件头. 命令参考: alter tablespace tablespace_name begin backup; alter tablespace tablespace_name end backup; 

【答案剖析】 

A: 错误,维护的库不允许down机,不能做冷备一致性备份,只能做热备不一致性备份 

B: 正确,可以不down机做完全数据库备份,包含所有数据文件和某个控制文件 

C: 错误,热备是不一致性备份,所有文件头的SCN可以不同 

D: 正确,手工备份为了防止备份时读到的块是破碎的,执行复制期间必须冻结文件头.