14配置和使用恢復(fù)管理器(存儲版)
【正文】 ight 169。 RMAN REPORT OBSOLETE。 2023, Oracle. All rights reserved. Monitoring RMAN Backups ? Correlate server sessions with channels by using the SET COMMAND ID mand. ? Query V$PROCESS and V$SESSION to determine which sessions correspond to which RMAN channels. ? Query V$SESSION_LONGOPS to monitor the progress of backups and copies. ? Use an operating system utility to monitor the process or threads. 69 Copyright 169。 64 Copyright 169。SYSDATE739。file_name39。 2023, Oracle. All rights reserved. RMAN Backup Types ? A full backup contains all used data file blocks. ? A level 0 incremental backup is equivalent to a full backup that has been marked as level 0. ? A cumulative level 1 incremental backup contains only blocks modified since the last level 0 incremental backup. ? A differential level 1 incremental backup contains only blocks modified since the last incremental backup. Differential incremental backup Cumulative incremental backup Full, or level 0 incremental backup 56 Copyright 169。 2023, Oracle. All rights reserved. Tags for Backups and Image Copies A tag is a logical name assigned to a backup set or image copy. month_full_backup week_full_backup Data file 3 Data file 4 Backup set Data files 1,3 Data files 2,4 Backup set 49 Copyright 169。/ORADATA/39。 3 TABLESPACE hr_data。/u01/db01/backup/%d_%s_%p39。 RMAN RUN { 2 ALLOCATE CHANNEL d1 DEVICE TYPE DISK 3 FORMAT 39。 2023, Oracle. All rights reserved. Channel Allocation Channel (DISK) BACKUP RESTORE RECOVER Server session Server session Target database Channel (SBT) RMAN 32 Copyright 169。 2023, Oracle. All rights reserved. ? A retention policy describes which backups will be kept and for how long. ? There are two types of retention policies: – Recovery window: Establishes a period of time within which pointintime recovery must be possible – Redundancy: Establishes a fixed number of backups that must be kept ? These policies are mutually exclusive and can be set with the CONFIGURE mand. Retention Policies Now Sevenday retention File1 File2 File2 needs to be backed up: 30 Copyright 169。 2023, Oracle. All rights reserved. RMAN Usage Considerations ? Resources: Shared memory, more processes ? Privileges given to users: – Database: SYSDBA – Operating system: Access to devices ? Remote operations: – Set up the password file – Ensure that the password file is backed up 22 Copyright 169。 2023, Oracle. All rights reserved. Flash Recovery Area Space Usage ? Configure the retention policy to the minimum value appropriate for your database. ? Back up the archive log files regularly and delete the files upon pletion of the backup. ? Use the RMAN REPORT OBSOLETE and DELETE OBSOLETE mands to remove backups and file copies that are not required. 15 Copyright 169。 2023, Oracle. All rights reserved. Steps for Configuring RMAN 1. Determine the repository location: control file or recovery catalog. 2. Define database and environment variables. 3. Start RMAN and connect to the target and, optionally, the recovery catalog databases. 4. Configure persistent settings. 6 Copyright 169。 2023, Oracle. All rights reserved. Server session Channel Server session Enterprise Manager Recovery Manager Components Target database Recovery catalog database Auxiliary database Disk Flash recovery area Channel Channel MML Options Recovery Manager (RMAN) 5 Copyright 169。 2023, Oracle. All rights reserved. Monitoring the Flash Recovery Area with EM 14 Copyright 169。 2023, Oracle. All rights reserved. Setting Parameters That Affect RMAN ? Database initialization parameters – CONTROL_FILE_RECORD_KEEP_TIME – DB_RECOVERY_FILE_D
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1