ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

OCP - Oracle Database 10g Administration Workshop II - RWC

Format: Formation individualisée en ligne
Autres formats:
 
 

In this course, you'll learn how to configure an Oracle database for multilingual applications. You will learn various methods of recovering the database using RMAN and Flashback technology. Database performance monitoring tools will be covered, in addition to the steps to take to resolve common problems and improve performance. You will also learn how to administer a database efficiently by using database technologies such as the Resource Manager, the Scheduler, Automatic Storage Management (ASM), and VLDB features. You will learn how to set up a secure database using Virtual Private Database, and learn how to efficiently move data from database to database. The lesson topics are reinforced with structured tutorials and demonstrations with voice-based explanations. Evaluate your learning by taking a quiz at the end of each module. This self-passed learning is designed to prepare you for the corresponding Oracle Certified Professional exam.
 
 

Compétences acquises
 

  • Learn to use RMAN to create and manage backup sets and image copies

  • Learn to use recover the database to a previous point in time

  • Learn to use Oracle Secure Backup to backup and recover a database

  • Learn to use Oracle's Flashback technology to recover your database

  • Learn to detect block corruptions and take appropriate measures to correct them

  • Learn to use the various Database advisors and views to monitor and improve database performance

  • Learn to control database resource usage with the Resource Manager

 

  • Learn to simplify management tasks by using the Scheduler

  • Review database log files for diagnostic purposes

  • Learn to customize language-dependent behavior for the database and individual sessions

  • Learn to administer a VLDB

  • Learn to implement a secure database

  • Learn to transport data across platforms

Qui peut en profiter
 

  • Database Administrators

  • Sales Consultants

 

  • Support Engineer

  • Technical Consultant

