【正文】 , 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。 18 Copyright 169。 2023, Oracle. All rights reserved. Setting Parameters That Affect RMAN ? Database initialization parameters – CONTROL_FILE_RECORD_KEEP_TIME – DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE, if using the flash recovery area ? Environment variables – NLS_DATE_FORMAT – NLS_LANG 21 Copyright 169。 2023, Oracle. All rights reserved. Connection Types with RMAN Target database Recovery catalog DB Auxiliary database Recovery Manager 23 Copyright 169。 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. Configuring RMAN Settings by Using EM 26 Copyright 169。 Best practice: Oracle remends that you enable control file autobackup. 28 Copyright 169。 2023, Oracle. All rights reserved. Managing Persistent Settings ? Use the SHOW mand to list current settings: ? Use the CLEAR mand to reset any persistent setting to its default value: RMAN SHOW CONTROLFILE AUTOBACKUP FORMAT。 RMAN SHOW ALL。 RMAN CONFIGURE MAXSETSIZE CLEAR。 31 Copyright 169。 2023, Oracle. All rights reserved. Automatic and Manual Channel Allocation ? An automatic channel is one that is preconfigured and used for subsequent mands. To change the default device type for automatic channel allocation, use: ? A manually allocated channel is one that overrides the automatic channel setting. This channel overrides the automatic channel for this run block: RMAN CONFIGURE DEFAULT DEVICE TYPE TO sbt。 3 BACKUP DATAFILE 39。 4 } 33 Copyright 169。 RMAN CONFIGURE CHANNEL DEVICE TYPE DISK 2 MAXPIECESIZE 2G。/disk1/backups/%U39。 } 34 Copyright 169。 2023, Oracle. All rights reserved. Issuing Recovery Manager Commands ? Interactive client – Enter mands at RMAN prompt. – Use when performing analysis, or when running reports or stored scripts. ? Batch mode – Use with automated jobs. – Specify a mand file when starting RMAN. – Specify the log file name to capture session log. ? Pipe interface – Specify the PIPE mandline argument. – Use to municate data between sessions or between RMAN and an external application. 37 Copyright 169。 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。 4 DURATION 10:00 MINIMIZE LOAD 5 (DATABASE)。alter system archive log current39。 2023, Oracle. All rights reserved. RMAN Commands: Overview Target database REPORT LIST Catalog database Enterprise Manager RESTORE RECOVER FLASHBACK SPFILE BACKUP Control file Archived log files RMAN Catalog maintenance CROSSCHECK DELETE…EXPIRED CHANGE Stored scripts 41 Copyright 169。/BACKUP/df_%d_%s_%39。 Backup set Data file 1 Data file 2 Data file 3 Data file 1 Data file 2 Data file 3 Tablespace HR_DATA Commands BACKUP Block . Inc. Update LIST REPORT DELETE 42 Copyright 169。 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 f