Course: Oracle Database 12c: Advanced Administration (exam 1Z0-063) training

$0.00 incl. vat


duration: 17 hours |

Language: English (US) |

access duration: 180 days |


In this Oracle® Database training course you will learn to deal with the backup and recovery solutions in Oracle Database 12c. You will learn how Data Recovery Advisor is used, the functions of the Oracle Secure backup and how this can be integrated with RMAN backups. Finally you will learn how to u flashback technologies, transport data and performing PITR.

After completing this course you are prepared for the official Oracle Database 12c Advance Administration (exam 1Z0-063).

Among subjects that covered are RMAN, Archivelog, ASM disk groups, create proxy,ADRCI, Noarchivelog, OSB integration, flashback, TSPITR and far more.


After completing this course you are familiar with back-up and recovery solutions in Oracle Database 12c. You are also prepared for the Oracle Database 12c exam 1Z0-063.


We recommend basic knowledge of databases.

Target audience

Database Administrators


Oracle Database 12c: Advanced Administration (exam 1Z0-063)

17 hours

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

  • start the course
  • identify the features of Oracle Database 12c
  • identify recovery requirements
  • identify the different types of failures that can occur
  • describe backup and recovery solutions
  • describe the benefits of using Oracle Secure Backup and Oracle Data Guard
  • describe the different architecture types for the recovery solutions
  • identify the structures in the Oracle server architecture
  • identify the process used in an Oracle server architecture
  • identify the components of a Grid infrastructure for a stand-alone server
  • explore the Oracle Database environment in Linux
  • identify the different DBA tools that are used to manage a database
  • use RMAN to back up a database in NOARCHIVELOG mode
  • identify how to perform a restore of a database in NOARCHIVELOG mode
  • configure RMAN persistent settings
  • configure the retention policy using RMAN
  • describe the fast recovery area
  • configure the fast recovery area
  • size and manage the fast recovery area
  • multiplex control files for recoverability
  • multiplex redo log files for recoverability
  • configuring ARCHIVELOG mode and the archived redo log files for recoverability
  • describe the use of the RMAN recovery catalog
  • create the RMAN recovery catalog
  • register a database in the RMAN recovery catalog
  • register the recovery catalog to be used by Cloud Control
  • identify how the recovery catalog is resynchornized
  • use RMAN stored scripts
  • back up the RMAN recovery catalog
  • create and use virtual private RMAN catalogs
  • configure RMAN for recovery and create the Recovery Catalog

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

  • start the course
  • identify backup and restore requirements
  • describe backup strategies
  • identify the best practices to backup and recover a data warehouse
  • create backup sets and images
  • create a whole database backup
  • schedule backups in a given scenario
  • identify the different RMAN backup types
  • perform incremental backups
  • configure block change tracking
  • use an Oracle-suggested backup strategy
  • view information on backups
  • manage backups in a given scenario
  • create an incremental backup strategy using different levels of backups
  • describe backup compression
  • use media manager
  • back up very large database files using multisection backups
  • create proxy, duplexed, and backup sets
  • create archival backups
  • back up database files, including control files, ASM disk groups, and recovery files
  • identify the RMAN-encrypted backup modes
  • use transparent-mode encryption
  • use password-mode and dual-mode backup encryption
  • restore an encrypted backup
  • perform different types of backups using RMAN

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

  • start the course
  • explain the Automatic Diagnostic Repository and workflow
  • identify how to use ADRCI and the V$DIAG_INFO view for ADR information
  • describe how to interpret RMAN message output and error stacks
  • use Data Recovery Advisor in Enterprise Manager Cloud Control to diagnose and repair failures
  • use Data Recovery Advisor RMAN command line to diagnose and repair failures
  • use the Data Recovery Advisor views
  • repair a database failure
  • detect and handle block corruption
  • identify the parameters that can be set to detect block corruption
  • repair block corruption
  • perform block media recovery
  • identify the characteristics of automatic block repair
  • diagnose database failures and repair them
  • identify how to recover from a file loss or data failure
  • describe the restore and recover commands
  • describe the phases of instance recovery
  • tune the instance recovery process
  • describe complete and incomplete recovery
  • understand the restore and recovery concepts

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

  • start the course
  • identify the commands that can be used to verify backups are available
  • restore in NOARCHIVELOG mode
  • perform complete recovery
  • recover from the loss of a data file in ARCHIVELOG mode
  • restore ASM disk groups
  • recover image copies of a database
  • perform point-in-time recovery
  • perform incomplete recovery
  • recover from the loss of an spfile
  • recover from a control file failure
  • recovering from the loss of a control file and from all control files
  • recover from the loss of a redo log file
  • recover from the loss of a redo log group
  • recreate the password authentication file
  • recover index and read-only tablespaces
  • describe the procedure to restore a database to a new host
  • describe disaster recovery
  • restore an encrypted backup
  • perform recovery of a database in a given scenario
  • describe RMAN and OSB integration
  • install Oracle Secure Backup
  • configure OSB for RMAN
  • perform and manage tape backups
  • configure OSB and perform a backup to tape
  • install, configure, and use Oracle Secure Backup

