OCP-1Z0-053-200题-50题-628
来源:互联网 发布:春秋战国士阶层 知乎 编辑:程序博客网 时间:2024/05/01 11:24
QUESTION 50
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One
of the redo log groups has become corrupted. You have issued the following command during the recovery of
a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?
A. You should perform a log switch
B. You should make a backup of the database
C. You should switch the database to the NONARCHIVELOG mode
D. You should shut down the database instance and perform a complete database recovery
Answer: B
同628题:http://blog.csdn.net/rlhua/article/details/13280569
Explanation/Reference:
Section: Backup, Recovery & Recovery Manager (RMAN)
SQL> ALTER DATABASE CLEAR LOGFILE UNARCHIVED GROUP 3;
Immediately back up all datafiles in the database with an operating system utility, so that you have abackup
you can use for complete recovery without relying on the cleared log group.
For example, enter:
% cp /disk1/oracle/dbs/*.dbf /disk2/backup
http://www.oracle-dba-online.com/managing_redo_logfiles.htm
This statement clears the corrupted redo logs and avoids archiving them. The cleared redo logs are available
for use even though they were not archived.
If you clear a log file that is needed for recoveryof a backup, then you can no longer recover from that backup.
The database writes a message in the alert log describing the backups from which you cannot recover
- OCP-1Z0-053-200题-50题-628
- OCP-1Z0-051-2015-50题
- OCP-1Z0-053-200题-200题-61
- OCP-1Z0-053-V12.02-628题
- OCP-1Z0-053-200题-1题-677
- OCP-1Z0-053-200题-4题-88
- OCP-1Z0-053-200题-2题-86
- OCP-1Z0-053-200题-3题-87
- OCP-1Z0-053-200题-5题-89
- OCP-1Z0-053-200题-6题-90
- OCP-1Z0-053-200题-7题-91
- OCP-1Z0-053-200题-8题-92
- OCP-1Z0-053-200题-9题-93
- OCP-1Z0-053-200题-10题-94
- OCP-1Z0-053-200题-11题-95
- OCP-1Z0-053-200题-12题-96
- OCP-1Z0-053-200题-13题-97
- OCP-1Z0-053-200题-14题-675
- silverlight 中 支持datatable写法
- WebSphere部署应用后,访问页面处于loading状态。
- linux下vi命令
- 字体闪动的特效!
- C++ 中判断非空的错误指针
- OCP-1Z0-053-200题-50题-628
- Ubuntu 字体安装
- wifi 简单介绍
- 一些模板的写法
- Entity Framework的简单使用
- [存储] Cobar使用文档(可用作MySQL大型集群解决方案)
- LINK : fatal error LNK1123: 转换到 COFF 期间失败: 文件无效或损坏
- vim粘贴代码格式变乱
- 全屏背景布局居中显示demo