Description: Oracle Database 12c allows for the duplication of a database. This can be useful for numerous reasons, including for implementing a testing environment or for doing recovery operations. To duplicate a database there are various steps you need to complete to first prepare the environment when the database will be duplicated to and then the RMAN DUPLICATE command can be used. As with any tool or feature that using resources RMAN can have performance issues. These issues need to be identified and then corrected based on performance issues that was detected. Oracle Database 12c provides tools and features to do this task. This course will discuss and show how to duplicate a database as well as how to troubleshoot and tune RMAN. 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 Database 12c: Advanced Administration.
Target Audience: Database administrators, support engineers, technical administrators, and data warehouse administrators who wish to develop appropriate strategies for backup, restore, and recovery procedures
Duration: 01:43
Description: Using Data Transport, a feature in Oracle Database 12c, tablespace can be transported to other databases on the same or different platforms. It also enables the transportation of full databases. Another feature of Oracle Database 12c is Point-in-Time Recovery. This enables the recovery of one or more objects, for example tablespaces, to an earlier time without affecting other objects within the database. Point-in-Time Recovery can be performed at three levels: Tablespace, Table, and Database. This course will discuss and demonstrate how to perform data transportation and Point-in-Time Recovery. 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 Database 12c: Advanced Administration.
Target Audience: Database administrators, support engineers, technical administrators, and data warehouse administrators who wish to develop appropriate strategies for backup, restore, and recovery procedures
Duration: 01:28
Description: Oracle Database 12c provides the Flashback technologies to enable databases, tables, and transactions to be flashed back. This allows users to view data from the past and apply that data to the database, if necessary. Oracle offers Flashback Database, Flashback Table, Flashback Query, and Flashback Transaction Query. Flashback Drop can be used to reinstate a dropped table from the recycle bin. This course describes and shows how to use these Flashback technologies. 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 Database 12c: Advanced Administration.
Target Audience: Database administrators, support engineers, technical administrators, and data warehouse administrators who wish to develop appropriate strategies for backup, restore, and recovery procedures
Duration: 01:47
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 to a new host and perform disaster recovery. This course will also describe what Oracle Secure Backup is and how it can be integrated with RMAN to perform backups and restores. 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 Database 12c: Advanced Administration.
Target Audience: Database administrators, support engineers, technical administrators, and data warehouse administrators who wish to develop appropriate strategies for backup, restore, and recovery procedures
Duration: 02:07
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 incomplete recovery. This course will discuss how Data Recovery Advisor is used, how block corruption is handled, and the concepts regarding how various restores and recoveries are performed. 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 Database 12c: Advanced Administration.
Target Audience: Database administrators, support engineers, technical administrators, and data warehouse administrators who wish to develop appropriate strategies for backup, restore, and recovery procedures
Duration: 01:21
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 Database 12c: Advanced Administration.
Target Audience: Database administrators, support engineers, technical administrators, and data warehouse administrators who wish to develop appropriate strategies for backup, restore, and recovery procedures
Duration: 01:56
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 helps prepare the learner for the Backup and Recovery portion of the Oracle exam 1Z0-063, Oracle Database 12c: Advanced Administration.
Target Audience: Database administrators, support engineers, technical administrators, and data warehouse administrators who wish to develop appropriate strategies for backup, restore, and recovery procedures
Duration: 02:29