Objective
One: Backup and Recovery overview
II: Overview of RMAN Tools
1:rman components
1[Email protected] ~]$Rman Target System/nocatalog2 3Recovery manager:release 11.2.0.3.0-production on Tue Mar 27 23:58:10 20184 5Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.6 7Connected to target DATABASE:ORCL (dbid=1457025880)8 9Rman>Show AllTen2>; One AUsing target database control file instead of recovery catalog -RMAN configuration parameters for database with Db_unique_name ORCL is: -CONFIGURE RETENTION POLICY to redundancy 1; # Default theCONFIGURE BACKUP optimization OFF; # Default -CONFIGURE DEFAULT DEVICE TYPE to DISK; # Default -CONFIGURE controlfile autobackup OFF; # Default -CONFIGURE controlfile autobackup FORMAT for DEVICE TYPE DISK to '%F‘; # Default +CONFIGURE DEVICE type DISK PARALLELISM 1 BACKUP type to BACKUPSET; # Default -CONFIGURE datafile BACKUP COPIES for DEVICE TYPE DISK to 1; # Default +CONFIGURE ARCHIVELOG BACKUP COPIES for DEVICE TYPE DISK to 1; # Default ACONFIGURE maxsetsize to UNLIMITED; # Default atCONFIGURE encryption for DATABASE OFF; # Default -CONFIGURE encryption Algorithm 'AES128‘; # Default -CONFIGURE COMPRESSION Algorithm 'BASIC' As of RELEASE 'DEFAULT' OPTIMIZE for LOAD TRUE; # Default -CONFIGURE ARCHIVELOG deletion POLICY to NONE; # Default -CONFIGURE SNAPSHOT controlfile NAME to '/U01/APP/ORACLE/PRODUCT/11.2.0/DB_1/DBS/SNAPCF_ORCL.F‘; # Default - inRman>
- 3:rman Recovery Directory
- 4: Media Management Subsystem
- 5: Backing Up the database
- 6: Recovering the Catalog Database
2:rman Channel
- 1: Manually Assign channels
Example: Manually assigning a channel named Ch_1, whose file path is:/home/oracle/oracle_system_files_back/%u_%c.bak;
1 run{ 2 Allocate channel ch_1 device type disk 3 format = 'd:\oraclebf\%u_% C.bak'; 4 backup tablespace system,users,tbsp_1,ts_1 channel ch_1; 5 }
- 2: Automatic channel allocation
——————————————————————————————————————————————————————————————————————————————————
Oracle Data Backup and recovery