14配置和使用恢復(fù)管理器-全文預(yù)覽
【正文】 y “current” data file backups are usable in ARCHIVELOG mode. 43 Copyright 169。 2023, Oracle. All rights reserved. BACKUP Command RMAN BACKUP AS BACKUPSET 2 FORMAT 39。 6 SQL 39。 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。 4 BACKUP DATABASE PLUS ARCHIVELOG。 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。 RMAN RUN { 2 ALLOCATE CHANNEL c1 DEVICE TYPE disk。 RMAN CONFIGURE DEFAULT DEVICE TYPE CLEAR。 RMAN SHOW EXCLUDE。 2023, Oracle. All rights reserved. Control File Autobackups RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON。 2023, Oracle. All rights reserved. Starting RMAN ? Starting RMAN locally ? Starting RMAN remotely UNIX: $ ORACLE_SID=DB01。 2023, Oracle. All rights reserved. Benefits of Using a Flash Recovery Area Using the flash recovery area for recoveryrelated files: ? Simplifies the location of database backups ? Automatically manages the disk space allocated for recovery files ? Does not require changes to existing scripts ? Puts database backups, archive logs, and control file backups in the flash recovery area 19 Copyright 169。 FILE_TYPE USED RECLAIMABLE FILES 16 Copyright 169。 DB_RECOVERY_FILE_DEST_SIZE = 2G 13 Copyright 169。 2023, Oracle. All rights reserved. Backup Destinations Backups can be written to: ? Disk directory ? Media Management Library (tape device) – Typically used for disaster recovery, when disk backups are lost ? Flash recovery area – This is a disk area set aside for backup and recovery and flashback database purposes. – You define the location and the size. – Files are automatically named by using Oracle Managed Files. – Files are automatically retained and deleted as necessary. 9 Copyright 169。 2023, Oracle. All rights reserved. Backup and Recovery: Review The major backup and recovery–related topics covered in the Database Administration I Course are: ? Types of failure that can happen – Statement, session, instance, media, and so on ? How to configure ARCHIVELOG mode ? How to automate backups ? How to do incremental backups ? How to perform and tune instance recovery 3 Copyright 169。 2023 Oracle. All rights reserved. 2 Copyright 169。 2023, Oracle. All rights reserved. RMAN Repository Data Storage: Comparison of Options Control file: – Simpler administration – Default Recovery catalog: – Replicates control file data – Has room for more data – Can service many targets – Can store RMAN scripts Metadata Backup set list Image copy list . . . 8 Copyright 169。/u01/oracle/fra39。 2023, Oracle. All rights reserved. V$FLASH_RECOVERY_AREA_USAGE You can query V$FLASH_RECOVERY_AREA_USAGE to view the flash recovery area disk space usage. SQL SELECT file_type, 2 percent_space_used AS used, 3 percent_space_reclaimable AS reclaimable, 4 number_of_files AS number 5 FROM v$flash_recovery_area_usage 。 18 Copyright 169。 2023, Oracle. All rights reserved. Connection Types with RMAN Target database Recovery catalog DB Auxiliary database Recovery Manager 23 Copyright 169。 2023, Oracle. All rights reserved. Configuring RMAN Settings by Using EM 26 Copyright 169。 2023, Oracle. All rights reserved. Managing Persistent Settings ? Use the SHOW mand to list current set
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1