14配置和使用恢復(fù)管理器-文庫吧資料
2025-01-07 03:28本頁面
【正文】 racle. All rights reserved. Compressed Backups RMAN BACKUP AS 2 COMPRESSED BACKUPSET 3 DATABASE。 2023, Oracle. All rights reserved. Backup Constraints ? The database must be mounted or open. ? You cannot back up online redo logs. ? Only “clean” backups are usable in NOARCHIVELOG mode. ? Only “current” data file backups are usable in ARCHIVELOG mode. 43 Copyright 169。 3 TABLESPACE hr_data。 2023, Oracle. All rights reserved. BACKUP Command RMAN BACKUP AS BACKUPSET 2 FORMAT 39。 7 } 39 Copyright 169。 6 SQL 39。/u01/db01/backup/%d_%s_%p39。 2023, Oracle. All rights reserved. Types of RMAN Commands RMAN mands are of the following types: ? Standalone mand: – Is executed individually at the RMAN prompt – Cannot appear as submands within RUN ? Job mand: – Must be within the braces of a RUN mand – Is executed as a group Some mands can be executed as either a standalone or a job mand. 38 Copyright 169。 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。 4 BACKUP DATABASE PLUS ARCHIVELOG。 RMAN RUN { 2 ALLOCATE CHANNEL d1 DEVICE TYPE DISK 3 FORMAT 39。 2023, Oracle. All rights reserved. Channel Control Options ? Configure parallelism: ? Specify the maximum backup piece size: ? Format the name of generated backup files: RMAN CONFIGURE DEVICE TYPE DISK PARALLELISM 3。/u01/oradata/39。 RMAN RUN { 2 ALLOCATE CHANNEL c1 DEVICE TYPE disk。 2023, Oracle. All rights reserved. Channel Allocation Channel (DISK) BACKUP RESTORE RECOVER Server session Server session Target database Channel (SBT) RMAN 32 Copyright 169。 RMAN CONFIGURE DEFAULT DEVICE TYPE CLEAR。 RMAN CONFIGURE BACKUP OPTIMIZATION CLEAR。 RMAN SHOW EXCLUDE。 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. Control File Autobackups RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON。 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. Starting RMAN ? Starting RMAN locally ? Starting RMAN remotely UNIX: $ ORACLE_SID=DB01。 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. Benefits of Using a Flash Recovery Area Using the flash recovery area fo
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1