About Oracle DBA
Every database requires one database administrator (DBA) to administrate the data. If we have many users then the oracle database is very large, one person is not enough to do that work. In such cases the work, responsibilities is divided between number of people.
WHO SHOULD LEARN ORACLE DBA:Knowledge with oracle modules, sql can learn oracle DBA.
PRE-REQUISITES FOR ORACLE DBA:
SQL, Oracle modules are the pre-requisites for the oracle DBA. RizeTrainings provides oracle apps online training with real time experienced faculty .Our faculty provides job assistance training.
Course Details: Introduction Grid Computing Oracle Enterprise Manager 10g Product Controls Database Architecture Review Configuring Recovery Manager Recovery Manager Features and Components Using a Flash Recovery Area with RMAN Configuring RMAN Control File Autobackups 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 RMAN Command Overview 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 Oracle Secure Backup Installation and Configuration Implement the Oracle suggested strategy RMAN and Oracle Secure Backup Database and File-system files backup/restore to tape Using obtool and web interface to configure Oracle Secure Backup devices (CLI/GUI) Configuring EM for Oracle Secure Backup and test backup to tape (EM) Using RMAN to backup your database to tape (CLI) Using the OB Web tool to backup file system files Recovering from Non-critical Losses Recovery of Non-Critical Files Creating New Temporary Tablespace Recreating Redo Log Files, Index Tablespaces, and Indexes Read-Only Tablespace Recovery Authentication Methods for Database Administrators Loss of Password Authentication File Creating a new temporary tablespace Altering the default temporary tablespace for a database Incomplete Recovery Recovery Steps Server and User Managed Recovery commands Recovering a Control File Autobackup Creating a New Control File Incomplete Recovery Overview Incomplete Recovery Best Practices Simplified Recovery Through RESETLOGS Point-in-time recovery using RMAN Flashback Flashback Database Architecture Configuring and Monitoring Flashback Database Backing Up the Flash Recovery Area Using V$FLASH_RECOVERY_AREA_USAGE Flashback Database Considerations Using the Flashback Database RMAN interface Using Flashback Database EM Interface Managing and monitoring Flashback Database operations Dealing with Database Corruption Block Corruption Symptoms: ORA-1578 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 Automatic Shared Memory Management SGA Tuning Principles Database Control and Automatic Shared Memory Management Behavior of Auto-Tuned and Manual SGA Parameters Resizing SGA_TARGET PGA Management Resources Using the Memory Advisor 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 Monitoring and Managing Storage I Database Storage Structures Space Management Overview Oracle-Managed Files (OMF) Row Chaining and Migrating Proactive Tablespace Monitoring Managing Resumable Space Allocation SYSAUX Tablespace Monitoring table and index space usage Monitoring and Managing Storage II Automatic Undo Management Redo Log Files Table Types Partitioned Tables Index-Organized Tables (IOT) Managing index space with SQL Configure optimal redo log file size View "Automatic Tuning of Undo Retention" 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 VLDB Support Creating Bigfile Tablespaces Packages and data dictionary changes to support VLDB Creating and maintaining temporary tablespace groups (TTG) Partitioning and Partitioned Indexes Skipping unusable indexes Creating and using hash-partitioned global indexes DML Error Logging Interpreting Bigfile ROWIDs Managing Resources Database Resource Manager Concepts and Configuration Creating a New Resource Plan Active Session Pool Mechanism Maximum Estimated Execution Time Creating a Complex Plan Administering and Monitoring Resource Manager Resource Plan Directives Creating Resource Consumer Groups Automating Tasks with the Scheduler Scheduler Concepts Creating a Job Class and a Window Managing Jobs, Programs, Chains, Events, Schedules, priority Viewing and Purging Job Logs Creating a program and a schedule Creating a job that uses a program and a schedule Altering the program and schedule for the job and observing the behavior change of the job Monitoring job runs Database Security Virtual Private Database: Overview Creating a Column-Level Policy Writing a Policy Function Policy Types Column level VPD with column masking Transparent Data Encryption Setting the listener password Implement VPD Data Movement External Tables Concepts Creating a Directory object and External Table Data Pump Transport Database RMAN CONVERT DATABASE Command Transport Tablespace Create a Directory Object Create a Temporary Table Using Globalization Support Globalization Support Features Encoding Schemes Database Character Sets and National Character Sets Specifying Language-Dependent Behavior Locale Variants Using Linguistic Comparison and Sorting Data Conversion Between Client and Server Character Sets Determining the Default NLS Settings Workshop Workshop Methodology, requirements, and setup Scenario 1: Database performance Scenario 2: Finding and Tuning Inefficient SQL Scenario 3: SGA Management - REDO Scenario 4: Running out of Undo Space Scenario 5: Missing datafile Scenario 6: Managing space in a tablespace - REDO Scenario 7: Missing TEMP data file
RIZE Trainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. RIZE come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.
RIZE trainers assist in developing Real time experience of the required course and also improving interview skills, knowledge, communication, content of the course, innovative project ideas, future scope etc,. This makes our students are becoming future experts and working as professionals in top rated companies.
The course begins in a few days, and I still do not have my login information. What do I do? Once your registration for a course is completed, we will send activation link to start your sessions. What happens if I miss my training date, do I have any options? In case you miss training date, we will send recorded sessions to you. Otherwise, we assign for next live batch. How does the online training work? All of our online courses are live instructor led online courses. You will have the ability to interact directly with the trainer. Once registered for a class you will receive detailed instructions on how to access your class. How do I receive the course materials? You receive a link to download the course materials when you register. Our trainers assist you in your assessments, case studies, sample projects, interview skills etc; Will I be able to view the sessions again at a later time? Yes, We provide recorded sessions. Who are your trainers? All our trainers are working professionals from the Industry and have at least 10-12 yrs of relevant experience in various domains. They are subject matter experts. So that participants get a great learning experience. Can I get the same in-class experience at home or work? Yes. You can attend courses anywhere that has an Internet connection. If you choose to participate from your home or workplace, you must validate your own equipment to ensure it meets the required specifications. What should I bring to class? You need to have your course materials, Internet, computer headset and the Link to your Rizetrainings classroom e-mail, which contains the link and LOGIN credentials you need to take your course. Where can I get more information? If you need more information, please call us at +91-879 000 6753 or send mail to firstname.lastname@example.org . Rize Trainings Advisors will be happy to assist you. Do you offer placements? We help our customers for preparing their resumes, work on sample live projects and provide assistance for interview preparation. We don't offer any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project. What happens if I have technical problems during my class? If you have technical difficulties, you call us at +91-879 000 6753 . Our support team will resolve any issues you might encounter.