Préalables
 

  • Knowledge of basic database administration

 
     
    Buy This Training
    Enroll For This Class
    Oracle DB PeopleSoft Hyperion Ce cours autoformation est certifié par le .

    Oracle University a nommé ExitCertified Partenaire de l’année 2011

    Il y a une différence....découvrez-la.
    Buy Training Now Ask A Question About This Training
    Code: D48978GC10
    Format: Formation individualisée en ligne
    Durée:
    Certifié par: Oracle
    Frais d’inscription (CAD): 4,125$
    Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011
    Recherchez des cours semblables
    Cours connexes

     

    OCP - Oracle Database 10g Administration Workshop II - RWC Contenu détaillé
     
     
    Introduction
    • Oracle Database 10g: The Database for the Grid
    • Database Architecture: Review
    • Oracle Memory Structures
    • Oracle Processes
    • Reviewing Oracle Instance Management
    • Physical Database Structure
    • Oracle Managed Files (OMF)
    • Logical and Physical Database Structures
    Configuring Recovery Manager
    • Recovery Manager Features and Components
    • Using a Flash Recovery Area with RMAN
    • Configuring RMAN
    • Control File Auto-backups
    • Retention Policies and Channel Allocation
    • Using Recovery Manager to connect to a target database in default NOCATALOG mode
    • Displaying the current RMAN configuration settings
    • Altering the backup retention policy for a database
    Using Recovery Manager
    • Issuing Recovery Manager Commands
    • Parallelization of Backup Sets
    • Compressed Backups
    • Image Copy
    • Whole Database and Incremental Backups
    • LIST and REPORT commands
    • Enable ARCHIVELOG mode for the database
    • Use Recovery Manager
    Recovering from Non-critical Losses
    • Causes of File Loss
    • Critical Versus Non-critical
    • Re-creating Redo Log Files
    • Re-creating Indexes
    • Authentication Methods for Database Administrators
    • Re-creating a Password Authentication File
    Database Recovery
    • Recovery Methods
    • User-Managed Recovery: RECOVER Command
    • RMAN Recovery: RESTORE and RECOVER Commands
    • Complete Versus Incomplete Recovery
    • Complete Recovery
    • Incomplete Recovery
    • Situations Requiring Incomplete Recovery
    • Types of Incomplete Recovery
    Flashback
    • Flashback Technology: Review
    • Flashback Drop and the Recycle Bin
    • Recycle Bin
    • Restoring Tables from the Recycle Bin
    • Recycle Bin: Automatic Space Reclamation
    • Querying Data from Dropped Tables
    • Configuring Flashback Database
    • Performing Flashback Database Using EM
    Dealing with Database Corruption
    • Block Corruption Symptoms: ORA-1578
    • Corruption-Related Features
    • DBVERIFY Utility
    • ANALYZE Command
    • Verifying Block Integrity in Real Time
    • Using EXP to Detect Corruption
    • Using Flashback for Logical Corruption
    • Block Media Recovery (BMR)
    Monitoring and Managing Memory
    • Oracle Memory Structures
    • DBVERIFY Utility and the ANALYZE command
    • Initialization parameter DB_BLOCK_CHECKING
    • Segment Metadata Dump and Verification
    • Using Flashback for Logical Corruption and using DBMS_REPAIR
    • Block Media Recovery
    • RMAN BMR Interface
    • Dumping and Verifying Segment Metadata
    Monitoring and Managing Memory
    • Oracle Memory Structures
    • Buffer Cache
    • Using Multiple Buffer Pools
    • Automatic Shared Memory Management: Overview
    • Benefits of Automatic Shared Memory Management
    • Configuring ASMM by Using Database Control
    • Behavior of Auto-tuned SGA Parameters
    • Behavior of Manually Tuned SGA Parameters
    		 
    Automatic Performance Management
    • Identifying Tunable Components
    • Oracle Wait Events and System Statistics
    • Troubleshooting and Tuning Views
    • Direct Attach to SGA for Statistic Collection
    • Workload Repository
    • Advisory Framework
    • ADDM Scenarios and Usage Tips
    • Using the SQL Tuning and SQL Access Advisor
    Managing Schema Objects
    • What Is a Partition and Why Use It?
    • Creating a Partition
    • Partitioning Methods
    • Partition Maintenance
    • Index-Organized Tables and Heap Tables
    • Situations Where Clusters Are Useful
    • Sorted Hash Cluster
    • Schema Management Tasks
    Managing Storage
    • Space Management: Overview
    • Free Space Management
    • Types of Segments
    • Allocating Extents
    • Block Space Management
    • Row Chaining and Migration
    • Proactive Tablespace Monitoring
    • Thresholds and Resolving Space Problems
    Automatic Storage Management
    • ASM General Architecture and Functionalities
    • Dynamic Performance View Additions
    • Managing an ASM Instance
    • ASM Disk Groups
    • Using asmcmd Command Line
    • Migrating Your Database to ASM Storage
    • Creating an ASM instance in a separate Oracle Home
    • Migrating a tablespace to use ASM storage
    Managing Resources
    • Database Resource Manager Concepts and Configuration
    • Creating a New Resource Plan
    • Active Session Pool Mechanism
    • Maximum Estimated Execution Time
    • Switching Back to the Initial Consumer Group at the End of Call
    • Setting Idle Timeouts
    • Resource Consumer Group Mapping
    • Activating a Resource Plan for an Instance
    Automating Tasks with the Scheduler
    • Simplifying Management Tasks
    • Key Components and Steps
    • Using a Time-Based or Event-Based Schedule
    • Creating a Time-Based Job
    • Creating an Event-Based Schedule
    • Creating Event-Based Schedules with Enterprise Manager
    • Creating an Event-Based Job
    • Creating Complex Schedules
    Database Security
    • Oracle Transparent Data Encryption (TDE): Overview
    • TDE Process
    • Implementing Transparent Data Encryption
    • Existing Tables and TDE
    • Transparent Data Encryption: Considerations
    • Wallet Support for Usernames and Passwords
    • Data Pump and Transparent Data Encryption
    • RMAN Encrypted Backups: Overview
    Using Globalization Support
    • What Every DBA Needs to Know
    • What Is a Character Set?
    • Understanding Unicode
    • How Are Character Sets Used?
    • Problems to Avoid
    • Choosing Your Character Set
    • Database Character Sets and National Character Sets
    • Obtaining Character Set Information
    Workshop
    • Workshop Methodology
    • Business Requirements
    • Database Configuration
    • Method for Resolving Database Issues


      ExitCertified is your Authorized IT Training Partner  
      Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

    Il y a une différence. Apprenez directement de la source.    		  
    Training Contacts  
       
    Canada United States

    Formation à Montréal :: 514.876.1666
    Formation à Ville de Québec :: 514.876.1666
    Formation à Ottawa :: 613.232.3948
    Formation à Toronto :: 416.487.3948

    Formation à Vancouver :: 604.633.3948
    Formation à Victoria :: 1.866.328.3948
    Formation à Calgary :: 403.291.2855
    Formation à Edmonton :: 780.441.3948
    Formation à Regina :: 1.866.328.3948

    		 Formation à Sacramento :: 916.669.3970
    Formation à San Francisco :: 415.975.3948
    Formation à San Jose :: 408.288.3948
    Formation à Las Vegas :: 1.800.803.3948
    Formation à Phoenix :: 602.889.9350
    À travers le monde - 613.232.3948 Des questions?
    Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
       



    (c) 2012 ExitCertified Corp. Tous droits réservés.


    ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
     
    Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
    Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
             
    Formation MySQL Formation Apple Formation en gestion de projet    
    Base de données MySQL Cours Apple, Formation Leopard Formation du PMI