【正文】 ea RMAN BACKUP RECOVERY FILES。 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。 RMAN CONFIGURE BACKUP OPTIMIZATION CLEAR。/u01/oradata/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。 7 } 39 Copyright 169。 2023, Oracle. All rights reserved. Compressed Backups RMAN BACKUP AS 2 COMPRESSED BACKUPSET 3 DATABASE。39。 3 ARCHIVELOG FROM SEQUENCE=234 4 DELETE INPUT。/mydir/39。 2023, Oracle. All rights reserved. LIST Command ? List backup sets and copies of data files: ? List backup sets and copies of any data file for a specified tablespace: ? List backup sets and copies containing archive logs for a specified range: RMAN LIST BACKUP OF DATAFILE 2 /db01/ORADATA/u03/。 2023, Oracle. All rights reserved. REPORT NEED BACKUP: Examples ? Files that need more than three incremental backups for recovery: ? Files that have not been backed up for three days: ? Backup needed if there are not two or more backups already: ? Backup needed to recover to three days ago: RMAN REPORT NEED BACKUP days 3。 RMAN DELETE OBSOLETE REDUNDANCY 2。 2023, Oracle. All rights reserved. Managing Backups with EM Navigation aid: Database home page Maintenance Manage Current Backups 66 Copyright 169。 RMAN REPORT NEED BACKUP redundancy 2。 RMAN LIST COPY OF TABLESPACE SYSTEM。 59 Copyright 169。 2023, Oracle. All rights reserved. Whole Database Backup RMAN BACKUP DATABASE PLUS ARCHIVELOG。39。 Compressed backup files Database files 46 Copyright 169。 2023, Oracle. All rights reserved. BACKUP Command RMAN BACKUP AS BACKUPSET 2 FORMAT 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。 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 CONFIGURE DEFAULT DEVICE TYPE CLEAR。 2023, Oracle. All rights reserved. Control File Autobackups RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON。 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。 DB_RECOVERY_FILE_DEST_SIZE = 2G 13 Copyright 169。 2023, Oracle. All rights reserved. Backup and Recovery: Review The major backup and recovery–related topics covered in the Database Administration I C