redo文件丢失,没有开启归档归档 恢复 _allow_resetlogs_corruption"=true
来源:互联网 发布:数据审核专员 编辑:程序博客网 时间:2024/05/29 09:13
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup mount
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 117442128 bytes
Database Buffers 163577856 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL>
SQL> alter database noarchivelog;
Database altered.
SQL> alter database open;
Database altered.
产生交易 切换日志 数据库直接断电
SQL> select * from v$Log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------- ------------- -------------------
1 1 8 52428800 1 NO ACTIVE 617432 2011-06-13 05:47:27
2 1 9 52428800 1 NO CURRENT 617437 2011-06-13 05:47:30
3 1 7 52428800 1 NO ACTIVE 617420 2011-06-13 05:47:02
SQL> select * from v$Logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ---------- ------- --------------------------------------------- ---
3 ONLINE /u01/oracle/oradata/db20/redo03.log NO
2 ONLINE /u01/oracle/oradata/db20/redo02.log NO
1 ONLINE /u01/oracle/oradata/db20/redo01.log NO
SQL> ! cp /etc/passwd /u01/oracle/oradata/db20/redo01.log
SQL> shut abort
ORACLE instance shut down.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 117442128 bytes
Database Buffers 163577856 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/oracle/oradata/db20/redo01.log'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
SQL>
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/oracle/oradata/db20/redo01.log'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
SQL> recover database until cancel;
ORA-00279: change 617432 generated at 06/13/2011 05:47:27 needed for thread 1
ORA-00289: suggestion : /home/oracle/arc1/1_8_753687918.dbf
ORA-00280: change 617432 for thread 1 is in sequence #8
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '/home/oracle/arc1/1_8_753687918.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/oracle/oradata/db20/system01.dbf'
SQL>
SQL> ! ls /home/oracle/arc1/1_[5-9]_753687918.dbf
ls: /home/oracle/arc1/1_[5-9]_753687918.dbf: 没有那个文件或目录
数据库根本没归档 但数据库还根据 log_archive_dest_1 和 log_archive_format 参数的记录去找归档
借助隐藏参数不要再恢复了,也不要redo了,直接启库
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
System altered.
SQL> shut immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 117442128 bytes
Database Buffers 163577856 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open RESETLOGS;
Database altered.
SQL>
SQL> alter system set "_allow_resetlogs_corruption"=false scope=spfile;
System altered.
SQL> shut immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 117442128 bytes
Database Buffers 163577856 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>
- redo文件丢失,没有开启归档归档 恢复 _allow_resetlogs_corruption"=true
- ORACE 非归档模式redo文件恢复
- 非归档redo损坏的加_allow_resetlogs_corruption参数打开数据库
- (归档模式)丢失非关键文件恢复
- 目标:丢失所以控制文件,数据库文件,redo文件。只有rman全备的和所有归档的恢复
- 非归档模式下,redo丢失案例
- 跳过丢失归档进行恢复
- redo文件丢失恢复
- 未启用归档数据库非数据文件(spfile,control,redo,undo,temp)全丢失的恢复方法
- 未启用归档数据库非数据文件(spfile,control,redo,undo,temp)全丢失的恢复方法
- 未启用归档数据库非数据文件(spfile,control,redo,undo,temp)全丢失的恢复方法
- 恢复系列2--归档模式下丢失单个文件
- 丢失归档日志文件的数据库恢复方法
- Oracle丢失归档日志文件的数据库恢复方法
- 同时丢失参数文件、控制文件及redo log file的不完全恢复(有数据文件的热备和归档)
- 模拟控制文件全部丢失与归档日志文件丢失的不完全恢复
- 用归档日志恢复丢失的数据文件
- rman 恢复---归档丢失and数据文件损坏
- [telnet]telnet的退出
- 腾讯面试题之海量数据处理
- 孔浩javacript基础笔记二
- 关于端口占用问题
- 集成项目管理工程师 之 《法律法规和标准规范》
- redo文件丢失,没有开启归档归档 恢复 _allow_resetlogs_corruption"=true
- HDU 2795 Billboard 线段树
- Hadoop启动时:log4j报错
- linux shell 的 for 循环
- 图像处理之Fuzzy C Means的聚合算法
- HDU 1171 Number Sequence
- 第四次上机报告
- NFS服务器配置---ARM-Linux挂载
- Android v21.1.0虚拟机上下左右按键