Imate žicu za učenje?

Overview/Description An important aspect of Oracle Database administration is to understand how a database and its major components function. Also as an Oracle Database administrator, you need to be able to recover when problems occur in the database. This is accomplished using backups, which are used to protect against problems such as media failure, user errors, and application errors. This course reviews the major architectural components of the Oracle Database 11g architecture, such as memory structures, background processes, and the logical and physical storage structures. This course...
Overview/Description Administering an Oracle database requires monitoring and diagnosing data failures and recovering from them. Oracle Database 11g Release 2 provides the Data Recovery Advisor which eases this task by automatically detecting errors when they occur and providing repair advice. The use of the Automatic Diagnostic Repository can also be used, which holds diagnostic information about critical error events. Flashback technology can be used when a logical corruption occurs in the Oracle database and you need to recover data quickly and easily. With the use of a Flashback Table,...
Overview/Description Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which includes the hardware and software infrastructure needed to meet your requirements. This course explores the database's memory structures, focusing on how to configure SGA parameters and how to implement Automatic Memory Management and Automatic Shared...
Overview/Description By using the Database Resource Manager, you have more control over the allocation of machine resources than is normally possible through operating system resource management alone. Many tasks in the Oracle environment need job-scheduling capabilities. Using advanced Scheduler features, you can exercise more control over various aspects of scheduling, such as job windows and prioritizing jobs. This course explains how to configure the Database Resource Manager to access and create resource plans, create, configure, and administer consumer groups, as well as activate a...
Overview/Description To effectively manage space, you can configure automatic management by the Oracle database server. This allows you to generate alerts about potential problems and recommend possible solutions. This course explores how to use the Oracle database server for automatic space management, proactively monitor and manage tablespace space usage, and reclaim wasted space from tables and indexes by using the segment shrink functionality. Using the segment advisor, resumable space allocation, and moving tablespaces are also covered. This course will also explore how to duplicate a...
Overview/Description As a database administrator it is very important to understand how to restore and recover your database in the event of a loss of a file due to media, hardware, or user error. The restoration process involves moving a backup into place to be used by the database when a file is damaged. The recovery process involves applying redo to bring the file forward in time to before the failure or up to the failure point. This course discusses the type of failures that can occur and how to recover from them. It also discusses how to perform user-managed backup and recoveries. This...
Overview/Description RMAN uses a recovery catalog to store metadata about Oracle databases, and allows stored scripts to be used to run sequences of RMAN commands stored in the catalog. When administering an Oracle Database, it is important to be familiar with what a backup is, how the process of creating a backup is completed, and the various types of backups available. This knowledge allows you to make an informed decision on the best way to maintain the integrity of your data and the availability of your database. This course discusses how to create and manage the recovery catalog. It also...
Overview/Description Reconstructing the contents of all or part of a database from a backup typically involves two phases. The first phase is the retrieval of a copy of the data file from the backups. The second involves reapplying changes to the file that occurred since the backup, using archived and online redo logs. To effectively administer an Oracle Database 11g database, recovery should be performed when critical or non-critical files are lost. Once you configure RMAN to perform recovery operations, it is important to have measures in place to monitor RMAN jobs. This course explains how...

Koraci do učenja

1Prijavi se

Prijavite se, a ako nemate korisničko ime, registrirajte se.

2Pronađi i upiši program

Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.

3Uči

Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.

»Detaljne upute

Trebate pomoć?

Trenutno nema programa koji imaju objavljene termine.