免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1728 | 回复: 2
打印 上一主题 下一主题

请教一下这个备份脚本对应的恢复应该是怎么样的? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2007-02-13 19:54 |只看该作者 |倒序浏览
connect / as sysdba;
alter tablespace system begin backup;
host copy D:\Oracle\oradata\oradb\system01.dbf h:\hotbackup\%backup_dir%\system01.bak;
alter tablespace system end backup;

alter tablespace data begin backup;
host copy D:\Oracle\oradata\oradb\data01.dbf h:\hotbackup\%backup_dir%\data01.bak;
alter tablespace data end backup;

alter tablespace indx begin backup;
host copy D:\Oracle\oradata\oradb\indx01.dbf h:\hotbackup\%backup_dir%\indx01.bak;
alter tablespace indx end backup;

alter tablespace rbs begin backup;
host copy D:\Oracle\oradata\oradb\rbs01.dbf h:\hotbackup\%backup_dir%\rbs01.bak;
alter tablespace rbs end backup;

alter tablespace tools begin backup;
host copy D:\Oracle\oradata\oradb\tools01.dbf h:\hotbackup\%backup_dir%\tools01.bak;
alter tablespace tools end backup;

alter tablespace drsys begin backup;
host copy D:\Oracle\oradata\oradb\dr01.dbf h:\hotbackup\%backup_dir%\dr01.bak;
alter tablespace drsys end backup;

alter tablespace users begin backup;
host copy D:\Oracle\oradata\oradb\users01.dbf h:\hotbackup\%backup_dir%\users01.bak;
alter tablespace users end backup;

alter tablespace temp begin backup;
host copy G:\temp01.dbf h:\hotbackup\%backup_dir%\temp01.bak;
alter tablespace temp end backup;

alter tablespace users2 begin backup;
host copy D:\Oracle\oradata\oradb\users2_1.dbf h:\hotbackup\%backup_dir%\users2_1.bak;
alter tablespace users2 end backup;

alter tablespace perfstat begin backup;
host copy D:\Oracle\oradata\oradb\perfstat.dbf h:\hotbackup\%backup_dir%\perfstat.bak;
alter tablespace perfstat end backup;

alter tablespace indx2 begin backup;
host copy D:\Oracle\oradata\oradb\indx2_01.dbf h:\hotbackup\%backup_dir%\indx2_01.bak;
alter tablespace indx2 end backup;

alter system archive log current;
host copy D:\Oracle\oradata\oradb\archive\*.arc h:\hotbackup\%backup_dir%\archbackup\;

alter database backup controlfile to 'h:\hotbackup\ctrlfile.bak';
host copy h:\hotbackup\ctrlfile.bak h:\hotbackup\%backup_dir%\ctrlfile.bak;
host del h:\hotbackup\ctrlfile.bak;
alter database backup controlfile to trace;

alter system archive log current;


exit;

论坛徽章:
0
2 [报告]
发表于 2007-02-14 10:33 |只看该作者
用rman 吧……

论坛徽章:
0
3 [报告]
发表于 2007-02-14 11:15 |只看该作者
请教一下,
我备份了控制文件,数据文件,按上述脚本,但是没有备份重做日志,也有归档日志
恢复的时候总是需要的归档日志的序列号加1,应该是重做日志的序列,
是不是说恢复就必须要有重做日志
或者说按上述方式备份,还必须备份重做日志?
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP