OCP-1Z0-053-V12.02-218题
来源:互联网 发布:阿里云翼 编辑:程序博客网 时间:2024/06/06 00:57
218.Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the
DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:
ALTER TABLESPACE data1 BEGIN BACKUP;
While you are performing the backup, an error occurs that causes the instance to terminate abnormally.
Which statement about the DATA1 tablespace is true?
A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when
the database is opened.
C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when
the database is mounted.
D. If you restart the database, the database will not be opened.
Answer: D
答案解析:
验证测试:
1、测试users表空间
sys@TEST0924> alter tablespace users begin backup;
Tablespace altered.
2、模拟断电
sys@TEST0924> shutdown abort;
ORACLE instance shut down.
3、尝试启动,不能打开
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: '+DATA/test0924/datafile/users.260.829650045'
4、在mount状态让其结束备份模式
sys@TEST0924> alter tablespace users end backup;
Tablespace altered.
5、打开数据库
sys@TEST0924> alter database open;
Database altered.
- OCP-1Z0-053-V12.02-218题
- OCP-1Z0-053-V12.02-679题
- OCP-1Z0-053-V12.02-591题
- OCP-1Z0-053-V12.02-590题
- OCP-1Z0-053-V12.02-552题
- OCP-1Z0-053-V12.02-551题
- OCP-1Z0-053-V12.02-549题
- OCP-1Z0-053-V12.02-548题
- OCP-1Z0-053-V12.02-234题
- OCP-1Z0-053-V12.02-584题
- OCP-1Z0-053-V12.02-595题
- OCP-1Z0-053-V12.02-184题
- OCP-1Z0-053-V12.02-59题
- OCP-1Z0-053-V12.02-676题
- OCP-1Z0-053-V12.02-667题
- OCP-1Z0-053-V12.02-660题
- OCP-1Z0-053-V12.02-580题
- OCP-1Z0-053-V12.02-323题
- linux系统自启动脚本整理
- cocos2d-x在IOS7下面文字显示异常的解决办法
- 基于STK的空间态势仿真系统研究
- 2013年下半年百度安徽招聘笔试题
- Eclipse将引用了第三方jar包的Java项目打包成jar文件的两种方法
- OCP-1Z0-053-V12.02-218题
- Action的Result类型
- hibernate 错误:Provided id of the wrong type for class com.lhaix.pojo.Test. Expected: class java.la
- 自定义定时器
- linux给用户添加sudo权限
- 脚本引发的思考
- 2条完全一样的数据删除一条保留一条,用SQL语句删除。
- 基于STK的空间站星载GPS接收机仿真分析
- 用线程实现定时器功能