ITPub博客

首页 > 数据库 > 数据库开发技术 > 用10.2.0.1RMAN全备恢复10.2.0.4数据库,通过

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

原创 数据库开发技术 作者:gugu99 时间:2008-08-23 08:39:25 0 删除 编辑
用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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论
  • 博文量
    3122
  • 访问量
    2226302