Author: mac

Oracle Database – Enterprise Edition – Version 8.1.7.4 to 12.1.0.2 [Release 8.1.7 to 12.1] Information in this document applies to any platform. ***Checked for relevance on 16-July-2015*** GOAL How to recover and open the database if the archivelog required for recovery is either missing, lost or corrupted? SOLUTION The assumption here is that we have…

SYMPTOMS Symptom 1 :- Database was Shutdown Clean using Shutdown Immediate. Attempt to do a COLD backup via RMAN in mount stage fails: RMAN-03009: failure of backup command on c1 channel at 06/15/2006 22:21:45 ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode The failure occurs despite the fact that the database has been previously shutdown…

——– CRS 10.2.0.3 ASM 10.2.0.3 RDBMS 10.2.0.2 I have a customer  has 2 nodes cluster and ASM doesn’t mount the diskgroup   Alert.log ASM1 ————– Thu Feb 7 21:52:31 2008 NOTE: starting recovery of thread=1 ckpt=56.6552 group=1 ORA-15196: invalid ASM block header [kfr.c:6086] [endian_kfbh] [3] [6558] [0 != 1] NOTE: cache initiating offline of disk 0…

I have a customer run dd command on one of his ASM disk. As no database backup exists, customer would need help to extract data from diskgroup. He tried: amdu -diskstring ‘/dev/oracleasm/disks/*’ -ausize 1048576 -blksize 4096 -baddisks DGDATA01 -extract ‘DGDATA01.xxxx’ but he got: ************************ EXTRACTING FILE DGDATA01.404 ************************ AMDU-00208: File directory block not found. Cannot extract…

Symptoms Database cannot be opened, because a datafile checkpoint is lagging behind from the rest of the datafiles. Cause A datafile was restored from a previous backup, but archivelogs required to recover the said datafile are missing. Solution There are 3 options available, as shown below:   Option#1: Restore the database from the same backupset,…

If you cannot recover the data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help. Parnassusdata Software Database Recovery Team   Service Hotline:  +86 13764045638 E-mail: [email protected]   DUL Introduction Developed by Bernard Van Duijnen Is a stand-alone disaster recovery utility, and requires no other Oracle software to run Unloads data from data…

If you cannot recover the data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help. Parnassusdata Software Database Recovery Team Service Hotline:  +86 13764045638 E-mail: [email protected] ORACLE PRM-DUL Download: http://zcdn.parnassusdata.com/DUL5108.zip DUL Allows recovery of data from raw datafiles Download DataUnLoader_Toolkit.zip Download DataUnLoader_Labs.zip Download executable for your desired platform Best Practice: If going on-site, download…

Sometimes our customer’s DB is crash via some reason or working as a DBA. I know Oracle dul very well, but I’m not Oracle Korea’s employee or engineer. So I cann’t get Oracle dul binary anytime if I want.   There was a critical problem (system.dbf crash, no backup, no metadata) at monday(25, May) one…

I have a customer who’s database has been corrupted and need support from experts.Pls find below the bullet points below. Can we use golden gate in the below case.Pls advise   At this time, Support is unable to offer a solution, the only alternative is to extract the data from the database and migrate it into a fresh…

We have a customer who is trying all means to get 1 very critical table (data) from a incomplete export data pump. Below is the scenario EXPDP after exporting 56 tables had failed due to space crunch issues. The log file master table was not unloaded cleanly Now while importing 1 table , it fails with…