RMAN connect TARGET / CATALOG / NOCATALOG / AUXILIARY

RMAN can connecting to database has 3 purpose

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

1. TARGET
Target database that will be backup

2. CATALOG / NOCATALOG
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

3. AUXILIARY
Duplicate database for
- redudantency backup
- tablespace Point in time backup

Parameters can be use to set the RMAN Repository

1. CONTROL_FILE_RECORD_KEEP_TIME
2. DB_RECOVERY_FILE_DEST
3. DB_RECOVERY_FILE_DEST_SIZE

Environment Variable can affected these parameters
NLS_DATE_FORMAT
NLS_LANG

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
For spfile : Using command "ALTER SYSTEM SET LOG_ARHIVE_START=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.

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

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.

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.