Imate žicu za učenje?

Oracle Database 12c – Administration: The Network Environment and User Security

Overview/Description The Oracle network environment requires correct configuring to allow database connections  from clients. If the listener and connections are not configure correctly access can be blocked. Also to access the database, a user must specify a valid database user account and successfully authenticate as required by that user account. What the user can execute once they are logged in is controlled by privileges granted to them, which can be system or object. Privileges can be better controlled by using roles and profiles, which control resource consumption and account...

Oracle Database 12c – Administration: Storage structures and Undo Data

Overview/Description An Oracle database is divided into logical storage units called tablespaces. Oracle also provides Oracle-Managed Files (OMF), which eliminate the need for the DBA to directly manage the operating system files in the Oracle database. Managing undo data is also important DBA role. Data is manipulated using DML, and undo data exists as a copy of the original, premodified data and is captured for every transaction that changes data. This course describes the purpose and functions of tablespaces, including how to manage segments and resumable space allocation. This course...

Oracle Database 12c – Administration: Data Concurrency and Auditing

Overview/Description Oracle Database 12c is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented automatically, which can sometimes cause lock conflicts. This course discusses the locking mechanism in Oracle and how to resolve lock conflicts and deadlocks. It also discusses how to implement database auditing. This course is one of a series in two SkillSoft learning paths that covers the objectives for the 1Z0-062 Oracle Database 12c: Installation and Administration. This exam...

Oracle Database 12c – Administration: Backup, Recover, and Move Data

Overview/Description Preparing for and performing data recovery and completing database backups are the responsibilities of a DBA. This ensures that the database is available for users when they require it. DBAs also need to ensure that if a failure does occur, the loss of data is minimized and they can recover the database in an efficient manner. Oracle DBAs also need to understand the various internal consistency checks a database performs as it moves from the shutdown stage to being fully open. Equally important is an understanding of what can cause a failure, and how to recover from an...

Oracle Database 12c – Administration: Maintenance and Performance Tuning

Overview/Description General database maintenance and performance monitoring are important Oracle DBA tasks. Proactive and reactive database maintenance is made easy by the sophisticated infrastructure of Oracle Database 12c, including elements such as Automatic Workload Repository (AWR), ADDM, ASMM, and database alerts. DBAs must make sure that databases are open and available to users when they need it and that it is working without bottlenecks by gathering performance metrics. This course discusses how to use Enterprise Manager Cloud Control to monitor performance, and how to use AMM,...

Oracle Database 12c – Administration: Resource Manager, Scheduler, and Support

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. DBAs are also required to ensure that the database is up-to-date with the latest patches and that critical errors are resolved, which includes contacting Oracle for support. This...

Oracle Database 12c - Backup and Recovery: Configuring for Recoverability

Overview/Description Oracle Database 12c offers different features to enable a full recovery of the database in case of a failure. Depending on the Oracle system that is running, different solutions can be used. This course discusses the backup and recovery solutions available in Oracle Database 12c as well as the Oracle Database Server architecture. It will also explain and demonstrate how to configure Recovery Manager, RMAN, and how to create a recovery catalog for managing database backup, restore, and recovery processes. This course is one of a series in the Skillsoft learning path that...

Oracle Database 12c - Backup and Recovery: Performing and Managing Backups

Overview/Description Oracle Database 12c allows backups to be performed and managed using Recovery Manager, RMAN. Multiple different backup strategies can be used that are a combination of different types of backups, including incremental, full, block media recovery, and encrypted backups. This course will discuss and demonstrate how to identify backup requirements and strategies as well as how to perform and manage backups. This course is one of a series in the Skillsoft learning path that helps prepare the learner for the Backup and Recovery portion of the Oracle exam 1Z0-063, Oracle...

Oracle Database 12c - Backup and Recovery: Failure and Recovery Concepts

Overview/Description Numerous issues, such as media failures, user errors, and application errors, can cause an Oracle 12c database to become partially or fully inoperable. Because of this, data protection is the main purpose of a backup and recovery strategy. Oracle Database 12c offers RMAN data repair techniques that can be incorporated into backup and recovery strategies to respond to data loss. One of these is the Data Recovery Advisor, which can diagnose, advise, and repair some failures automatically. RMAN also offers block media recovery, point-in-time recovery as well as complete and...

Oracle Database 12c - Backup and Recovery: Perform Recovery and Secure Backup

Overview/Description When a failure occurs within an Oracle 12c database, a restore or recovery operation needs to take place. Using RMAN restore operations database, you can restore tablespaces, control files, redo log, and the server parameter file if they are corrupted or lost within the database. This course will discuss and show how to perform the different types of restore operations, including when the database is in ARCHIVELOG or NOARCHIVELOG mode. It will also show how to recover from the loss of control files and password files, redo log files, as well as how to restore a database...

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ć?