loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Oracle Database 11g: Administration II (1Z0-05)

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With OraLnx Technologies

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

Oracle Database 11g: Administration II (1Z0-05)

Online Instructor led Course

Platform: webex/GotoMeeting/Skype

7,000

No Reviews Yet
0 Interested

About the Course


After completing this course you would be able to perform duties Oracle DBA duties and you can appear for exam 1Z0-053 Oracle Database 11g: Administration II OCP.

Topics Covered

Database Architecture and ASM

Describe Automatic Storage Management (ASM)
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Administer ASM disk groups

Configuring for Recoverability

Configure multiple archive log file destinations to increase availability
Define, apply and use a retention policy
Configure the Flash Recovery Area
Use Flash Recovery Area

Using the RMAN Recovery Catalog

Identify situations that require RMAN recovery catalog
Create and configure a recovery catalog
Synchronize the recovery catalog
Create and Use RMAN stored scripts
Back up the recovery catalog
Create and use a virtual private catalog

Configuring Backup Specifications

Configure backup settings
Allocate channels to use in backing up
Configure backup optimization

Using RMAN to Create Backups

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 long-term retention
Create a multisection, compressed and encrypted backup
Report on and maintain backups

Performing User-Managed Backup and Recovery

Recover from a lost TEMP file
Recover from a lost redo log group
Recover from the loss of password file
Perform user-managed complete database recovery
Perform user-managed incomplete database recovery
Perform user-managed and server managed backups
Identify the need of backup mode
Back up and recover a control file

Using RMAN to Perform Recovery

Perform complete recovery from a critical or noncritical data file loss using RMAN
Perform incomplete recovery using RMAN
Recover using incrementally updated backups
Switch to image copies for fast recovery
Restore a database onto a new host
Recover using a backup control file
Perform Disaster recovery

Using RMAN to Duplicate a Database

Creating a duplicate database
Using a duplicate database

Performing Tablespace Point-in-Time Recovery

Identify the situations that require TSPITR
Perform automated TSPITR

Monitoring and Tuning RMAN

Monitoring RMAN sessions and jobs
Tuning RMAN
Configure RMAN for Asynchronous I/O

Using Flashback Technology

Restore dropped tables from the recycle bin
Perform Flashback Query
Use Flashback Transaction

Additional Flashback Operations

Perform Flashback Table operations
Configure, Monitor Flashback Database and Perform Flashback Database operations
Set up and use a Flashback Data Archive

Diagnosing the Database

Set up Automatic Diagnostic Repository
Using Support Workbench
Perform Block Media Recovery

Managing Memory

Implement Automatic Memory Management
Manually configure SGA parameters
Configure automatic PGA memory management

Managing Database Performance

Use the SQL Tuning Advisor
Use the SQL Access Advisor to tune a workload
Understand Database Replay

Space Management

Manage resumable space allocation
Describe the concepts of transportable tablespaces and databases
Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Resources

Understand the database resource manager
Create and use Database Resource Manager Components

Automating Tasks with the Scheduler

Create a job, program, and schedule
Use a time-based or event-based schedule for executing Scheduler jobs
Create lightweight jobs
Use job chains to perform a series of related tasks

Administering the Scheduler

Create Windows and Job Classes
Use advanced Scheduler concepts to prioritize jobs

Who should attend

Anyone interested.

Pre-requisites

English, should have knowledge of IT.

What you need to bring

Below is per-requisite:

You need to have
=>your own desktop/Laptop at least 2GB and dual core or 3rd generation procession, at least 100GB Disk space.
=>Internet access to attend online Instructor let course using Webex/Goto meeting."

Key Takeaways

After completing this course you would be able to perform duties Oracle DBA duties and you can appear for exam 1Z0-053 Oracle Database 11g: Administration II OCP.
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

BalvantC

MCA, BSC(Phy), Oracle Certified Professional DBA 11g,10g,9i, Oracle Certified Expert 11g RAC


Total 15+ Years of Oracle DBA experience in India and USA and worked with mostly fortune 100 clients.

Initial years of my career, I worked as Oracle developer DBA and working as core DBA for last 6 years.

I have expertise on Oracle 11g, 10g,9i, Administration, Backup Recover, ASM, GRID, RAC, Linux, Standby database, disaster recovery, Exadata, Performance tuning.
Seats Left-

Students Interested 0

Course Id: 14828