Dell‘s IT has several Oracle production environments that support its manufacturing, financials, sales and support, HR and internal applications. Needless to say, each of these applications has different needs and requirements. For example, manufacturing applications need to be high-performing and are highly transactional, while sales and support applications need to be always available.
On top of that, the company makes use of different Oracle Database versions. It has 1,168 instances on Oracle Database 10g, 333 instances on Oracle Database 9i and 57 instances on versions 8i or earlier.
Further, Dell keeps track of 7,805 monitored targets, 307 clustered databases, more than 1,200 database instances, 1,510 hosts and 778 ASM targets.
Dell has to face all of these complexities on a day-to-day basis. Good thing it uses Oracle Data Recovery Advisor.
Dell uses the Oracle Data Recovery Advisor
Data Recovery Advisor sniffs out known failures such as missing files, corrupted blocks and other physical issues. It also gives them recommendations and advice on how to correct these failures, even generating a repair script automatically, when possible. You can even ask it to execute the repair script. Lastly, it allows you to revalidate the failures it detects.
Because you get warned of the failures, even before a process detects it, you can limit the damage that the corruption can cause.
What’s more, Data Recovery Advisor can effectively detect multiple failures and automatically repairs your system without having Dell’s IT professionals manually figuring out what the right sequence is in repairing the different failures.
Dell uses the Flashback Transaction
Another feature that Dell IT relies on is the Flashback Transaction. Flashback Transaction enables Dell IT to view the changes made to a database on the transaction level so that they could diagnose problems in their databases, as well have conduct audits and analysis of their transactions. It also backs out transactions in the reverse order they were entered. Plus, Dell IT could save the transaction data for reference in the future.
Dell uses the Recovery Manager Network-Enabled Database Duplication
Dell IT is also using the Recovery Manager Network-Enabled Database Duplication. Dell has around 40 clone requests in a single week and spends more than 120 hours per month just duplicating resources. They also have to clone up to 100 gigabytes of data in 6 to 10 hours. In order to do all these, Dell needs a backup solution without having to use tape backup. Recovery Manager’s Network-Enabled Database Duplication allows Dell to clone their production databases without having to use pre-existing backups. This enables them to have a faster turn-around time and savings in resources, costs and storage. What’s more, Dell can embed cloning into scripts.
Follow Dell’s example and use Oracle Database to its full potential. Four Cornerstone can help!
If you are using Oracle Database, then it is the right time to check if you are using all of its features. Oracle Database has a lot of features that some may not be aware of. To be sure, call Four Cornerstone. With Four Cornerstone, you will be working with Oracle experts who can help you maximize your software investments. This way, you can use your Oracle Database to solve your database-related problems without having to pay extra.
Source: Oracle.
