rman备份恢复详解
- 格式:docx
- 大小:608.00 KB
- 文档页数:48
第一部分,认识rman
[root@director ~]# find / -name rman
/u01/oracle/10g/sysman/admin/scripts/db/rman
/u01/oracle/10g/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/perl/db/rman /u01/oracle/10g/oc4j/j2ee/oc4j_applications/applications/em/em/database/rman
/u01/oracle/10g/bin/rman
调整顺序的话就调整这个文件
[root@director ~]#
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/10g
export ORACLE_SID=TestDB
export PATH=$ORACLE_HOME/jdk/bin:$PATH
export PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin;
export PATH=$ORACLE_HOME/bin:$PATH;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
alias sqlplus='rlwrap sqlplus'
rman备份可以进行的前提条件是数据库必须处于归档模式
[oracle@director ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 20 04:50:02 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 3
Next log sequence to archive 5
Current log sequence 5
强制归档日志命令
SQL> a lter system archive log current;
System altered.
SQL> alter system switch logfile;
System altered.
SQL>
配置rman
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;设置保存策略CONFIGURE BACKUP OPTIMIZATION ON;设置为优化选项为on
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';设置备份介质
CONFIGURE CONTROLFILE AUTOBACKUP ON;设置自动备份控制文件
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
备份通道个数
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;磁盘通道个数
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS
'ENV=(OB_MEDIA_FAMILY=station21)' CONNECT 'sys/oracle1@orcl';设置媒介家庭
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS
'ENV=(OB_MEDIA_FAMILY=station21)' CONNECT 'sys/oracle1@orcl'; 设置媒介家庭
CONFIGURE MAXSETSIZE TO UNLIMITED; # default