[Terry Notes] RMAN comprehensive learning Configuration

 

[Terry Note] backup http://www.cnblogs.com/kkterry/p/3308405.html for RMAN Integrated Learning

[Terry Notes] recovery http://www.cnblogs.com/kkterry/p/3308407.html for RMAN Integrated Learning

[Terry Note] configuration http://www.cnblogs.com/kkterry/p/3308409.html for RMAN Integrated Learning

1. All configuration parameters of rman:

show ;  RECOVERY WINDOW   DAYS; 
 redundancy n; 
 OPTIMIZATION ; #  
 DEVICE TYPE  ; #  
; 
 DEVICE TYPE   ; 
 PARALLELISM   TYPE  BACKUPSET; #  
 COPIES  DEVICE TYPE   ; #  
 COPIES  DEVICE TYPE   ; #  
 UNLIMITED; #  
  ; #  
; #  
   RELEASE  OPTIMIZE   TRUE ; #  
 NONE; #  
 ; #  

  Ii. list backup information:

）list ）list  ）list   archivelog ）list archivelog ）list expired ;

  Iii. delete backup

) Expired); deletes all backups.

  4. crosscheck is used to check the backup. If the physical disk exists and there are records in the control file, available is displayed; otherwise, expired is displayed.

）crosscheck archivelog ）crosscheck ;

  5. report is used to analyze the current archive information

）report need ）report obsolete;

 

Vi. Channels

 format ;   PARALLELISM   TYPE  DEVICE TYPE  ;

  VII. Multiple copies of a composite backup

） copies  ;   copies  device type  format , DEVICE TYPE   COPIES  DEVICE TYPE   ; #  COPIES  DEVICE TYPE   ; # 

 

8. For the convenience of transmission, or some operating systems do not support large files, you can use the maxpiecesize = xxM parameter to specify the largest backup segment.

  maxpiecesize200M;

  9. as compressed backupset backup set compression (obvious effect)

  compressed backupset  format ;

10. Name

TuFcdbidyyyymmddUp_u_sp ID of the backup part in the backup set

  11. Attempts to achieve dynamic performance related to rmanV $ archived_log

V $ backup_set v $ backup_set_details backup set information the currently created backup set information backup_type (L archive, D data file full backup, I Incremental Backup) v $ backup_piece v $ backup_piece_details the backup fragment information set_stamp column can be associated with v $ backup_set.set_stamp