用10.2.0.1RMAN全备恢复10.2.0.4数据库,通过

用10.2.0.1RMAN全备恢复10.2.0.4数据库,通过RESTOREBACKUPPIECE,APPLYBACKUPPIECE解决

1.升级备份服务器的数据库到10.2.0.4

2.通过FTP把生产数据库(10.2.0.1 RAC)的RMAN的full backupset全部copy 到备份数据库上。

3.rman target / nocatalog

4.startup nomount

5.restore controlfile from 'file_path';(从生产库考过来那个控制文件的backupset);

6.检查RMAN的配置信息:
$ rman target / nocatalog
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jun 20 16:45:40 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: BAAN (DBID=3872779959, not open)
using target database control file instead of recovery catalog
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/RAC_BACKUP/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/RAC_BACKUP/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/ora/app/oracle/oracle/product/10.2.0/db_1/dbs/snapcf_baan.f'; # default
[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10748419/viewspace-1009365/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/10748419/viewspace-1009365/

  • 0
    点赞
  • 0
    收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
©️2022 CSDN 皮肤主题:编程工作室 设计师:CSDN官方博客 返回首页
评论
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值