Oracle Database 12c - Backup and Recovery: Using Flashback Technologies

  • start the course
  • describe the Flashback technologies available in an Oracle database
  • configure undo retention
  • use Flashback Query and Flashback Version Query
  • describe the Flashback Table feature
  • use Flashback Table to reverse a rogue transaction
  • describe the Flashback Transaction Query feature
  • use the Flashback Transaction Query feature
  • describe Flashback Drop and how the recycle bin works
  • flash back a dropped table
  • create temporal history and enable archiving
  • describe how Flashback Data Archive works
  • describe transparent and full schema evolution with Flashback Data Archive
  • use the period for clause to use temporal validity and history in a table
  • filter on valid-time columns
  • describe the Flashback Database
  • configure the Flashback Database feature
  • flash back a database
  • describe the considerations for using Flashback Database
  • monitor Flashback Database information
  • create a restore point to use with Flashback Database
  • describe the best practices for using Flashback Database
  • use the different Flashback Technologies in a given scenario

Oracle Database 12c - Backup and Recovery: Transporting Data and Performing PITR

  • start the course
  • describe how data can be transported
  • determine the endian format of a platform and the use of the RMAN convert command
  • describe the steps to transport data with backup sets and data files
  • describe the procedure used to transport a database
  • perform database transportation
  • perform database transportation using backup sets
  • perform tablespace transportation
  • transport data, databases, and tablespaces in a given scenario
  • identify when Tablespace Point-in-Time Recovery can be used
  • identify the Tablespace Point-in-Time Recovery architecture
  • prepare for Point-in-Time Recovery
  • perform fully automated Tablespace Point-in-Time Recovery
  • perform TSPITR using an RMAN-Managed Auxiliary instance and your own auxiliary instance
  • troubleshoot RMAN Tablespace Point-in-Time Recovery
  • describe table recovery
  • identify the steps to perform table recovery
  • recover a table from a backup using RMAN
  • perform TSPITR and table recovery in a given scenario

Oracle Database 12c - Backup and Recovery: Duplicating Databases and Tuning RMAN

  • start the course
  • identify the difference techniques that can be used to duplicate a database
  • identify the difference between the push and pull methods for duplicating a database
  • identify the techniques for duplicating a database from backup
  • identify how to create a parameter file for the auxiliary instance
  • identify how to use the SET NEWNAME clause
  • identify how to start the auxiliary database and allocate auxiliary channels
  • identify the steps performed by RMAN when the duplicate command is executed
  • identify the different options that can be used with the duplicate command
  • perform the steps to duplicate a database
  • duplicate a database
  • interpret RMAN messages and error stacks
  • understand how RMAN commands are processed
  • identify if there is a problem with RMAN performance
  • diagnose performance bottleneck read operations
  • diagnose performance bottleneck write operations
  • use dynamic views to determine if there is a performance issue
  • diagnose asynchronous and synchronous I/O bottlenecks
  • identify the steps to tune backup performance
  • configure parallelization of backup sets
  • set the large_pool_size parameter
  • configure RMAN multiplexing
  • identify the best practices for restore and recovery performance
  • troubleshoot and tune RMAN

Course options

We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.

Optional practice exam (trial exam)

To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam. 

Optional practice lab

To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediatelyThe lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience. 


Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten


Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.

read more about the order process

What is included?

Certificate of participation Yes
Monitor Progress Yes
Award Winning E-learning Yes
Mobile ready Yes
Sharing knowledge Unlimited access to our IT professionals community
Study advice Our consultants are here for you to advice about your study career and options
Study materials Certified teachers with in depth knowledge about the subject.
Service World's best service


Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

Life Long Learning

Follow multiple courses? Read more about our Life Long Learning concept

read more

Contact us

Need training advise? Contact us!