OCP-1Z0-053-V12.02-154题
来源:互联网 发布:材料结构工程师知乎 编辑:程序博客网 时间:2024/06/08 03:30
154.A database is running in ARCHIVELOG mode and regular backups are performed. A user receives
the following error message:
Which is the recommended sequence of operations you need to perform for the query successfully?
A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and
then bring it online.
C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then
open the database with resetlogs.
D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover
the tablespace, and then put the database in normal operational mode.
Answer: C
答案解析:
ORA-01116: error in opening database file 6
ORA-01110: data file 6: '/u01/app/oracle/oradata/test1107/test01.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
[oracle@rtest ~]$ oerr ora 1116
01116, 00000, "error in opening database file %s"
// *Cause: Usually the file is not accessible.
// *Action: Restore the database file.
A,错,缺少文件,不能打开数据库,在mount状态下不能drop表空间。
B,错,缺少recover
C ,错,可以直接open数据库,不能使用resetlogs,因为不是不完全恢复。
D,错,在RESTRICTED 模式下,rman能连接不能使用,报错:ORA-19573: cannot obtain exclusive enqueue for datafile 6
- OCP-1Z0-053-V12.02-154题
- 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题
- Ubuntu 12 下安装和配置Apache2
- Q1.1
- 人生规划
- DreamWeaver和VS2010如何结合开发
- android分辨率详解
- OCP-1Z0-053-V12.02-154题
- 基础回顾
- Java中>、>>、>>的区别
- latex-suite 备忘
- ecmall购物获积分功能 积分抵扣设置 积分购物
- SAP 账期
- android2.2 2.3状态栏区别
- excel 统计用的,谢谢师兄的提示。
- Launcher 个人心得