Oracle database review, oracle database consist of two part: instance and data. Instance is the memory and some background processes. Data is the datafile.
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.
Backup of data files, control files and archived redo log files.
Backup information can stored in control file or catalog database.
RMAN and sqlplus use the same authorized interface.
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.
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.