联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
由于文件系统被勒索病毒加密,导致oracle 数据文件和备份全部被加密
E-Mail:dba@xifenfei.com
联系：手机/微信(+86 17813235971) QQ(107644445)
标题：.[data@recovery.sx].data加密数据库恢复
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有朋友找我,说他们的数据库被加密后缀名为:.[data@recovery.sx].data
E-Mail:dba@xifenfei.com
联系：手机/微信(+86 17813235971) QQ(107644445)
标题：ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
数据库启动报ORA-00600 6006错误
Tue Sep 29 14:31:31 2020 SMON: enabling tx recovery Tue Sep 29 14:31:31 2020 Database Characterset is AL32UTF8 Opening with internal Resource Manager plan where NUMA PG = 2, CPUs = 4 Tue Sep 29 14:31:34 2020 SMON: Restarting fast_start parallel rollback Tue Sep 29 14:31:34 2020 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=64, OS id=2860 Tue Sep 29 14:31:39 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p000_1084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:31:44 2020 SMON: Parallel transaction recovery slave got internal error SMON: Downgrading transaction recovery to serial Tue Sep 29 14:31:48 2020 Completed: ALTER DATABASE OPEN Tue Sep 29 14:31:48 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:31:48 2020 db_recovery_file_dest_size of 8192 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Tue Sep 29 14:31:53 2020 ORACLE Instance orcl (pid = 16) - Error 600 encountered while recovering transaction (1, 8) on object 53228. Tue Sep 29 14:31:54 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:03 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:07 2020 ORACLE Instance orcl (pid = 16) - Error 600 encountered while recovering transaction (1, 8) on object 53228. Tue Sep 29 14:32:07 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:13 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] ORACLE Instance orcl (pid = 16) - Error 600 encountered while recovering transaction (1, 8) on object 53228. Tue Sep 29 14:32:15 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:21 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:23 2020 ORACLE Instance orcl (pid = 16) - Error 600 encountered while recovering transaction (1, 8) on object 53228. Tue Sep 29 14:32:23 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:30 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:31 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_3860.trc: ORA-00474: SMON process terminated with error Tue Sep 29 14:32:31 2020 PMON: terminating instance due to error 474
因为这个错误提示比较明显“ORACLE Instance orcl (pid = 16) – Error 600 encountered while recovering transaction (1, 8) on object 53228.”和以前的文章:ORACLE Instance XFF (pid = 18) – Error 600 encountered while recovering transaction非常相似,由于数据库异常关闭导致事务无法正常回滚.通过屏蔽回滚（event 10513）,然后对相关对象进行处理(表导出数据,重新导入;index 进行重建),可以实现数据库的完美恢复
关于ORA-600 6006 ORA-600 6856解释
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Oracle is undoing an index leaf key operation. If the key is not found, --oracle 回滚index leaf key操作,如果这个值不存在,报ORA-600 6006错误 ORA-00600: internal error code, arguments: [6856], [0], [60], [], [], [] SMON is trying to recover a dead transaction. But the undo application runs into an internal error (trying to delete a row that is already deleted). --oracle 的回滚操作尝试删除一个已经删除的记录报ORA-600 6856错误
联系：手机/微信(+86 17813235971) QQ(107644445)
标题：一键恢复ORA-01113 ORA-01110—Oracle Recovery Tools
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
一般由于归档日志丢失或者非归档库可能在数据库启动的时候出现类似如下错误
SQL> startup ORACLE instance started. Total System Global Area 2137886720 bytes Fixed Size 2282960 bytes Variable Size 587205168 bytes Database Buffers 1543503872 bytes Redo Buffers 4894720 bytes Database mounted. ORA-01113: file 1 needs media recovery ORA-01110: data file 1: 'F:\ORADATA\XIFENFEI\SYSTEM01.DBF'
主要是由于数据文件不一致需要比较老的日志,但是日志不存在从而导致该问题
现在可以通过Oracle Recovery Tools工具一键解决
SQL> recover database; Media recovery complete. SQL> alter database open; Database altered.
联系：手机/微信(+86 17813235971) QQ(107644445)
标题：Oracle Recovery Tools解决ORA-00279 ORA-00289 ORA-00280故障
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
对于ORA-00279 ORA-00289 ORA-00280故障,一般是由于缺少日志(比如数据库非归档模式,或者归档日志丢失),导致某些文件无法正常online,对此Oracle Recovery Tool能够一键式快速解决.
模拟故障
非归档环境,模拟datafile 4 offline,然后多次切换日志,导致该文件无法正常online
SQL> select owner,segment_name from dba_segments where tablespace_name='USERS' AND OWNER='SYSTEM';
OWNER SEGMENT_NAME
------------------------------ ------------------------------
SYSTEM T_XIFENFEI
SQL> SELECT COUNT(1) FROM SYSTEM.T_XIFENFEI;
COUNT(1)
----------
87752
SQL> ALTER DATABASE DATAFILE 4 OFFLINE DROP;
Database altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination D:\app\Administrator\product\11.2.0\dbhome_1\RDBMS
Oldest online log sequence 22
Current log sequence 24
SQL> select group#,status,sequence# from v$log;
GROUP# STATUS SEQUENCE#
---------- ---------------- ----------
1 INACTIVE 22
2 INACTIVE 23
3 CURRENT 24
SQL> RECOVER DATAFILE 4;
ORA-00279: change 1525881 generated at 09/06/2020 13:46:17 needed for thread 1
ORA-00289: suggestion :
D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000019_1046476315.0001
ORA-00280: change 1525881 for thread 1 is in sequence #19
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
使用Oracle Recovery Tools快速修复
SQL> recover datafile 4;
Media recovery complete.
SQL> alter database datafile 4 online;
Database altered.
SQL> SELECT COUNT(1) FROM SYSTEM.T_XIFENFEI;
COUNT(1)
----------
87752
通过该工具就可以快速解决oracle丢失归档数据文件online的问题
 |
|