Oracle 資料備份與恢複

標籤：file   bak   執行器   cte   connected   tps   ora   ram   inline   

前言

一：備份與恢複概述

二：RMAN 工具概述

1： RMAN 組件

•        1： RMAN命令執行器

  1 [[email protected] ~]$ rman target system/nocatalog  2   3 Recovery Manager: Release 11.2.0.3.0 - Production on Tue Mar 27 23:58:10 2018  4   5 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.  6   7 connected to target database: ORCL (DBID=1457025880)  8   9 RMAN> show all 10 2> ; 11  12 using target database control file instead of recovery catalog 13 RMAN configuration parameters for database with db_unique_name ORCL are: 14 CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default 15 CONFIGURE BACKUP OPTIMIZATION OFF; # default 16 CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default 17 CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default 18 CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F‘; # default 19 CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default 20 CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default 21 CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default 22 CONFIGURE MAXSETSIZE TO UNLIMITED; # default 23 CONFIGURE ENCRYPTION FOR DATABASE OFF; # default 24 CONFIGURE ENCRYPTION ALGORITHM ‘AES128‘; # default 25 CONFIGURE COMPRESSION ALGORITHM ‘BASIC‘ AS OF RELEASE ‘DEFAULT‘ OPTIMIZE FOR LOAD TRUE ; # default 26 CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default 27 CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl.f‘; # default 28  29 RMAN>

•        2：目標資料庫

•        3：RMAN恢複目錄

•        4：介質管理子系統

•       5：備份資料庫

•       6：恢複目錄資料庫

2：RMAN 通道

•        1 ：手動分配通道

                   樣本：手動分配一個名稱為 ch_1的通道，其檔案路徑為：/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：自動分配通道

——————————————————————————————————————————————————————————————————————————————————

Oracle 資料備份與恢複