LOSS OF REDO LOG FILE
来源:互联网 发布:淘宝高价买便宜东西 编辑:程序博客网 时间:2024/05/27 16:40
consistent:
SQL>start up;
ORA-00313:open failed for member of log group 3 for thread 1
SQL>select * from v$log;
SQL>alter database clear logfile group 3;
SQL> alter database clear unarchived logfile group 3;
SQL> alter database open;
when loss of archived ACTIVE log file and instance crashed:
SQL>start up mount ;
ORA-00313:open failed for member of log group 3 for thread 3
ORA-00312:online log 3 thread 3:'redo03.log'
SQL>recover database until cancel;
SQL>alter database open resetlogs;
when loss of unarchived active file or current logfile and instance crashed
SQL>start up mount ;
ORA-00313:open failed for member of log group 3 for thread 3
ORA-00312:online log 3 thread 3:'redo03.log'
SQL> host cp .........
SQL>recover database until cancel;
SQL>alter database open resetlogs;
- LOSS OF REDO LOG FILE
- redo log file troubleshooting
- redo log file
- Dump Redo Log File
- Maintain redo log file
- oracle基础:redo log file
- 55 Which statement about recovering from the loss of a redo log group is true? A. If the lost redo l
- LOSS OF A CONTROL FILE
- 如何确定 redo log file 大小
- Oracle Dump Redo Log File 说明
- Oracle Dump Redo Log File 说明
- Oracle增大redo log file的方法
- Oracle Dump Redo Log File 说明
- Oracle Redo Log File调整大小
- 重做日志文件(redo log file)
- Online Redo Log File不小心剔除了,现在每次startup都ORA-03113: end-of-file on…
- LOSS OF SYSTEM FILE IN ARCHIVELOG MODE
- redo log 在线扩容 解决:log file switch (checkpoint incomplete)
- 一个python程序员的ruby三日游(五) ——重构(一)
- 条件选择恢复
- 数据库表分割技术浅析(水平分割/垂直分割/库表散列)
- C++基础学习笔记----第二课(引用的基础知识)
- 装载问题的分支限界算法实现
- LOSS OF REDO LOG FILE
- 信号量、互斥体和自旋锁
- 数据库设计中的14个技巧
- Nginx源码学习-双向链表(ngx_queue_t)实现及实例分析
- UVA-11549 Calculator Conundrum
- AlarmManager研究
- 从赌钱游戏看PageRank算法
- linux sdkMannger的打开
- Dojo 1.9 Build 的误区