OCP-1Z0-053-V12.02-559题

559.Another DBA issues a shutdown abort command on a database on which you were running an online

backup. What will happen when you try to restart the database?

A. Oracle will automatically take the datafile out of hot backup mode, generate a warning message, and

then open the database.

B. Oracle will automatically take the datafile out of hot backup mode and then open the database.

C. Oracle will generate an error when trying to open the database, indicating that a datafile is in hot

backup mode.You will need to correct this error before you can open the database.

D. The database will open with the file in hot backup mode. You can restart the backup at any time.

E. The datafile in hot backup mode will be corrupted and you will have to recover it.

Answer: C

答案解析：

实验演示：

sys@TEST0924> alter tablespace users begin backup;

Tablespace altered.

sys@TEST0924> shutdown abort;

ORACLE instance shut down.

sys@TEST0924> startup

ORACLE instance started.

Total System Global Area 3340451840 bytes

Fixed Size                  2232960 bytes

Variable Size            3204451712 bytes

Database Buffers          117440512 bytes

Redo Buffers               16326656 bytes

Database mounted.

ORA-10873: file 4 needs to be either taken out of backup mode or media recovered

ORA-01110: data file 4: '/u01/app/oracle/oradata/test0924/users01.dbf'

sys@TEST0924> alter tablespace users end backup;

Tablespace altered.

sys@TEST0924> alter database open;

Database altered.

从以上演示可知，在users表空间备份模式下，数据库被shutdown abort，然后不能open数据库，报错。只能在mount状态下，先把users表空间的备份模式结束，然后再打开数据库。