oracle备份与恢复总结.docx
- 文档编号:10784951
- 上传时间:2023-02-22
- 格式:DOCX
- 页数:144
- 大小:77.21KB
oracle备份与恢复总结.docx
《oracle备份与恢复总结.docx》由会员分享,可在线阅读,更多相关《oracle备份与恢复总结.docx(144页珍藏版)》请在冰豆网上搜索。
oracle备份与恢复总结
Oracle数据库备份与恢复总结
作者
绪安庆
审核
分类
oracle
别类
更新时间
2018年10月11日
关键字
Oracle,backup,restore。
摘要
Oracle数据库备份与恢复总结。
主要适用环境
Oracle9I,RAC
版本说明
版本
日期
内容
编写人
V1.0
2011-8-7
报告初稿
绪安庆
目录
1.EXP/IMP(导出与导入装库与卸库)...........................................................................................6
1.1基本命令................................................................................................................................6
1.获取帮助..............................................................................................................................6
2.三种工作方式.......................................................................................................................6
3.三种模式..............................................................................................................................7
1.2高级选项................................................................................................................................7
1.分割成多个文件...................................................................................................................7
2.增量导出/导入......................................................................................................................8
3.以SYSDBA进行导出/导入..................................................................................................8
4.表空间传输(速度快)...........................................................................................................8
1.3优化.....................................................................................................................................10
1.加快exp速度.....................................................................................................................10
2.加快imp速度.....................................................................................................................10
3.通过unix/LinuxPIPE管道加快exp/imp速度..................................................................10
4.全库导入的一般步骤.........................................................................................................12
1.4常见问题...............................................................................................................................12
1.字符集问题.........................................................................................................................12
2.版本问题............................................................................................................................13
2.SQL*LOADER..........................................................................................................................14
2.1基本知识...............................................................................................................................14
1.命令格式...........................................................................................................................14
2.控制文件...........................................................................................................................14
3.数据文件...........................................................................................................................15
4.坏文件...............................................................................................................................16
5.日志文件及日志信息.........................................................................................................16
2.2高级选项...............................................................................................................................16
1.ConventionalPathLoad与DirectPathLoad....................................................................16
2.SPOOL导出文本数据方法.................................................................................................16
2.3脚本......................................................................................................................................17
1.将表中数据记录导出为字段值用分隔符'|'分开的.dat文件..............................................17
2.将数据导入到相应表中......................................................................................................18
3.OS备份/用户管理的备份与恢复(USERMANAGEDBACKUPANDRECOVERY)..............20
3.1相关设置...............................................................................................................................20
3.1.1设置ARCHIVELOG与NONARCHIVELOG模式......................................................20
3.1.2LOGGING与NOLOGGING........................................................................................21
3.1.3归档路径........................................................................................................................21
3.2NONARCHIVELOG模式.....................................................................................................22
3.2.1脱机冷备与恢复............................................................................................................22
3.2.2案例...............................................................................................................................22
3.3ARCHIVELOG模式..............................................................................................................26
3.3.1脱机冷备与恢复............................................................................................................26
3.3.2联机热备........................................................................................................................27
3.3.3联机热备的恢复............................................................................................................30
3.3.3.1完全恢复................................................................................................................................30
3.3.3.2不完全恢复.............................................................................................................................30
3.4分类案例...............................................................................................................................31
3.4.1控件文件的备份与恢复.................................................................................................31
3.4.2联机日志文件的备份与恢复.........................................................................................32
3.4.3回滚数据文件的恢复.....................................................................................................32
3.4.5临时数据文件的恢复.....................................................................................................33
4.RMAN(备份与恢复管理器)........................................................................................................34
4.1基本知识...............................................................................................................................34
4.1.1RMAN的组件、概念.....................................................................................................34
4.1.2RMAN的使用:
命令行接口与脚本..............................................................................36
1.使用不带恢复目录的RMAN........................................................................................................36
2.使用带恢复目录的RMAN............................................................................................................36
3.命令行接口...................................................................................................................................36
4.使用脚本.......................................................................................................................................37
5.运行OS命令................................................................................................................................37
6.执行SQL语句..............................................................................................................................37
4.2RMAN的配置.......................................................................................................................38
4.2.1建立RecoveryCatalog恢复目录...................................................................................38
4.2.2查看RMAN的默认设置SHOW命令..........................................................................38
4.2.3配置RMAN的默认设置...............................................................................................38
1.配置备份集文件的格式(format)..................................................................................................38
2.配置默认IO设备类型(devicetype)........................................................................................39
3.配置自动分配的通道(Chanel).................................................................................................39
4.配置默认的保存策略(RetentionPolicy).....................................................................................39
5.配置多个备份的拷贝数目(backupcopies)..................................................................................40
6.设置并行备份(ARALLELISM)...................................................................................................40
7.设置控制文件自动备份(autobackupon).....................................................................................40
8.设置备份优化选项(optimization)..............................................................................................41
4.2.4RMAN会话的设置........................................................................................................41
4.3COPY镜像拷贝与恢复...........................................................................................................41
4.3.1备份...............................................................................................................................42
4.3.2恢复...............................................................................................................................42
4.4BACKUP备份与恢复..............................................................................................................43
4.4.1BACKUP备份命令选项...........................................................
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- oracle 备份 恢复 总结