E-mail:chf.dba@gmail.com
Title: Professional Oracle Database Recovery Service
Author: DATABASE SOS©All rights reserved [without my consent, it may not be reproduced in any form, otherwise there is the right to further legal responsibility.]
The database is the core of an enterprise. If the database cannot run normally due to damage and data is lost, it will bring irreparable economic damage to the enterprise. When your database fails and there is no effective backup, we are your last line of defense, to the greatest extent possible to help you save the database and reduce losses. We are serving the original Oracle Original Aftermarket (ACS) , with Oracle ACE a team of well-known domestic database experts; help customers Restore database 1000 sets or more, the total amount of recovered data 1000T Above; restore database versions from ORACLE 7, ORACLE 8 / 8I, ORACLE 9I, ORACLE 10G, ORACLE 11G, ORACLE 12C, ORACLE 18C to ORACLE 19C; platforms include Linux, Windows, AIX, HP-UNIX, SOLARIS Customers from Xinjiang to Hainan, from Heilongjiang to Guangxi in all provinces of China; customers include: finance (insurance, banking, securities, funds, etc.), communications (mobile, telecommunications, Unicom), energy (electricity, petroleum, coal, Photovoltaics, etc.), government / public (public security, social / medical insurance, military, universities, hospitals, taxation, government, etc.), manufacturing / commerce (Internet, electronic machinery, trade distribution, manufacturing, etc.) and other industries. No matter what kind of database failure you are, no matter how many individuals and companies you have found to be unsuccessful, we are all a worthy choice for you. We dare not say that the national technology is first, but it is definitely the first echelon of Oracle database recovery in China. We can guarantee that if we cannot recover the Oracle database, almost no one can recover your database success. We promise: All databases are unsuccessful and no fee will be charged if we fail to meet our commitments.
If you need professional ORACLE database recovery technical support, please contact us
E-Mail:chf.dba@gmail.com
Mainly supports but not limited to database recovery content
Drop table recovery by mistake
Data file size is 0kb
Delete / update by mistake
Error truncate table recovery
asm data file missing / accidental deletion
Lost system file database recovery
asm disk was accidentally formatted and recovered
Object verification is corrupted in bootstarp $
Oracle data files are encrypted for recovery
Oracle dmp file is encrypted for recovery
asm disk group is damaged and cannot be mounted normally
Operating system level accidentally deleted data file recovery
The database cannot start normally because of undo damage / loss
The database does not work because some data blocks are damaged
The database cannot start normally because of ORA-600 error
The exp dmp file is damaged and cannot be imported into the database for recovery
The database cannot start normally because the control file is damaged / lost
The database cannot start properly because of redo corruption / loss
The database cannot be started normally because the data file is damaged / lost
Data files cannot be brought online due to database loss
Database error offline system file failed to start
Database due to operating system corruption, only data files are restored
The database cannot be started normally due to storage abnormalities
The expdp dmp file is damaged and cannot be imported into the database for recovery
Some asm disks are missing, causing asm disk group to fail to work properly
Database cannot resume due to incorrect resetlogs operation
The database cannot start normally due to power failure, abnormal shutdown, etc.
The following is a more typical ORACLE failure recovery
System rollback exception recovery
ORA-00604 ORA-00607 ORA-00600 [4194]
Thu Jul 26 13:21:11 2012 Recovery of Online Redo Log: Thread 1 Group 1 Seq 3994 Reading mem 0 Mem # 0: /orasvr/mispdata/redo01.log Block recovery completed at rba 3994.5.16, scn 0.89979533 Thu Jul 26 13:21:11 2012 Errors in file /orasvr/admin/mispdata/udump/mispdata_ora_2865.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [4194], [31], [2], [], [], [], [], [] Error 604 happened during db open, shutting down database USER: terminating instance due to error 604 Instance terminated by USER, pid = 2865 ORA-1092 signalled during: ALTER DATABASE OPEN ...
Undo segment exception recovery
ORA-00704 ORA-00604 ORA-01555
Fri May 4 21:04:21 2012 select ctime, mtime, stime from obj $ where obj # =: 1 Fri May 4 21:04:21 2012 Errors in file /oracle/admin/standdb/udump/perfdb_ora_1286288.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 40 with name "_SYSSMU40 $" too small Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Instance terminated by USER, pid = 1286288 ORA-1092 signalled during: alter database open resetlogs ...
Fri May 4 21:04:21 2012 select ctime, mtime, stime from obj $ where obj # =: 1 Fri May 4 21:04:21 2012 Errors in file /oracle/admin/standdb/udump/perfdb_ora_1286288.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 40 with name "_SYSSMU40 $" too small Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Instance terminated by USER, pid = 1286288 ORA-1092 signalled during: alter database open resetlogs ...
ORA-00704 ORA-00604 ORA-01173
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Feb 12 10:16:00 2014 SMON: enabling cache recovery Errors in file H: \ ORACLE \ diag \ rdbms \ orcl \ orcl \ trace \ orcl_ora_9232.trc: ORA-01173: data dictionary indicates missing data file from system tablespace Errors in file H: \ ORACLE \ diag \ rdbms \ orcl \ orcl \ trace \ orcl_ora_9232.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-01173: data dictionary indicates missing data file from system tablespace Errors in file H: \ ORACLE \ diag \ rdbms \ orcl \ orcl \ trace \ orcl_ora_9232.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-01173: data dictionary indicates missing data file from system tablespace Error 704 happened during db open, shutting down database USER (ospid: 9232): terminating the instance due to error 704 Instance terminated by USER, pid = 9232 ORA-1092 signalled during: alter database open resetlogs ...
obj $ transaction exception recovery
ORA-00704 ORA-00600 [4000]
Thu Feb 28 19:29:10 2013 SMON: enabling cache recovery Thu Feb 28 19:29:11 2013 Errors in file /u1/PROD/prodora/db/tech_st/10.2.0/admin/PROD_oracle/udump/prod_ora_20989.trc: ORA-00600: internal error code, arguments: [4000], [50], [], [], [], [], [], [] Thu Feb 28 19:29:13 2013 Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.3.0] Thu Feb 28 19:29:13 2013 Errors in file /u1/PROD/prodora/db/tech_st/10.2.0/admin/PROD_oracle/udump/prod_ora_20989.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [4000], [50], [], [], [], [], [], [] Thu Feb 28 19:29:13 2013 Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Instance terminated by USER, pid = 20989 ORA-1092 signalled during: ALTER DATABASE OPEN RESETLOGS ...
IO abnormal recovery
ORA-01115 ORA-01110 ORA-27070 OSD-04016
Tue May 14 15:32:10 2013 Completed redo scan 16941 redo blocks read, 1106 data blocks need recovery Tue May 14 15:32:17 2013 Errors in file d: \ oracle \ product \ 10.2.0 \ admin \ water \ bdump \ water_p002_1472.trc: ORA-01115: IO error reading block from file 6 (block # 81951) ORA-01110: data file 6: 'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ WATER \ YD_DATA01.DBF' ORA-27070: async read / write failed OSD-04016: An error occurred while queueing asynchronous I / O requests. O / S-Error: (OS 23) Data error (cyclic redundancy check).
Common error messages
Table or index bad block related errors
ORA-01578 / ORA-08103 / ORA-01410 / ORA-08102 / ORA-600 kdsgrp1 / ORA-600 qertbfetchbyrowid / ORA-01499 / ORA-01555 / ORA-26040 / ORA-27046
Control file exception
ORA-00202 / ORA-600 kccsbck_first / ORA-600 kccscf_1 / ORA-600 [kccsbck_first] / ORA-600 kccsbck_first / ORA-00205 / ORA-600 kccpb_sanity_check_2
REDO or UNDO is abnormal
ORA-00376 / ORA-00600 4097 / ORA-01595 / ORA-600 4194 / ORA-600 4193 / ORA-600 kcfrbd_3 / ORA-00600 4137 / ORA-01594 / ORA-01555 / ORA-00704 / ORA-00604 / ORA -00607 / ORA-600 4000 / ORA-00600 [3705] / ORA-00316 / ORA-00312 / ORA-00327 / ORA-01623 / ORA-01624 / ORA-01194 / ORA-600 2662 / ORA-00368 / ORA- 00353 / ORA-00305 / ORA-00340 / ORA-00345 / ORA-00354
Various ORA-600 errors
ORA-600 4497 / ORA-600 6947 / ORA-600 2662 / ORA-600 4194 / ORA-600 4193 / ORA-00600 4137 / ORA-600 4000 / ORA- 600 kcrf_resilver_log_1 / ORA- 600 kdxlin: psno out of range / ORA-600 3020 / ORA-600 kccpb_sanity_check_2 / ORA-600 3705 / ORA-600 kccscf_1 / ORA-600 kghstack_free2 / ORA-600 kcfrbd_3 / ORA-600 ktbdchk1: bad dscn / ORA-600 2252 / ORA-600 kcratr_odr_than_less_than_than_less_than_than_less 600 kccsbck_first / ORA-600 kcratr1_lostwrt / ORA-600 ktspNextL1: 4 / ORA-600 13013 / ORA-600 kdsgrp1 / ORA-600 kmgs_parameter_update_timeout_1 / ORA-600 kcbgtcr_1 / ORA-600 kcbgtcr_1a / ORA-600 k3 ORA-600 kcbgtcr_5 / ORA-600 kcbgtcr_6 / ORA-600 kcbgtcr_7 / ORA-600 kcbgtcr_10 / ORA-600 kcbgtcr_12 / ORA-600 kcbgtcr_13 / ORA-600 qertbfetchbyrowid / ORA-600 kmgsout_parameter_update
In order to quickly assess your library failure and recovery difficulty, please use Oracle Database Recovery Check Check the database, generate html, alert logs, and trace files to me (adb@xifenfei.com).
Main case of recent database backup without backup