The “Dumper”, as we affectionately call it, runs once a day and generates a ZIP file that contains:
This automation tool is a pretty central piece to solving this problem, because EXPDP dump files can be restored very easily. In our case, it took IT a few days to get that backup sorted so that we could restore the data that was deleted.Īfter this first "oops" incident, we proposed that the client use a tool we developed that automates the extraction of EXPDP dump files from an Oracle database so we always have them available, and do not need to wait to get a backup restored by IT. However, dealing with RMAN backups can be tricky, and can take your IT team awhile- several hours or days to get it restored. The first time a major "oops" deletion happened with this client we were using Oracle Enterprise Edition 11g with Primavera P6 and a sensible RMAN backup solution. Of course manually recreating these resources and resource assignments could have been an option.NO WAY! It would have taken days of work to redo and it would have been near impossible to get right, error prone, extremely expensive and likely result in several people quitting. Believe it or not it was a few days after it happened, so simply reverting the whole database was no longer an option. Recently, we ran into a customer that had deleted more than 400 resources and 15,000 resource assignments. Oracle DBA, SQL Server DBA, APPS DBA, Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için a mail atabilirsiniz.What to do When That "Oops" Moment Happens? clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA, Exadata, Goldengate, EBS Consultancy and Training you can send my email adress. I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc.