Oracle Data Backup and recovery

Objective

One: Backup and Recovery overview

II: Overview of RMAN Tools

1:rman components

• 1:rman Command Actuator

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>

• 2: Target Database

• 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