OCP prepare 20140627

1. Catalog start

Catalog start with is a good command. With this command, you can basically stop using the Catalog Database. Because you can use this commandBackupSet Information is re-imported to the current control file, which is generally usedRMANRestore, The control file is old or manually created (such control files certainly do not have the latest backup set information ), you can use catalog start with to import the latest backup set and the list of archived log files to the control text, and then restore RMAN.

Http://hi.baidu.com/itnote/item/66aa2dc939a0b510515058c1

 

2. Using RMAN restore control file

Http://jackrui.blog.163.com/blog/static/14951299201072193341637/

 

3. RMAN configure

Http://blog.csdn.net/robinson1988/article/details/4742920

Configure device type disk backup type to compressed backupset

Sets the backup set to be compressed and the degree of parallelism is 2.

Configure backup Optimization on;

When backup is optimized, It is disabled by default. For example, if a tablespace is read-only, the read-only tablespace will not be backed up during the second backup.

Configure datafile backup copies for device type disk to 1; # default

Indicates that only one backup is generated when the backup set is generated. If you change 1 to 2, two backups are generated, including data files, control files, and parameter files.

Configure Default device type to disk/SBT;

The default device for backup configuration is Disk/tape.

 

 

4. Incremental Backup

-- Difference: Level N or n-1 of the last backup

-- Accumulation: Back up all

 

Http://wenku.baidu.com/link? URL =_o9Tbvs18DSNAc-o4SWCH0eP8jVpPch719GXPZDoVDEz87aEThhQxyR7PREgS2CO4hSYUDLinj6HXh5GjwxuhtGpuDwe6WzcpnmvOSMCdxS

 

5. RMAN will not back up

Online redo logs database pfiles

** If autobackup is set, database pfiles will be backed up.

 

6. catalog command

The catalog command can be used to scan backup slices, copy files (datafile or controlfile copy), or scan archiving logs, even if the catalog database crashes and the control file is rebuilt, These backups can be used for recovery.

Http://czmmiao.iteye.com/blog/1461485

 

7. Round trunc

 

7

Group functions on columns ignore null values.