用10.2.0.1RMAN全備恢復10.2.0.4資料庫,透過

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