OCP 1Z0 053 178
来源:互联网 发布:who s your daddy 知乎 编辑:程序博客网 时间:2024/04/19 13:38
situation?
A. Recover the online redo log from backup.
B. Delete and re-create the log file.
C. Use the alter database clear logfile command to clear the log file.
D. Shut down the database and restart it.
E. Shut down the database and then mount it. Clear the log file with the alter database clear logfile
command and then restart the database with alter database open resetlogs.
Answer: C
online redo log在备份里是没有的。
如果损坏了,表示你的数据永远丢了。
clear它,然后RESETLOGS 启动吧
http://docs.oracle.com/cd/E11882_01/server.112/e25494/onlineredo.htm#ADMIN11327
Clearing a Redo Log File
A redo log file might become corrupted while the database is open, and ultimately stop database activity because archiving cannot continue. In this situation the ALTER DATABASE CLEAR LOGFILE
statement can be used to reinitialize the file without shutting down the database.
The following statement clears the log files in redo log group number 3:
ALTER DATABASE CLEAR LOGFILE GROUP 3;
This statement overcomes two situations where dropping redo logs is not possible:
If there are only two log groups
The corrupt redo log file belongs to the current group
If the corrupt redo log file has not been archived, use the UNARCHIVED
keyword in the statement.
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
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 recovery of 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.
Note:
If you clear an unarchived redo log file, you should make another backup of the database.- OCP 1Z0 053 178
- OCP 1Z0 052 178
- OCP 1Z0 053 1
- OCP 1Z0 053 2
- OCP 1Z0 053 3
- OCP 1Z0 053 4
- OCP 1Z0 053 5
- OCP 1Z0 053 6
- OCP 1Z0 053 7
- OCP 1Z0 053 8
- OCP 1Z0 053 9
- OCP 1Z0 053 10
- OCP 1Z0 053 11
- OCP 1Z0 053 12
- OCP 1Z0 053 13
- OCP 1Z0 053 14
- OCP 1Z0 053 15
- OCP 1Z0 053 16
- HDU 4859 海岸线 ISAP 最小割
- UVa10855 - Rotated square(矩阵旋转)
- Python:使用threading模块实现多线程编程
- erlang re正则表达式模块
- 1005: [HNOI2008]明明的烦恼 (prufer编码,排列组合,质因数分解,高精度)
- OCP 1Z0 053 178
- nyoj 226 && hdu HDU 1348 && poj 1113 wall [凸包周长]
- 求两个字符串的最长公共子串
- 怎样设置网站禁止复制
- Tomcat 设置直接通过IP访问程序,而不用通过ip+端口+程序
- Struts2对Action提交方法进行验证
- Apache正反向代理
- Statistical Language Wars: The Infograph
- C# const ,readonly,static之间的区别