SQL> ALTER TABLESPACE users BEGIN BACKUP;
While copying the file to the backup destination a power outage caused the instance to te minate abnormally.
Which statement is true about the next database startup and the USERS tablespace?
A. The database will open, and the tablespace automatically comes out of the backup mode.
B. The database will be mounted, and recovery must be performed on the USERS tablespace.
C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
D. The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
Answer: C
参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osbackup.htm#BRADV90007
SQL> alter tablespace users begin backup;
表空间已更改。
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- --------------
1 NOT ACTIVE 0
2 NOT ACTIVE 0
3 NOT ACTIVE 0
4 ACTIVE 4908776 20-6月 -16
5 NOT ACTIVE 0
SQL> shutdown abort
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 2538741760 bytes
Fixed Size 2257872 bytes
Variable Size 520096816 bytes
Database Buffers 1996488704 bytes
Redo Buffers 19898368 bytes
数据库装载完毕。
ORA-10873: file 4 needs to be either taken out of backup mode or media recovered
ORA-01110: 数据文件 4: 'C:\APPS\ORACLE\ORADATA\COW\USERS01.DBF'
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- --------------
1 NOT ACTIVE 0
2 NOT ACTIVE 0
3 NOT ACTIVE 0
4 ACTIVE 4908776 20-6月 -16
5 NOT ACTIVE 0
SQL> alter tablespace users end backup;
表空间已更改。
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- --------------
1 NOT ACTIVE 0
2 NOT ACTIVE 0
3 NOT ACTIVE 0
4 NOT ACTIVE 4908776 20-6月 -16
5 NOT ACTIVE 0
SQL> alter database open;
数据库已更改。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2120480/ ，如需转载，请注明出处，否则将追究法律责任。
