Oracle Corporation

Oracle Database 12c Administrator Certified Professional


Credential: Oracle Database 12c Administrator Certified Professional
Credentialing Agency: Oracle Corporation

Renewal Period: Within 12 months of certification retirement

An Oracle Certified Professional (OCP) 12c Database Administrator certification emphasizes the full set of skills that DBAs need in today's competitive marketplace. This intermediate certification builds upon the competencies in the Oracle Database 12c OCA certification by including the advanced knowledge and skills required of top-performing database administrators, including development and deployment of backup, recovery and Cloud computing strategies. Candidates are required to be certified at the Oracle Certified Associate level before they are begin the OCP certification process. Candidates must also complete a course delivered by Oracle University Training Center, Oracle Authorized Education Center, Oracle Authorized Partner, Oracle Acadmy, or Oracle Workforce Development Program. Once the training course is completed, candidates are required to pass an exam to obtain the certification.

More information can be found on the certifying agency's website.

Oracle Database 12c Administrator Certified Professional

MINIMUM REQUIREMENTS

Attainability:    medium

Eligibility Requirements (View Details)

  • Credential Prerequisite: Oracle Database 12c Administrator Certified Associate
  • Experience
  • Education
  • Training
  • Membership
  • Other
  • Fee

Note: This credential may have multiple options for a Service member to meet eligibility requirements. Requirements listed here are based on the minimum degree required. To view other options, see the Eligibility tab.

Exam Requirements (View Details)

  • Exam
  • Written Exam
  • Oral Exam
  • Practical Exam
  • Performance Assessment

Exam Administration (View Details)

  • In-person exam
  • Remote proctored on-line exam
  • Third-party test vendor

RECERTIFICATION SUMMARY

Renewal Period: Within 12 months of certification retirement

  • Continuing Education
  • Exam
  • Continuing Education OR Exam
  • Fee
  • Other

AGENCY CONTACT INFORMATION

Oracle Corporation

500 Oracle Parkway
Redwood Shores, CA  94065

Phone: (650) 506-7000

Contact Page

Candidates must hold the Oracle Database 12c Administrator Certified Associate certification.

To become an Oracle Certified Professional, candidates must complete one of the approved instructor-led online or in-class courses. A list of eligible courses to complete this requirement can be found here on the Oracle website.

