14配置和使用恢復(fù)管理器-文庫(kù)吧在線文庫(kù)
【正文】 EST and DB_RECOVERY_FILE_DEST_SIZE, if using the flash recovery area ? Environment variables – NLS_DATE_FORMAT – NLS_LANG 21 Copyright 169。 Best practice: Oracle remends that you enable control file autobackup. 28 Copyright 169。 31 Copyright 169。 RMAN CONFIGURE CHANNEL DEVICE TYPE DISK 2 MAXPIECESIZE 2G。 2023, Oracle. All rights reserved. Job Commands: Example Job mands appear inside a RUN mand block: RMAN RUN { 2 BACKUP AS BACKUPSET 3 FORMAT 39。/BACKUP/df_%d_%s_%39。 2023, Oracle. All rights reserved. Image Copy Copy of data file 3 Copy of archived log Data file 3 Archived log file Data file 3 Archived log file RMAN BACKUP AS COPY 2 DATAFILE 39。 48 Copyright 169。 Archived log file copies SPFILE Control file Data file copies 54 Copyright 169。 2023, Oracle. All rights reserved. Incrementally Updating Backups Incremental backup files Recovered data file Image copy of data file Image copy of data file updated to a more recent state RMAN RECOVER COPY OF 2 DATAFILE {n|39。 RMAN LIST COPY OF DATABASE ARCHIVELOG 2 FROM TIME=39。 RMAN REPORT NEED BACKUP 2 recovery window of 3 days。 2023, Oracle. All rights reserved. RMAN Dynamic Views ? V$ARCHIVED_LOG ? V$BACKUP_CORRUPTION ? V$BACKUP_DEVICE ? V$BACKUP_FILES ? V$BACKUP_PIECE ? V$BACKUP_REDOLOG ? V$BACKUP_SET ? V$BACKUP_SPFILE ? V$COPY_CORRUPTION ? V$RMAN_CONFIGURATION 68 Copyright 169。 RMAN DELETE BACKUPSET 4。 2023, Oracle. All rights reserved. REPORT NEED BACKUP Command ? Lists all data files that require a backup ? Assumes that the most recent backup is used during a restore ? Provides four options: – Incremental – Days – Redundancy – Recovery window ? Uses the current retention policy configuration if no options are specified 63 Copyright 169。 Commands BACKUP Block . Inc. Update LIST REPORT DELETE 60 Copyright 169。 2023, Oracle. All rights reserved. Enabling Block Change Tracking SQL ALTER DATABASE ENABLE 2 BLOCK CHANGE TRACKING 3 USING FILE 39。/disk1/backup/ar_%t_%s_%p39。 RMAN BACKUP AS COPY 4 ARCHIVELOG LIKE 39。 2023, Oracle. All rights reserved. Parallelization of Backup Sets For performance, allocate multiple channels and assign files to specific channels. Data file 4 Data file 1 Data file 5 Channel MML Backup piece 1 Backup piece 2 Data file 2 Data file 3 Data file 9 Channel MML Data file 6 Data file 7 Data file 8 Backup Piece 3 Channel MML 45 Copyright 169。alter system archive log current39。 } 34 Copyright 169。 3 BACKUP DATAFILE 39。 RMAN SHOW ALL。 export ORACLE_SID $ rman target / rman target sys/passwordDB01 Windows NT: C:\ set ORACLE_SID=DB01 C:\ rman target / 24 Copyright 169。 2023, Oracle. All rights reserved. V$FLASH_RECOVERY_AREA_USAGE Output from the V$FLASH_RECOVERY_AREA_USAGE query FILE_TYPE USED RECLAIMABLE FILES CONTROLFILE 0 0 0 ONLINELOG 0 0 0 ARCHIVELOG 0 593 BACKUPPIECE 0 0 0 IMAGECOPY 0 0 0 FLASHBACKLOG 0 37 17 Copyright 169。 2023, Oracle. All rights reserved. Media Management Recovery Manager Media management server software Media management library Server session (channel) Oracle Secure Backup with builtin MML Or 11 Copyright 169。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. Backing Up the Flash Recovery Ar
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1