Oracle Data Backup and recovery

Source: Internet
Author: User





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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.