053-611

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:
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.

  在数据表空间在备份模式时,实例被异常关闭,重新启动会报错,而数据库会在 mount 状态,必须执行ALTER DATABASE END BACKUP 后表空间才能脱离备份模式,数据库才能 open。

转载于:https://www.cnblogs.com/Babylon/p/7839495.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值