用RMAN恢复RAC到单实例过程

用RMAN恢复RAC到单实例过程

1、用rman备份生产库
-==注意：SEQUENCE、THREAD值的设置

D:\>rman nocatalog

Recovery Manager: Release 10.2.0.3.0 - Production on Mon Apr 12 14:44:57 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> connect target sys/zboracle12@zboracle1

connected to target database: ZBORACLE (DBID=3725316683)
using target database control file instead of recovery catalog

RMAN> run{
2> backup database format='D:\dump_dir\%U';
3> sql 'alter system archive log current';
4> backup archivelog SEQUENCE=2500 THREAD=1 format='D:\dump_dir\%U';
5> backup archivelog SEQUENCE=1898 THREAD=2 format='D:\dump_dir\%U';
6> }

Starting backup at 12-APR-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=123 instance=zboracle1 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=91 instance=zboracle1 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=+ORADISKGRP1/zboracle/datafile/mesapp_data.dbf
input datafile fno=00003 name=+ORADISKGRP1/zboracle/datafile/sysaux.285.683136853
input datafile fno=00005 name=+ORADISKGRP1/zboracle/datafile/undotbs2.289.683136937
input datafile fno=00002 name=+ORADISKGRP1/zboracle/datafile/undotbs1.266.683136853
channel ORA_DISK_1: starting piece 1 at 12-APR-10
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00008 name=+ORADISKGRP1/zboracle/datafile/ppms_data.dbf
input datafile fno=00001 name=+ORADISKGRP1/zboracle/datafile/system.294.683136853
input datafile fno=00007 name=+ORADISKGRP1/zboracle/datafile/mesapp_index.dbf
input datafile fno=00004 name=+ORADISKGRP1/zboracle/datafile/users.260.683136853

channel ORA_DISK_2: starting piece 1 at 12-APR-10
channel ORA_DISK_2: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\A0LAUOP9_1_1 tag=TAG20100412T150057 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:36
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_2: starting piece 1 at 12-APR-10
channel ORA_DISK_2: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\A1LAUOQD_1_1 tag=TAG20100412T150057 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:05
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_2: starting piece 1 at 12-APR-10
channel ORA_DISK_2: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\A2LAUOQI_1_1 tag=TAG20100412T150057 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\9VLAUOP9_1_1 tag=TAG20100412T150057 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:50
Finished backup at 12-APR-10

sql statement: alter system archive log current

Starting backup at 12-APR-10
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2500 recid=4500 stamp=716137309
channel ORA_DISK_1: starting piece 1 at 12-APR-10
channel ORA_DISK_1: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\A3LAUOR8_1_1 tag=TAG20100412T150200 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 12-APR-10

Starting backup at 12-APR-10
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=2 sequence=1898 recid=4501 stamp=716137269
channel ORA_DISK_1: starting piece 1 at 12-APR-10
channel ORA_DISK_1: finished piece 1 at 12-APR-10
piece handle=D:\DUMP_DIR\A4LAUORC_1_1 tag=TAG20100412T150204 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 12-APR-10

RMAN>

2、复制备份集到目标库

cp xxx  xxx
3、还原目标库
3.1 还原controlfile

C:\Documents and Settings\Administra