标签云
asm mount asm恢复 asm 恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2662 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币 oracle 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (93)
- 数据库 (1,481)
- DB2 (22)
- MySQL (63)
- Oracle (1,358)
- Data Guard (42)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (153)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (12)
- ORACLE 21C (3)
- Oracle ASM (62)
- Oracle Bug (7)
- Oracle RAC (43)
- Oracle 安全 (6)
- Oracle 开发 (26)
- Oracle 监听 (26)
- Oracle备份恢复 (471)
- Oracle安装升级 (74)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (68)
- PostgreSQL (13)
- PostgreSQL恢复 (3)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (32)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (15)
-
最近发表
- ORA-600 kcbzpbuf_1故障恢复
- Oracle 19c 断电异常恢复
- Oracle Recovery Tools快速恢复ORA-19909
- IMP-00009: abnormal end of export file
- truncate sys用户表导致数据库异常恢复
- MySQL 8.0版本ibd文件恢复
- linux系统文件加密勒索病毒
- RAC节点时间间隔过大导致执行root.sh不成功
- 数据库附加失败 错误5172
- ORA-00742: 日志读取在线程 %d 序列 %d 块 %d 中检测到写入丢失情况
- MyISAM表delete记录恢复
- OGG-01777 Extract abended as it ran out of sequence numbers used to create TRAIL files
- ORA-00800: soft external error, arguments: [Set Priority Failed]
- 被.mallox数据库恢复
- ora-600 kccpb_sanity_check_2故障处理
- ORA-600 3417和ORA-600 3005故障处理
- ORA-12547: TNS:lost contact故障一例
- rac kill 大事物后回滚慢,smon等待DFS lock handle和enq: TX – contention
- 最近两种加密oracle数据库文件勒索病毒可以实现直接open数据库恢复
- open只有system文件的库
友情链接
标签归档:ORA-600 3051
ORA-00322 ORA-00312恢复
数据库启动ORA-00322 ORA-00312错误,无法正常启动
Fri Mar 29 17:44:20 2019 ALTER DATABASE RECOVER datafile 1 Media Recovery Start Serial Media Recovery started Media Recovery failed with error 19909 ORA-283 signalled during: ALTER DATABASE RECOVER datafile 1 ... Fri Mar 29 17:44:20 2019 Errors in file c:\app\administrator\diag\rdbms\xff\xff\trace\xff_m000_5392.trc: ORA-00322: log 1 of thread 1 is not current copy ORA-00312: online log 1 thread 1: 'D:\APP\ADMINISTRATOR\ORADATA\xff\REDO01.LOG' Errors in file c:\app\administrator\diag\rdbms\xff\xff\trace\xff_m000_5392.trc: ORA-00322: log 2 of thread 1 is not current copy ORA-00312: online log 2 thread 1: 'D:\APP\ADMINISTRATOR\ORADATA\xff\REDO02.LOG' Errors in file c:\app\administrator\diag\rdbms\xff\xff\trace\xff_m000_5392.trc: ORA-00322: log 3 of thread 1 is not current copy ORA-00312: online log 3 thread 1: 'D:\APP\ADMINISTRATOR\ORADATA\xff\REDO03.LOG'
人工指定redo应用,报ORA-00600 3051错误
Fri Mar 29 17:56:33 2019 ALTER DATABASE RECOVER datafile 1 Media Recovery Start Serial Media Recovery started Recovery of Online Redo Log: Thread 1 Group 2 Seq 27542 Reading mem 0 Mem# 0: D:\XIFENFEI\REDO02.LOG ORA-279 signalled during: ALTER DATABASE RECOVER datafile 1 ... Fri Mar 29 17:56:49 2019 ALTER DATABASE RECOVER LOGFILE 'D:\xifenfei\REDO02.log' Media Recovery Log D:\xifenfei\REDO02.log Errors with log D:\xifenfei\REDO02.log ORA-363 signalled during: ALTER DATABASE RECOVER LOGFILE 'D:\xifenfei\REDO02.log' ... ALTER DATABASE RECOVER CANCEL Errors in file c:\app\administrator\diag\rdbms\xff\xff\trace\xff_ora_8532.trc (incident=147928): ORA-00600: ??????, ??: [3051], [82], [], [], [], [], [], [], [], [], [], [] Incident details in: c:\app\administrator\diag\rdbms\xff\xff\incident\incdir_147928\xff_ora_8532_i147928.trc
比较明显redo无法正常应用,通过屏蔽数据库一致性,强制拉库
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: D:\XIFENFEI\REDO01.LOG Block recovery stopped at EOT rba 1.76.16 Block recovery completed at rba 1.76.16, scn 0.1073742057 Doing block recovery for file 3 block 272 Resuming block recovery (PMON) for file 3 block 272 Block recovery from logseq 1, block 72 to scn 1073742051 Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: D:\XIFENFEI\REDO01.LOG Block recovery completed at rba 1.72.16, scn 0.1073742052 Errors in file c:\app\administrator\diag\rdbms\xff\xff\trace\xff_smon_5144.trc: ORA-01595: error freeing extent (16) of rollback segment (10)) ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Fri Mar 29 17:59:12 2019 Errors in file c:\app\administrator\diag\rdbms\xff\xff\trace\xff_mmon_13928.trc (incident=149097): ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Incident details in: c:\app\administrator\diag\rdbms\xff\xff\incident\incdir_149097\xff_mmon_13928_i149097.trc Fri Mar 29 17:59:12 2019 Trace dumping is performing id=[cdmp_20190329175912] Completed: alter database open resetlogs
通过重建undo,数据库open正常,安排导出数据导入数据,恢复完成
ORA-600 3051故障恢复
数据库恢复报错ORA-600 3051
SQL> startup mount pfile=D:\OneDrive\ORACLE\recover\script\pfile.txt ORACLE 例程已经启动。 Total System Global Area 2137886720 bytes Fixed Size 2177456 bytes Variable Size 1224738384 bytes Database Buffers 905969664 bytes Redo Buffers 5001216 bytes 数据库装载完毕。 SQL> select group#,sequence#,status from v$log; GROUP# SEQUENCE# STATUS ---------- ---------- ---------------- 1 743269 ACTIVE 3 743268 ACTIVE 2 743270 CURRENT SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- H:\ORADATA\xifenfei\REDO03.LOG H:\ORADATA\xifenfei\REDO02.LOG H:\ORADATA\xifenfei\REDO01.LOG SQL> recover database; ORA-00279: 更改 5683516934 (在 04/22/2017 15:54:28 生成) 对于线程 1 是必需的 ORA-00289: 建议: D:\APP\XIFENFEI\PRODUCT\11.2.0.1\DBHOME_2\RDBMS\ARC0000743268_0910390029.0001 ORA-00280: 更改 5683516934 (用于线程 1) 在序列 #743268 中 指定日志: {<RET>=suggested | filename | AUTO | CANCEL} H:\ORADATA\xifenfei\REDO03.LOG ORA-00279: 更改 5683516934 (在 04/22/2017 15:54:28 生成) 对于线程 1 是必需的 ORA-00289: 建议: D:\APP\XIFENFEI\PRODUCT\11.2.0.1\DBHOME_2\RDBMS\ARC0000743268_0910390029.0001 ORA-00280: 更改 5683516934 (用于线程 1) 在序列 #743268 中 ORA-00278: 此恢复不再需要日志文件 'H:\ORADATA\xifenfei\REDO03.LOG' 指定日志: {<RET>=suggested | filename | AUTO | CANCEL} H:\ORADATA\xifenfei\REDO01.LOG ORA-00310: archived log contains sequence 743269; sequence 743268 required ORA-00334: archived log: 'H:\ORADATA\xifenfei\REDO01.LOG' ORA-10879: error signaled in parallel recovery slave ORA-00600: internal error code, arguments: [3051], [82], [], [], [], [], [], [], [], [], [], [] ORA-10877: error signaled in parallel recovery slave ORA-10877: error signaled in parallel recovery slave ORA-10877: error signaled in parallel recovery slave ORA-10877: error signaled in parallel recovery slave
从查询的信息看库异常的时候由于redo写比较频繁,后续启动上看,需要sequence 743268的日志,但是由于redo部分异常,导致无法进行完整恢复.
屏蔽一致性强制打开库
SQL> shutdown immediate; ORA-01109: ?????? 已经卸载数据库。 ORACLE 例程已经关闭。 SQL> startup mount pfile='D:\OneDrive\ORACLE\recover\script\pfile.txt' ORACLE 例程已经启动。 Total System Global Area 2137886720 bytes Fixed Size 2177456 bytes Variable Size 1224738384 bytes Database Buffers 905969664 bytes Redo Buffers 5001216 bytes 数据库装载完毕。 SQL> recover database until cancel; ORA-00279: 更改 5683516935 (在 04/22/2017 15:54:28 生成) 对于线程 1 是必需的 ORA-00289: 建议: D:\APP\XIFENFEI\PRODUCT\11.2.0.1\DBHOME_2\RDBMS\ARC0000743268_0910390029.0001 ORA-00280: 更改 5683516935 (用于线程 1) 在序列 #743268 中 指定日志: {<RET>=suggested | filename | AUTO | CANCEL} cancel ORA-10879: error signaled in parallel recovery slave 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: 'H:\xifenfei\SYSTEM01.DBF' SQL> alter database open resetlogs; alter database open resetlogs * 第 1 行出现错误: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [2662], [1], [1388549650], [1], [1388577164], [12583040], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [2662], [1], [1388549649], [1], [1388577164], [12583040], [], [], [], [], [], [] ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [2662], [1], [1388549647], [1], [1388577164], [12583040], [], [], [], [], [], [] 进程 ID: 12120 会话 ID: 192 序列号: 3
数据库这里信息明确,由于ORA-600 2662导致数据库启动失败,可以通过推scn的方式解决
启动报ORA-600 4193错误
SMON: enabling cache recovery Successfully onlined Undo Tablespace 2. Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Sat Apr 29 00:30:11 2017 SMON: enabling tx recovery ********************************************************************* WARNING: The following temporary tablespaces contain no files. This condition can occur when a backup controlfile has been restored. It may be necessary to add files to these tablespaces. That can be done using the SQL statement: ALTER TABLESPACE <tablespace_name> ADD TEMPFILE Alternatively, if these temporary tablespaces are no longer needed, then they can be dropped. Empty temporary tablespace: TEMP ********************************************************************* Database Characterset is ZHS16GBK Errors in file d:\app\xifenfei\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_smon_9464.trc(incident=9739): ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\app\xifenfei\diag\rdbms\xifenfei\xifenfei\incident\incdir_9739\xifenfei_smon_9464_i9739.trc No Resource Manager plan active Sat Apr 29 00:30:12 2017 Trace dumping is performing id=[cdmp_20170429003012] Doing block recovery for file 3 block 35588 Resuming block recovery (PMON) for file 3 block 35588 Block recovery from logseq 4, block 76 to scn 6442492674 Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0 Mem# 0: H:\xifenfei\REDO01.LOG Block recovery completed at rba 4.85.16, scn 1.2147525379 Doing block recovery for file 3 block 208 Resuming block recovery (PMON) for file 3 block 208 Block recovery from logseq 4, block 76 to scn 6442492664 Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0 Mem# 0: H:\xifenfei\REDO01.LOG Block recovery completed at rba 4.80.16, scn 1.2147525369 Errors in file d:\app\xifenfei\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_smon_9464.trc: ORA-01595: error freeing extent (6) of rollback segment (6)) ORA-00600: internal error code, arguments: [4193], [], [], [], [], [], [], [], [], [], [], [] Starting background process QMNC
错误比较明显,直接通过屏蔽undo,open数据库,导出来数据,恢复完工