14配置和使用恢復(fù)管理器-文庫吧
2024-12-24 03:28 本頁面
【正文】 FLASHBACKLOG 0 37 17 Copyright 169。 2023, Oracle. All rights reserved. Backing Up the Flash Recovery Area RMAN BACKUP RECOVERY FILES。 18 Copyright 169。 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。 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. 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. Connection Types with RMAN Target database Recovery catalog DB Auxiliary database Recovery Manager 23 Copyright 169。 2023, Oracle. All rights reserved. Starting RMAN ? Starting RMAN locally ? Starting RMAN remotely UNIX: $ ORACLE_SID=DB01。 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. 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. Configuring RMAN Settings by Using EM 26 Copyright 169。 2023, Oracle. All rights reserved. Control File Autobackups RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON。 Best practice: Oracle remends that you enable control file autobackup. 28 Copyright 169。 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. 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 EXCLUDE。 RMAN SHOW ALL。 RMAN CONFIGURE BACKUP OPTIMIZATION CLEAR。 RMAN CONFIGURE MAXSETSIZE CLEAR。 RMAN CONFIGURE DEFAULT DEVICE TYPE CLEAR。 31 Copyright 169。 2023, Oracle. All rights reserved. Channel Allocation Channel (DISK) BACKUP RESTORE RECOVER Server session Server session Target database Channel (SBT) RMAN 32 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 ove
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1