Oracle物理容灾,Oracle备与容灾详解.pptx

Oracle备与容灾详解

Oracle 数据安全;01;一. 为什么要进行备份和容灾？;一.为什么要进行备份和容灾？;二. 备份和容灾概况;2.1 区分物理备份和逻辑备份;2.2.1 什么是冷备份？数据库没有打开的情况下，使用操作系统命令或rman进行备份，由于数据库没有打开，数据库的数据是干净一致的，不存在活动事务。方式：使用操作系统命令直接复制数据文件到另外一个目录即可，windows下直接复制粘贴，其他平台如linux下：cp ;三. rman物理备份;三. rman物理备份;[oracle@db ~]$ rman target / --使用rman登录数据库connected to target database: TESTDB (DBID=2592324560)RMAN> backup database format '/backup/fullbak_%U';Starting backup at 2013/09/05 09:23:00using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=145 devtype=DISKchannel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=/u01/app/oracle/oradata/testdb/system.dbfinput datafile fno=00003 name=/u01/app/oracle/oradata/testdb/sysaux.dbfinput datafile fno=00004 name=/u01/app/oracle/oradata/testdb/users.dbf… channel ORA_DISK_1: starting piece 1 at 2013/09/05 09:23:01channel ORA_DISK_1: finished piece 1 at 2013/09/05 09:24:07piece handle=/backup/fullbak_05oj2uvl_1_1 tag=TA092301 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:06channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current control file in backupsetincluding current SPFILE in backupsetchannel ORA_DISK_1: starting piece 1 at 2013/09/05 09:24:10channel ORA_DISK_1: finished piece 1 at 2013/09/05 09:24:11piece handle=/backup/fullbak_06oj2v1n_1_1 tag=TA092301 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:04Finished backup at 2013/09/05 09:24:11;可以看出备份全库时包括两部分：一个数据文件的备份集，其中包括了所有的数据文件，一个控制文件+spfile的备份集，包括了控制文件和spfile ;2.假设此时磁盘发生损坏，并强制关闭了数据库;3.恢复控制文件;4.恢复数据文件包括两步：restore、recover;RMAN> recover database;

Starting recover at 2013/09/05 12:53:46using channel ORA_DISK_1

starting media recovery

archive log filename=/u01/app/oracle/arch/1_17_823348175.dbf thread=1 sequence=17archive log filename=/u01/app/