The student begins by gaining a much deeper understanding of possibly the most important job of a dba backup and recovery. Back and recover a database and its parts with rman commandline and enterprise manager use flashback technology to view past states of data and to revert either objects or the entire database back to a past state. Oracle dbas manage the industries most advanced information systems and command some of the highest salaries. Oracle database 11g administration workshop i vol i. Administration workshop ii online course is designed in a way that it helps the candidates to understand the procedure to perform the managing the space so that database storage can be optimized so that they can respond to growing space requirements. This tutorial will teach you the how to use the data dictionary to answer the questions every dba is faced with on a daily. Additional training is provided in the following courses. This includes how to define and test your own backup and recovery scen.
Administration workshop ii this handson module provides you with comprehensive information and handson experiences on rman backup and recovery, disaster. Understand the oracle database architecture and how its components work and interact with one another. By using our website you agree to our use of cookies. Oracle database 11g administration workshop ii release 2. Learn about architecture and how the database components work and interact. Using rman to create backups objectives create image file backups create a whole database backup enable fast incremental backup create duplex backup and back up backup sets create an archival backup for longterm retention. Oracle database 11g administration workshop i vol 1pdfppt.
Administration workshop i release 2 suggested prerequisites working knowledge of sql and how to use plsql packages course objectives configure the oracle database for optimal recovery configure the database instance such that resources are appropriately allocated among sessions. Mar 12, 20 every oracle database administrator must know the oracle data dictionary. This course takes the database administrator beyond the basic tasks covered in the first workshop. Youll start by picking up a profound comprehension of the most vital obligations a dba has performing backup and recovery. The student begins by gaining a much deeper understanding of possibly the most im oracle database 11g. Oracle database 11g delivers economies of scale on easily managed lowcost grids, making it easier to reduce cost of downtime with maximum availability architecture, change it systems faster using real application testing, partition and compress data to run queries faster using less disks, securely protect and audit data, and enable total recall of data, and make productive use of standby. The student begins by gaining a much deeper understanding of possibly the most important job of a dba.
Administration workshop ii release 2 this course takes the database administrator beyond the basic tasks covered in the first workshop. Oracle database 11g administration workshop ii, oracle. Administration workshop ii release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. Administration workshop ii home \ corsi in this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out. Master your understanding of oracle database 11g with this course that teaches you to configure for recovery and backup and diagnose and repair data failures. Administration workshop the oca or ocp certification version you hold determines the new features courses recommended to catchup. Administration workshop ii certification facilitates indepth understanding of the responsibilities that a dba has to perform. Oracle database 11g delivers economies of scale on easily managed lowcost grids, making it easier to reduce cost of downtime with maximum availability architecture, change it systems faster using real. Administration workshop ii release 2 training takes the database administrator past the essential errands shrouded in the principal. Administration workshop i release 2, this database 11g administration training gives you a firm foundation in basic database administration, including how to install and maintain an. This tutorial will teach you the how to use the data dictionary to answer the questions every dba is faced with on a. Objective dbas will learn the main skills required in their jobs, including monitoring, tuning.
Oracle database 11g database administration oracle database 11g. Oracle database 11g administration workshop i vol 2pdfppt. Objective dbas will learn the main skills required in their jobs, including monitoring, tuning and securing oracle instances, advanced backup and recovery, high availability ha, simple real application clustering rac environment set up. This course is designed to prepare you for the corresponding oracle certified professional exam. Youll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. Administration workshop ii home \ corsi in this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. Manage major database components like memory, performance and resources using oracle database 11g. Oracle database 11g administration workshop lesson 1 intro. Administration workshop ii release 2, this database 11g administration training teaches you to perform backup and recovery, and. This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an.
Administration workshop i 10 5 undo data continued in case of a failed transaction, the safest behavior is chosen, and the oracle database reverses all changes made by a user, thereby restoring the original data. Back and recover a database and its parts with rman commandline and enterprise manager use flashback technology to view past states of data and to revert either objects or the entire database. New features for administrators coming soon oracle database administration ii 1z0083 i have passed 053, 063, or 073 but not 052. Youll begin by gaining a much deeper understanding of. Every oracle database administrator must know the oracle data dictionary. Youll develop appropriate strategies for backup, restore and recovery procedures from. Administration workshop i 10 5 undo data continued in case of a failed transaction, the safest behavior is chosen, and the oracle database reverses all changes made by a. Oracle database 11g administration workshop i vol ii. This course advances your success as an oracle professional in the area of database administration. In this 3 day course delegates will learn about rac database administration in the oracle grid infrastructure environment. Expert instructors will reinforce topics with structured handson.
Learn oracle database 11g administration workshop ii course from certified oracle trainers at gicseh to give your career a kick start. New features for administrators if you choose to not take any of the other recommended trainings. Undo information is retained for all transactions, at least until the transaction is ended by. The ultimate dba guide to getting current with oracle database. Administration workshop ii this handson module provides you with comprehensive information and handson experiences on rman backup and recovery, disaster recovery, and performance tuning. Administration workshop i release 2 suggested prerequisites working knowledge of sql and how to use plsql packages course. Understand the oracle database architecture and how its components work and interact. Administration workshop i release 2 course explores the fundamentals of basic database administration. Administration workshop ii release 2 training takes the database administrator past the essential errands shrouded in the principal workshop. Administration workshop i dba release 2 course objectives back and recover a database and its parts with rman commandline and enterprise manager use flashback.
Oracle 11g administration workshop ii certification training. Administration workshop ii will teach you how to evaluate your own recovery requirements. Using rman to create backups objectives create image file backups create a whole database backup enable fast incremental backup. This class provides preparation for the ocp oracle database 11g. Oracle database 11g administration workshop i and ii oratc. Administration workshop i release 2, this database 11g administration training gives you a firm foundation in basic database administration, including how to install and maintain an oracle database. The student begins by gaining a much deeper understanding. New features for administrators coming soon oracle database administration ii 1z0083 i have passed 053, 063, or 073 but not 052, 062, or 072 recommended for 1z0082 oracle database. Using oracle recovery manger rman to perform backups cold and hot and database recoveries complete and point in time pitr are a primary focuses of the class. Youll begin by gaining a deep understanding of the most important responsibilities a dba has. This course advances your success as an oracle professional in the area of database. Enroll now to learn oracle database 11g administration workshop ii. Administration workshop ii release 2, this database 11g administration training teaches you to perform backup and recovery, and diagnose and repair data failures. In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail.
468 75 93 1461 862 1021 1129 468 820 216 746 138 1337 822 236 1242 510 1004 776 6 399 1282 29 678 1121 1362 1307 760 394 1369 89 821 1291 294 501 55 1561 386 791 1151 593 1368 474 1110 764 409 216 1496 568