OCP-1Z0-053-V12.02-660题
来源:互联网 发布:wtybill的淘宝店是啥 编辑:程序博客网 时间:2024/04/29 02:12
660.You want to configure the Flashback Database feature and retain flashback logs for three days.
Presently the database is open and configured in ARCHIVELOG mode.
The following steps must be performed in the correct sequence to do this:
1. Set the retention target:
SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;
2. Enable Flashback Database:
SQL> ALTER DATABASE FLASHBACK ON;
3. Mount the database:
SQL> STARTUP MOUNT EXCLUSIVE
4. Shutdown the instance:
SQL> SHUTDOWN IMMEDIATE
5. Open the database:
SQL> ALTER DATABASE OPEN;
Choose the correct sequence.
A. 4, 1, 3, 2, 5
B. 4, 3, 1, 2, 5
C. 2, 4, 3, 5, 1
D. 4, 2, 5, 3, 1
Answer: B
答案解析:
To enable flashback logging:
Ensure the database instance is open or mounted. If the instance is mounted, then the database must be shut down cleanly unless it is a physical standby database. Other Oracle RAC instances can be in any mode.
Optionally, set the
DB_FLASHBACK_RETENTION_TARGET
to the length of the desired flashback window in minutes:ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320; # 3 daysBy default
DB_FLASHBACK_RETENTION_TARGET
is set to 1 day (1440 minutes).Enable the Flashback Database feature for the whole database:
ALTER DATABASE FLASHBACK ON;
- OCP-1Z0-053-V12.02-660题
- 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-580题
- OCP-1Z0-053-V12.02-323题
- OCP-1Z0-053-V12.02-320题
- 输入一个字符串,打印出该字符串中字符的所有排列。
- HDU 1282 (2013.9.21周赛C题:回文数)
- Java提高:采用异常链传递异常
- mysql的数据基础管理
- 采用AOP+log4j记录项目日志
- OCP-1Z0-053-V12.02-660题
- 迅雷云点播解锁脚本 普通用户看云点播 破解VIP 高速点播
- Java程序员面试中的多线程问题
- Exception in thread "main" com.sun.xml.internal.ws.model.RuntimeModelerException: 解决办法
- 局域网内电脑IP冲突解决办法
- centos用户&组权限&添加删除用户问题总结
- web服务器性能/压力测试工具webbench安装使用
- 网站统计中的数据收集原理及实现
- IPhone开发中tableview cell的气泡样式的实现