14配置和使用恢復(fù)管理器-wenkub
2023-01-22 03:28:33 本頁面
【正文】 erver 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。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. Using a Flash Recovery Area with RMAN You can configure RMAN to use the flash recovery area. Database area RMAN backup process Flash recovery area DB_RECOVERY_FILE_DEST = 39。 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. Backing Up the Flash Recovery Area RMAN BACKUP RECOVERY FILES。 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. Additional RMAN CommandLine Arguments ? Writing RMAN output to a log file ? Executing a mand file when RMAN is invoked ? Establishing database connections on RMAN startup $ rman TARGET sys/oracle CMDFILE=$HOME/scripts/ $ rman TARGET sys/oracle LOG=$HOME/oradata/u03/ APPEND $ rman TARGET SYS/sys_pwdorcl CATALOG rman/rmanrcat 25 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。 RMAN CONFIGURE BACKUP OPTIMIZATION CLEAR。 2023, Oracle. All rights reserved. Channel Allocation Channel (DISK) BACKUP RESTORE RECOVER Server session Server session Target database Channel (SBT) RMAN 32 Copyright 169。/u01/oradata/39。 RMAN RUN { 2 ALLOCATE CHANNEL d1 DEVICE TYPE DISK 3 FORMAT 39。 2023, Oracle. All rights reserved. Summary In this lesson, you should have learned how to: ? Use either the control file or a recovery catalog for the RMAN repository ? Change RMAN default settings with CONFIGURE ? Use the flash recovery area for RMAN operations ? Monitor the flash recovery area by using v$ views and Enterprise Manager ? Implement recovery window and redundancy retention policies ? Implement manual and automatic channel allocation 35 Copyright 169。/u01/db01/backup/%d_%s_%p39。 7 } 39 Copyright 169。 3 TABLESPACE hr_data。 2023, Oracle. All rights reserved. Compressed Backups RMAN BACKUP AS 2 COMPRESSED BACKUPSET 3 DATABASE。/ORADATA/39。39。 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
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1