Oracle Certificate Professional Preparation

I passed my Oracle Database 10g Certified Associate (OCA) on the beginning of 2006. After busy on my work several months. I started to prepare my Oracle Database 10g Administrator Certified Professional (OCP) exam.

This is my OCP exam studying dairy. I hope can share something to anyone whom want to take the OCP exam.

Monday, July 31, 2006


RMAN can connecting to database has 3 purpose

> RMAN TRAGET user/password@orclA NOTACATLOG user/password@orclB AUXILIARY user/password@orclC

Target database that will be backup

NOCATALOG is default setting for RMAN to store the backup meta data to the Control file in the target database

CATALOG can specific another database that will have RMAN Repsoitory that can store the backup meta data and the backup file of the target database

Duplicate database for
- redudantency backup
- tablespace Point in time backup

Sunday, July 30, 2006

Parameters can be use to set the RMAN Repository


Environment Variable can affected these parameters

Saturday, July 29, 2006

Enable ARCHIVELOG mode

1. Change either the binrary parameter file or the text parameter file
For pfile : manually edit the pfile to change the LOG_ARCHIVE_START value to TRUE

2. Shutdown and startup the database in mount mode

3. Using command "ALTER DATABASE ARCHIVELOG" to make the database in archivelog mode, or, using command "ALTER DATABASE NOARCHIVELOG" to disable the database archivelog mode.

4. Using command "ALTER DATABASE OPEN" to make the database open and avaliable for user connection.

5. Finished.

Friday, July 28, 2006

Sections Matching between two books

Before I start to read these 2 books. I tried to compare and match the sections between these 2 books. So that, I can easy to compare the contents different and got the important area that need to understand and memorizes.

After compared the book sections, I’m starting to read it details. In the coming posts, I‘ll write down the corresponding summary according to my studying here.

OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043[click here to buy this book]
Oracle Database 10g OCP Certification All-In-One Exam Guide[click here to buy this book]
Chapter 1: Configuring Recovery Manager
Chapter 23: Getting Started with Oracle Recovery Manager (RMAN)
Chapter 2: Using Recovery Manager
Chapter 24: Using RMAN to Back Up Oracle Databases
Chapter 3: Recovering From Non-Critical Losses
Chapter 26: Recovering from Noncritical Losses
Chapter 4: Database Recovery
Chapter 27: Incomplete Database Recovery
Chapter 5: Understanding the Flashback Database
Chapter 28: Using Oracle Flashback Database
Chapter 6: Recovering from User Errors
Chapter 29: Recovering from User Errors
Chapter 7: Handling Block Corruption
Chapter 30: Detecting and Recovering from Database Corruption
Chapter 8: Understanding Automatic Database Management
Chapter 25: Diagnosing Oracle Database Issues
Chapter 31: Tools for Oracle Database 10g Tuning
Chapter 9: Understanding Automatic Storage Management
Chapter 33: Managing Storage with Automatic Storage Management
Chapter 10: Understanding Globalization Support
Chapter 21: Managing Globalization in Oracle Databases
Chapter 11: Managing Resources
Chapter 35: Managing Oracle Database Resources
Chapter 12: Using the Scheduler to Automate Tasks
Chapter 36: Automating Administrative Tasks
Chapter 13: Monitoring and Managing Storage
Chapter 32: Monitoring and Managing Storage
Chapter 14: Securing the Oracle Listener, Diagnostic Sources, and Memory
Chapter 22: Configuring Security for the Listener
Chapter 25: Diagnosing Oracle Database Issues
Chapter 34: Monitoring and Managing Memory

Thursday, July 27, 2006

Features provided by the RMAN, but not from User Managed Backup

1. RMAN stored frequency used scripts
2. Change tracking background process (CTRW) is introduced for incremental backup
3. RMAN can control the backup pieces size
4. RMAN can recover an indiviual data block or set of data block of a data file
5. RMAN can integrate with the Oracle Scheduler
6. RMAN can detect block corruption. there hase 2 dynamic views are useful for this, V$BACKUP_CORRUPTION, V$COPY_CORRUPTION
7. RMAN has performance improvement
8. RMAN has media management API
9. RMAN help to keep track of all database files and backups.

Monday, July 24, 2006

Incorrect answer in the Flash Card

I found an incorrect answer in the flash card of the OCP Oracle 10g Administration II Study Guide book during my study. Hope this can help you to avoid fall into mess.

Question 25: The correct answer should be CTRW, but not the CRWT.

Question 48: The correct answer should be RESETLOGS, but not NORESETLOGS.