Written Exam 1Z1-063

  • Backup and Recovery
    • Explain Oracle backup and recovery solutions
  • Configuring for Recoverability
    • Configure and manage RMAN settings
    • Configure the Fast Recovery Area
    • Configure control files and redo log files for recoverability
  • Implementing Backup Strategies
    • Use various RMAN backup types and strategies
    • Use various RMAN backup types and strategies
  • Configuring RMAN Backup Options and Creating Backup of Non-Database Files
    • Use techniques to improve backups
    • Perform backup of non-database files
  • Diagnosing Failures
    • Describe the Automatic Diagnostic Workflow
    • Handle block corruption
  • Recovering Files Using RMAN
    • Perform recovery for spfile, control file, redo log files
    • Perform table recovery from backups
    • Perform recovery of index and read-only tablespaces, temp file
    • Restore a database to a new host
  • Using Flashback Technologies
    • Describe the Flashback technologies
    • Use Flashback to query data
    • Perform Flashback Table operations
    • Describe and use Flashback Data Archive
  • Transporting Data
    • Describe and use transportable tablespaces and databases
  • Monitoring and Tuning of RMAN Operations
    • Tune RMAN performance
  • Creating Multitenant Container Databases and Pluggable Databases
    • Configure and create a CDB
    • Create a PDB using different methods
    • Unplug and drop a PDB
    • Migrate a non-CDB database to PDB
  • Managing Storage in a CDB and PDBs
    • Manage permanent and temporary tablespaces in CDB and PDBs
  • Managing Availability
    • Perform backups of a CDB and PDBs
    • Recover PDB from PDB datafiles loss
    • Use Data Recovery Advisor
    • Duplicate PDBs using RMAN
    • Use Other Products with CDB and PDBs - Database Vault, Data Guard, LogMiner
  • Moving Data, Performing Security Operations and Interacting with Other Oracle Products
    • Use Data Pump
    • Use SQL*Loader
    • Audit operations
  • Performing Basic Backup and Recovery
    • Back up and recover a NOARCHIVELOG database
    • Perform backup and recovery in NOARCHIVELOG mode
    • Use SQL in RMAN
  • Using the RMAN Recovery Catalog
    • Create and use an RMAN recovery catalog
    • Protect the RMAN recovery catalog
  • Performing Backups
    • Perform full and incremental backups
    • Manage backups
  • Using RMAN-Encrypted Backups
    • Create RMAN-encrypted backups
  • Performing Restore and Recovery Operations
    • Describe and tune instance recovery
    • Perform complete and incomplete recovery
  • Using Oracle Secure Backup
    • Configure and use Oracle Secure Backup
  • Using Flashback Database
    • Perform Flashback Database
  • Duplicating a Database
    • Choose a technique for duplicating a database
    • Create a backup-up based duplicate database
    • Duplicate a database based on a running instance
  • Multitenant Container and Pluggable Database Architecture
    • Describe the multitenant container database architecture
    • Explain pluggable database provisioning
  • Managing a CDB and PDBs
    • Establish connections to CDB/PDB
    • Start up and shut down a CDB and open and close PDBs
    • Evaluate the impact of parameter value changes
  • Managing Security in a CDB and PDBs
    • Manage common and local users
    • Manage common and local privileges
    • Manage common and local roles
    • Enable common users to access data in specific PDBs
  • Managing Performance
    • Monitor operations and performance in a CDB and PDBs
    • Manage allocation of resources between PDBs and within a PDB
    • Perform Database Replay

Exam Preparation Resources

There are a number of resources available to help you prepare for the Oracle Database 12c Administrator Certified Professional examination:

An additional resource is O'Reilly Learning Safari Books Online, a searchable digital library that provides online access to thousands of books, training videos and conference sessions. See the Educational Resources section on the Related Sites page here on COOL to learn how to get free access.

Testing Information

  • Exam Administration

    Credential exams may be administered in-person at a testing site, proctored on-line remotely, or have options for both. If an exam is administered through a test vendor, the third-party test vendor box will be checked. The following test administration options apply to the Oracle Database 12c Administrator Certified Professional credential where checked:

    • In-person exam
    • Remote proctored on-line exam
    • Third-party test vendor
  • For more information on the Oracle Corporation testing process, visit the agency website.

RECERTIFICATION

Oracle Database 12c Administrator Certified Professional

Renewal Period: Within 12 months of certification retirement

The Oracle Database 12c Administrator Certified Professional credential has the following recertification information:

  • Certain Oracle credentials require periodic recertification in order for Oracle to recognize them as "active". For such credentials, candidates must upgrade to a current version within twelve (12) months following Oracle's credential retirement to keep his or her certification in active status. Specific upgrade requirements for each credential will vary and Oracle will notify affected candidates of the applicable upgrade requirements upon credential retirement. Oracle requires candidates to hold an active credential in order to access certain certification benefits including, without limitation, use of Oracle certification logos, eCertificates, score reports, digital badges and certification verification.
  • Note: Marine Corps COOL will only pay recertification fees for the current year, no arrears will be paid. Voucher requests for recertification fees must be submitted with proof of the current status of the certification (for example, a screen shot of your credentialing agency dashboard or a copy of a current fee receipt).

In Demand

This certification is considered in demand. The U.S. Department of Labor sponsored CareerOneStop's analysis indicates the certification is frequently mentioned in online job postings.

Click for external link to CareerOneStop's Credentials Center.

COOL Bucks

See your installation Education Service Officer for credential exam information and coordinating instructions.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

Some

