Oracle RAC environments should first be created for testing and proving concepts for how the failover works for different applications. The RAC test environments should continue to be available for testing for production systems because different workloads and failover can’t be tested against a single node. After the installs of the Oracle Clusterware and database […]
Read More
Oracle Real Application Clusters (RAC) provides a database environment that is highly available as well as scalable. If a server in the cluster fails, the database instance will continue to run on the remaining servers or nodes in the cluster. With Oracle Clusterware, implementing a new cluster node is made simple. RAC provides possibilities for […]
Read More
What does high availability mean to the business? What is the level of risk tolerance? How much data loss is acceptable? Are there current issues with backups or reporting? These are all questions that need to be asked to start mapping out the components that are needed. You may decide that absolutely no data loss […]
Read More
Let’s have a look at a few scripts that will take advantage of Oracle RMAN. Backup Script The following script groups together RMAN commands in a RUN block to take a full backup of a database and its archivelogs. It assumes that you have configured the control file autobackup on in the RMAN configuration settings, and […]
Read More
Backups are very important, but they have a shelf life, too. You cannot just keep taking backups and retain all of them forever. You need to decide how long you would like to retain your backups before you can safely remove them in order to make space for more backups. Storage on a disk or […]
Read More
When you create backups with RMAN, they get created in one or more backupsets; these backupsets are in proprietary format. In order to use them again for recovery, first you need to extract them from this proprietary format. This process is called restore. You use the RESTORE command of RMAN to restore the backup. For […]
Read More
The data in the databases always grows, and as the backup is a copy of the data, it grows too. As the size of the backup grows, it takes more space on the disk and it takes more time to back up. When the database becomes large, you still want to back it up faster […]
Read More
SQL Server Resource Governor concepts have been in existence since the SQL Server 2008 versions. With every version, there have been new additions, and it has steadily gotten better and better. It started with CPU throttling and memory throttling; now, with SQL Server 2014, they introduced IO throttling. There are three important concepts related to Resource Governor: Resource […]
Read More
It is critical to know when to use the various types of code instrumentation features, where to place them, and, most importantly, what you are trying to achieve by instrumenting your code. Achievable goals usually target two groups of problems: Inefficient debugging Poor understanding of resource utilization The majority of existing IT system professionals spend […]
Read More
Knowing how to select appropriately between SQL-based and PL/SQL-based solutions is one of the most important skills in Oracle database development. Let’s look at two less common examples of using PL/SQL in actual systems development. The first example illustrates the notion of performance tuning by going outside of the regular solution patterns, while the second […]
Read More
Once you get started with RMAN and become familiar with its three main concepts and the tasks it can perform, you are ready to move onto more advanced concepts. The three concepts are: Backup Making another copy of data in an organized format on disk or tape Restore Getting that copy of data back into a location […]
Read More
Recovery Manager (RMAN) is the tool for backup and recovery of Oracle databases. RMAN is client software that connects to a target database and performs backups or recovery on it. RMAN always stores data about itself and its operations in the database control files as well as a special schema in another database. The best […]
Read More