Course: Oracle Database 12c: Advanced Administration (exam 1Z0-063)
As low as
Details
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.
Result
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.
Prerequisites
We recommend basic knowledge of databases.
Target audience
Database Administrators
Content
Oracle Database 12c: Advanced Administration (exam 1Z0-063)
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 immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.
Sign In
WHY_ICTTRAININGEN
Betaal in termijnen
| Cursusnaam | |
| Looptijd | |
| Rentebedrag financiering | |
| Totaal bedrag | |
| Maandbedrag |
Gespreid betalen met Spraypay
Met de betaaloptie SprayPay kun je jouw bestelling van € 250,- tot € 3.500,- veilig en gespreid betalen in gelijke termijnen van 12, 18, 24 of 36 maanden. Je hebt op die manier een minimale financiële belasting en je kunt eenvoudig de termijnbetalingen opnemen in jouw vaste lasten.
Hoe werkt het kopen op afbetaling? De beoordeling van de kredietaanvraag vindt online plaats. Binnen enkele seconden weet je of je in aanmerking komt voor een krediet. Is de aanvraag akkoord dan kun je meteen genieten van je aankoop.
Let op: deze betaalmetode is aleen beschikbaar voor particulieren! Bekijk voor je aankoop ook de SprayPay voorwaarden.
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 Icttrainingen.nl
Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers
Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten
Orderproces
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
Een zakelijk account aanmaken
Wanneer u besteld namens uw bedrijf doet u er goed aan om aan zakelijk account bij ons aan te maken. Tijdens het registratieproces kunt u hiervoor kiezen. U heeft vervolgens de mogelijkheden om de bedrijfsgegevens in te voeren, een referentie en een afwijkend factuuradres toe te voegen.
Betaalmogelijkheden
U heeft bij ons diverse betaalmogelijkheden. Bij alle betaalopties ontvangt u sowieso een factuur na de bestelling. Gaat uw werkgever betalen, dan kiest u voor betaling per factuur.
Cursisten aanmaken
Als u een zakelijk account heeft aangemaakt dan heeft u de optie om cursisten/medewerkers aan te maken onder uw account. Als u dus meerdere trainingen koopt, kunt u cursisten aanmaken en deze vervolgens uitdelen aan uw collega’s. De cursisten krijgen een e-mail met inloggegevens wanneer zij worden aangemaakt en wanneer zij een training hebben gekregen.
Voortgangsinformatie
Met een zakelijk account bent u automatisch beheerder van uw organisatie en kunt u naast cursisten ook managers aanmaken. Beheerders en managers kunnen tevens voortgang inzien van alle cursisten binnen uw organisatie.
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 |
Platform
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.
FAQ
Niet gevonden wat je zocht? Bekijk alle vragen of neem contact op.