Credential is related to some tasks associated with the duties of the military occupation (at least one critical task but less than 80%)

Most

Credential is directly related to most of the major duties associated with the military occupation (at least 80%)

Other

Credential is related to this military occupation, but is more advanced or specialized and therefore will likely require additional education, training, or experience

CA Eligible

This certification is eligible for CA.

Star

Star credentials are MOS enhancing, as designated by the Proponent. MOS enhancing credentials are directly related to an MOS or ASI, are taught either partially or completely as part of a Program of Instruction (POI), and improves the MOS technical proficiency.

Skill Level

The Skill Level reflects the level, based on MOS training and/or experience, the Soldier should be the most prepared to successfully earn the credential. See the Table Legend for details about each level.

Navy Bucks

Credential voucher or reimbursement for credential exam, re-certification, or maintenance fee has been approved for payment through the Navy's Credential Program Office. To get a voucher request form, click Menu at the top of any page, then click "2 Complete Voucher and Apply" under Credentialing Steps.

CG Bucks

Current Coast Guard policy states all credentials listed on CG COOL may be reimbursed assuming the enlisted service member meets the eligibility requirements as outlined in the Coast Guard Voluntary Credentialing Program Policy (COMDTINST 1540.1(series))

Early Career

1-3 years experience; Enlisted E1 through E4

Mid Career

4-10 years experience; Enlisted E5 through E6

Late Career

10+ years experience; Enlisted E7 through E9

Early Career

1-3 years experience; Enlisted “A” School through E5

Mid Career

4-10 years experience; Enlisted E6 through E7

Late Career

10+ years experience; Enlisted E8 through E9

Early Career

1-6 years experience; Officer O1 through O2

Mid Career

6-12 years experience; Officer O3 through O5

Late Career

12+ years experience; Officer O6 and Above

GI Bill®

Reimbursement for exam fees has been approved for payment through the GI Bill.

Note: GI Bill approval data is updated quarterly. For the latest information, visit the WEAMS Licenses/Certifications Search page. Make sure to select "Both" in the LAC Category Type drop-down before searching.

Click to go to the external link for GI Bill licensing and certification information.

ANAB (ANSI)

This credential has been accredited by ANAB (ANSI).

Click to go to the external ANAB web site.

ICAC

This credential has been accredited by ICAC.

Click to go to the external ICAC web site.

ABSNC

This credential has been accredited by ABSNC.

Click to go to the external ABSNC web site.

NCCA

This credentialing program has been accredited by NCCA.

Click to go to the external NCCA web site.

IAS

This credential has been accredited by IAS.

Click to go to the external IAS web site.

Low

May be difficult to attain: minimum education requirement is a Bachelor's degree, and/or minimum experience is 10 or more years.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

Medium

Moderate ease of attainment: minimum education requirement = Associate's and/or prerequisite and/or minimum experience = more than 2 years and less than 10 years of experience.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

High

Highly attainable: minimum education requirement = HS or less and/or minimum experience = 2 years or less experience and no additional requirements.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

MOS is Military Occupational Specialty
ASI is Additional Skill Identifier
WOMOS is Warrant Officer Military Occupational Specialty
AOC is Area Of Concentration Officer
Functional Area
Branch

Army e-learning

State-of-the art Computer Based Training available for free to the Army Workforce. Click for more information.

Click here for more information.

NKO e-learning

$$ELEARN_NKO_DESC$$

Bright Outlook – new job opportunities are very likely in the future for this job

Registered Apprenticeship

An apprenticeship program is registered with the U.S. Department of Labor. Go to the Apprenticeship Finder and enter career path or location to find apprenticeship opportunities.

Click here for External link to: My Next Move for Veterans - Database Administrators
Click here for External link to: My Next Move salary info for Database Administrators

Bright Outlook – new job opportunities are very likely in the future for this job

Click here for external link to: My Next Move for Veterans State Map for Database Administrators

This is an official U.S. Marine Corps website
Updated: January 29, 2021
Top