1:创建备份
修改备份策略
[oracle@oracle ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on 星期二 12月 24 17:39:23 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1362763236)
RMAN> show all
2> ;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default -----保留最后近一次备份,根据要求修改
CONFIGURE 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
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE 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
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; -------设置为ON,表示rman每次备份数据库时,同时备份controlfile
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/control/%F'; --路径
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/control/%F';
new RMAN configuration parameters are successfully stored
备份数据库
全备数据库脚本
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
allocate channel c5 device type disk;
crosscheck backup;
sql 'alter system archive log current';
backup database format '/u01/app/oracle/backup/data/db_%d_%T_%U';
sql 'alter system archive log current';
backup archivelog all format '/u01/app/oracle/backup/archivelog/arc_%t_%s' delete all input;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt obsolete;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
}
关于通道的设置,本文中设置了5个通道,请根据自己的实际情况进行设置,--通过设置过多会影响系统系能。
此次备份,备份了数据库的 datafile 、archivelog、controlfile、spfile,关于controlfile和spfile的备份,是有上面的策略决定( CONFIGURE CONTROLFILE AUTOBACKUP ON;),他将controlfile和spfile备份到control备份集中。
查看备份信息
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 1.03M DISK 00:00:01 2013-12-24 18:42:58
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20131224T184256
Piece Name: /u01/app/oracle/backup/data/db_ORCL_20131224_08osb9ph_1_1
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
4 Full 798228 2013-12-24 18:42:57 /u01/app/oracle/oradata/orcl/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6 Full 2.41M DISK 00:00:50 2013-12-24 18:43:47
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20131224T184256
Piece Name: /u01/app/oracle/backup/data/db_ORCL_20131224_07osb9ph_1_1
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
3 Full 798227 2013-12-24 18:42:57 /u01/app/oracle/oradata/orcl/undotbs01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Full 378.75M DISK 00:01:25 2013-12-24 18:44:21
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20131224T184256
Piece Name: /u01/app/oracle/backup/data/db_ORCL_20131224_06osb9pg_1_1
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
2 Full 798226 2013-12-24 18:42:57 /u01/app/oracle/oradata/orcl/sysaux01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
8 Full 586.55M DISK 00:01:34 2013-12-24 18:44:30
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20131224T184256
Piece Name: /u01/app/oracle/backup/data/db_ORCL_20131224_05osb9pg_1_1
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 798225 2013-12-24 18:42:56 /u01/app/oracle/oradata/orcl/system01.dbf
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
11 11.50K DISK 00:00:00 2013-12-24 18:44:35
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20131224T184435
Piece Name: /u01/app/oracle/backup/archivelog/arc_835037075_11
List of Archived Logs in backup set 11
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 75 798218 2013-12-24 18:42:56 798286 2013-12-24 18:44:34
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
12 2.00K DISK 00:00:00 2013-12-24 18:44:35
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20131224T184435
Piece Name: /u01/app/oracle/backup/archivelog/arc_835037075_12
List of Archived Logs in backup set 12
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 76 798286 2013-12-24 18:44:34 798294 2013-12-24 18:44:34
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
13 Full 9.36M DISK 00:00:01 2013-12-24 18:44:36
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20131224T184435
Piece Name: /u01/app/oracle/backup/control/c-1362763236-20131224-03
Control File Included: Ckp SCN: 798309 Ckp time: 2013-12-24 18:44:35
RMAN> list backup of spfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
13 Full 9.36M DISK 00:00:01 2013-12-24 18:44:36
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20131224T184435
Piece Name: /u01/app/oracle/backup/control/c-1362763236-20131224-03
SPFILE Included: Modification time: 2013-12-24 18:35:57
SPFILE db_unique_name: ORCL