OCP-1Z0-053-V12.02-98题
来源:互联网 发布:中国进出口贸易数据图 编辑:程序博客网 时间:2024/05/22 13:33
98.You plan to execute the following command to perform a Flashback Database operation in your
database:
SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);
Which two statements are true about this? (Choose two)
A. The database must have multiplexed redo log files
B. The database must be in the MOUNT state to execute the command
C. The database must be in the NOMOUNT state to execute the command
D. The database must be opened in RESTRICTED mode before this operation
E. The database must be opened with the RESETLOGS option after the flashback operation
Answer: BE
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_9011.htm#SQLRF01801
TO TIMESTAMP
reverts the database back to its state at the specified timestamp.
Purpose
Use the FLASHBACK
DATABASE
statement to return the database to a past time or system change number (SCN). This statement provides a fast alternative to performing incomplete database recovery.
Following a FLASHBACK
DATABASE
operation, in order to have write access to the flashed back database, you must reopen it with an ALTER
DATABASE
OPEN
RESETLOGS
statement.
Prerequisites
You must have the SYSDBA
system privilege. A fast recovery area must have been prepared for the database. The database must have been put in FLASHBACK
mode with an ALTER
DATABASE
FLASHBACK
ON
statement unless you are flashing the database back to a guaranteed restore point. The database must be mounted but not open. In addition:
The database must run in
ARCHIVELOG
mode.The database must be mounted, but not open, with a current control file. The control file cannot be a backup or re-created. When the database control file is restored from backup or re-created, all existing flashback log information is discarded.
The database must contain no online tablespaces for which flashback functionality was disabled with the SQL statement
ALTER
TABLESPACE
...FLASHBACK
OFF
.
- OCP-1Z0-053-V12.02-98题
- 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题
- Windows 8.1 4G内存完美破解,能休眠
- 如何成为Python高手
- 通过面试!
- 《数据结构与算法分析》笔记------第二章、对分查找
- 如何用pdb进行python调试
- OCP-1Z0-053-V12.02-98题
- ubuntu安装matlab及相关设置
- python sorted和sort
- struts2 HelloWorld
- 分类特征的选择和提取
- ibatis主键生成方式 用序列实现自动增长 查询方式
- ramdisk.img system.img userdata.img制作修改
- 《数据结构与算法分析》笔记------欧几里得算法求最大公约数
- 修改进程和线程优先级(todo)