Have you lost or deleted a control file from an Oracle database? We’re here to help! Follow the steps below to recreate the control file. 1. If you try to take the backup of control file using the below command, when the control files are deleted you will get the following error. Instead, get the […]
One of the biggest selling points of Oracle’s engineered system Exadata is its storage offloading capability. Storage offloading allows data to be instantly filtered when it is read from storage, reducing the amount of data that is sent and processed by the database. One of the filter operations storage offloading performs is join filtering via […]
Now that you have a good design (see posts on documentation and data model), it is time to focus on the performance of the data warehouse from both the loading of the data warehouse from the source systems via ETL to the running of the reports and presentation of analytics to the end user. Below is a checklist […]
In our last post here we talked about documentation best practices for data warehousing. In this post we’re going to focus on data modeling and the key information that you need to know. Data ModelThe data model is where all of the action takes place. Now that your documentation and naming conventions are defined and you have formally established […]
One of the most frequently asked questions when starting a Data Warehousing initiative is: “What best practices should I be following?” In this series of posts, we will outline our recommendations to follow when building a data warehouse – starting with data warehousing documentation. Technical Documentation Image Data Warehousing Best Practice: Documentation A successful data warehouse implementation […]
Background: Database Administration ChallengesManaging Oracle database backup and recovery is a critical operational requirement for database administrators (DBAs). With increasing database sizes and Service Level Agreements (some requiring 24×7-database availability), DBAs need to effectively design and manage data protection solutions to minimize performance impact on production databases. Below are key operational goals that DBAs need […]
In our last post we discussed the top myths and benefits associated with Oracle RMAN. Now that you’re ready for (or already have reached) implementation, we’d like to share some best practices to follow. 1. Take regular backups and verify that they work. Use validate command of Oracle RMAN or restore them to a test environment periodically:RMAN> […]
One of the benefits of making the very substantial financial investment in the Oracle Exadata Database Machine is the retinue of service packages that come included, free of charge, with the purchase. These services include significantly quicker response times than standard Oracle Premier Support, 24/7 remote fault monitoring, and, of course, the main focus of […]
In our last post, “What are Data Warehouses?”, we talked about what a data warehouse is, some of the history behind it, and when your organization may need a data warehouse solution. Now we will going to explain the top three requirements for creating a data warehouse solution. #1. Executive Sponsorship Without buy-in from senior executives, data warehouse projects […]
A data warehouse is a large, central store of data from sources across an organization or company. The information contained in this central data store is used for making strategic and tactical business decisions. Building a Data Warehouse When it comes to building a data warehouse for your organization, the most commonly utilized methodologies are […]