Oracle Database 10g WorkshopII (Day1)



Charpter1 Introduction

Oracle database review, oracle database consist of two part: instance and data. Instance is the memory and some background processes. Data is the datafile.
Memory consist of SGA and PGA and processes including SMON, PMON, DBWn(0-9), CKPT, LGWR, ARCn(0-9)
SCN should be sync in control file, data file and online redo log file.
Schema can be understand as equals to user.
Can get the tablespace and segment related information from dba_segments;, dba_tablespaces.
Data block show be continuous, but extent are not required to.

Charpter2 Configure RMAN

Backup of data files, control files and archived redo log files.
Backup information can stored in control file or catalog database.
Channel is assigned before data moved (need to explicitly assign channel before 9i)
RMAN and sqlplus use the same authorized interface.
Sqlplus / as sysdba -> use the os authorized
Sqlplus username/password@SID / as sysdba -> use the password file authorized.
This is only for sysdba privilege.
Backup data can be stored in disk, MML or flashback recovery area.
You can get the backup space usage from v$flash_recovery_area_usage or through EM.
In order to recover to specified time based, you need to set correct time format use:
NLS_DATE_FORMAT=’yyyy-mm-dd hh24:mi:ss’
RMAN command can have several arguments such as: LOG=xxxx, CMDFILE=xxxxxx
You can view and change the RMAN setting using: show all and configure xxxx
Control file auto backup set to on will do the control file auto backup when do backup
You can set the retention policy to keep the backup copy or some period of days

Charpter3 Using RMAN

Channel parallelism equals to channel number assign during creation.
RMAN can be in a single command or in job command.
Backup format can be in backup set or image copy, backup set can be compressed mode.
Database must at least in mounted state to perform the backup.
Backup archived redo log will: automatic switch the redo log, can specified the backup range, can only include the redo log, and can delete the archived redo log after finish backup.
Level 0 backup equals to full backup.
Level 1 backup backup the data since last level 0 backup and can be differential or cumulative.
Differential level 1 backup backup all changes since last incremental backup.
Cumulative level 1 backup backup all changes since last level 0 backup.
Enable the block change track feature will record all the data block changed in bitmap.
Incremential update backup can do the backup and perform the lastest backup to backup set.

This entry was posted in 数据库 and tagged . Bookmark the permalink.

2 Responses to Oracle Database 10g WorkshopII (Day1)

  1. ipopo says:


Leave a Reply

Your email address will not be published. Required fields are marked *