rman恢復時跳過資料檔案，進行恢復

http://www.cnblogs.com/lijunjie/archive/2010/09/27/1836517.html

如果備份是在mount下進行的話，並且，沒有open就執行恢復。那rman會跳過所有資料檔案，不執行恢復
RMAN> run {
2> allocate channel c1 type disk;
allocate channel c2 type disk;
3> 4> allocate channel c3 type disk;
5> allocate channel c4 type disk;
6> restore database from tag= TAG20120413T104943;
7> release channel c1;
8> release channel c2;
9> release channel c3;
10> release channel c4;
11> }

released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=2753 instance=ZKFP1 device type=DISK

allocated channel: c2
channel c2: SID=1832 instance=ZKFP1 device type=DISK

allocated channel: c3
channel c3: SID=919 instance=ZKFP1 device type=DISK

allocated channel: c4
channel c4: SID=2752 instance=ZKFP1 device type=DISK

Starting restore at 13-APR-12

skipping datafile 6; already restored to file +DATA_ZKF/pmszkfdb/datafile/undotbs1.268.762623781
skipping datafile 7; already restored to file +DATA_ZKF/pmszkfdb/datafile/undotbs2.269.762623783
skipping datafile 16; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfdata106.dbf
skipping datafile 17; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfdata107.dbf
skipping datafile 19; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfindex104.dbf
skipping datafile 22; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfindex107.dbf
skipping datafile 24; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprddata101.dbf
skipping datafile 29; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprddata106.dbf
skipping datafile 34; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprdindex103.dbf
skipping datafile 38; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprdindex107.dbf
skipping datafile 3; already restored to file +DATA_ZKF/pmszkfdb/datafile/undotbs1.284.762623815
skipping datafile 5; already restored to file +DATA_ZKF/pmszkfdb/datafile/users.295.762623945
skipping datafile 9; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfindex101.dbf
skipping datafile 10; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfdata102.dbf
skipping datafile 12; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfindex102.dbf
skipping datafile 13; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfindex103.dbf
skipping datafile 15; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfdata105.dbf
skipping datafile 26; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprddata103.dbf
skipping datafile 35; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprdindex104.dbf
skipping datafile 39; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprdindex108.dbf
skipping datafile 1; already restored to file +DATA_ZKF/pmszkfdb/datafile/system.276.762623799
skipping datafile 4; already restored to file +DATA_ZKF/pmszkfdb/datafile/undotbs2.277.762623801
skipping datafile 8; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfdata101.dbf
skipping datafile 14; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfdata104.dbf
skipping datafile 20; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfindex105.dbf
skipping datafile 23; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfindex108.dbf
skipping datafile 25; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprddata102.dbf
skipping datafile 28; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprddata105.dbf
skipping datafile 33; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprdindex102.dbf
skipping datafile 37; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprdindex106.dbf
skipping datafile 2; already restored to file +DATA_ZKF/pmszkfdb/datafile/sysaux.260.762623769
skipping datafile 11; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfdata103.dbf
skipping datafile 18; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfdata108.dbf
skipping datafile 21; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfindex106.dbf
skipping datafile 27; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprddata104.dbf
skipping datafile 30; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprddata107.dbf
skipping datafile 31; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprddata108.dbf
skipping datafile 32; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprdindex101.dbf
skipping datafile 36; already restored to file +DATA_ZKF/pmszkfdb/datafile/zkfprdindex105.dbf
restore not done; all files read only, offline, or already restored
Finished restore at 13-APR-12

released channel: c1

released channel: c2

released channel: c3

released channel: c4

如果備份是在mount下進行的話，並open了，那rman就會恢復：
$ rman target /

Recovery Manager: Release 11.1.0.6.0 - Production on Fri Apr 13 11:29:24 2012

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

connected to target database: PMSZKFDB (not mounted)

RMAN>  restore controlfile from '/mnt/ZKFP:79:780491556:1.ctl';

Starting restore at 13-APR-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2753 instance=ZKFP1 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output file name=+DATA_ZKF/pmszkfdb/controlfile/current.256.762623019
output file name=+DATA_ZKF/pmszkfdb/controlfile/current.257.762623019
Finished restore at 13-APR-12

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> run {
2> allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
3> 4> 5> allocate channel c4 type disk;
6> restore database from tag= TAG20120413T104943;
7> release channel c1;
8> release channel c2;
9> release channel c3;
10> release channel c4;
11> }

allocated channel: c1
channel c1: SID=1831 instance=ZKFP1 device type=DISK

allocated channel: c2
channel c2: SID=2753 instance=ZKFP1 device type=DISK

allocated channel: c3
channel c3: SID=893 instance=ZKFP1 device type=DISK

allocated channel: c4
channel c4: SID=1830 instance=ZKFP1 device type=DISK

Starting restore at 13-APR-12
Starting implicit crosscheck backup at 13-APR-12
Crosschecked 7 objects
Finished implicit crosscheck backup at 13-APR-12

Starting implicit crosscheck copy at 13-APR-12
Crosschecked 4 objects
Finished implicit crosscheck copy at 13-APR-12

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: +data_zkf/PMSZKFDB/ARCHIVELOG/2012_04_13/thread_1_seq_1.441.780492201
File Name: +data_zkf/PMSZKFDB/ARCHIVELOG/2012_04_13/thread_1_seq_2.442.780492201
File Name: +data_zkf/PMSZKFDB/ARCHIVELOG/2012_04_13/thread_2_seq_1.443.780492201
File Name: +data_zkf/PMSZKFDB/ARCHIVELOG/2012_04_13/thread_2_seq_2.444.780492201
File Name: +data_zkf/PMSZKFDB/ARCHIVELOG/2012_04_13/thread_2_seq_3.445.780492201
File Name: +data_zkf/PMSZKFDB/ARCHIVELOG/2012_04_13/thread_2_seq_1.446.780492271

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00006 to +DATA_ZKF/pmszkfdb/datafile/undotbs1.268.762623781
channel c1: restoring datafile 00007 to +DATA_ZKF/pmszkfdb/datafile/undotbs2.269.762623783
channel c1: restoring datafile 00016 to +DATA_ZKF/pmszkfdb/datafile/zkfdata106.dbf
channel c1: restoring datafile 00017 to +DATA_ZKF/pmszkfdb/datafile/zkfdata107.dbf
channel c1: restoring datafile 00019 to +DATA_ZKF/pmszkfdb/datafile/zkfindex104.dbf
channel c1: restoring datafile 00022 to +DATA_ZKF/pmszkfdb/datafile/zkfindex107.dbf
channel c1: restoring datafile 00024 to +DATA_ZKF/pmszkfdb/datafile/zkfprddata101.dbf
channel c1: restoring datafile 00029 to +DATA_ZKF/pmszkfdb/datafile/zkfprddata106.dbf
channel c1: restoring datafile 00034 to +DATA_ZKF/pmszkfdb/datafile/zkfprdindex103.dbf
channel c1: restoring datafile 00038 to +DATA_ZKF/pmszkfdb/datafile/zkfprdindex107.dbf
channel c1: reading from backup piece /mnt/ZKFP:74:7804901921.bak
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00003 to +DATA_ZKF/pmszkfdb/datafile/undotbs1.284.762623815
channel c2: restoring datafile 00005 to +DATA_ZKF/pmszkfdb/datafile/users.295.762623945
channel c2: restoring datafile 00009 to +DATA_ZKF/pmszkfdb/datafile/zkfindex101.dbf
channel c2: restoring datafile 00010 to +DATA_ZKF/pmszkfdb/datafile/zkfdata102.dbf
channel c2: restoring datafile 00012 to +DATA_ZKF/pmszkfdb/datafile/zkfindex102.dbf
channel c2: restoring datafile 00013 to +DATA_ZKF/pmszkfdb/datafile/zkfindex103.dbf
channel c2: restoring datafile 00015 to +DATA_ZKF/pmszkfdb/datafile/zkfdata105.dbf
channel c2: restoring datafile 00026 to +DATA_ZKF/pmszkfdb/datafile/zkfprddata103.dbf
channel c2: restoring datafile 00035 to +DATA_ZKF/pmszkfdb/datafile/zkfprdindex104.dbf
channel c2: restoring datafile 00039 to +DATA_ZKF/pmszkfdb/datafile/zkfprdindex108.dbf
channel c2: reading from backup piece /mnt/ZKFP:76:7804902061.bak
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00001 to +DATA_ZKF/pmszkfdb/datafile/system.276.762623799
channel c3: restoring datafile 00004 to +DATA_ZKF/pmszkfdb/datafile/undotbs2.277.762623801
channel c3: restoring datafile 00008 to +DATA_ZKF/pmszkfdb/datafile/zkfdata101.dbf
channel c3: restoring datafile 00014 to +DATA_ZKF/pmszkfdb/datafile/zkfdata104.dbf
channel c3: restoring datafile 00020 to +DATA_ZKF/pmszkfdb/datafile/zkfindex105.dbf
channel c3: restoring datafile 00023 to +DATA_ZKF/pmszkfdb/datafile/zkfindex108.dbf
channel c3: restoring datafile 00025 to +DATA_ZKF/pmszkfdb/datafile/zkfprddata102.dbf
channel c3: restoring datafile 00028 to +DATA_ZKF/pmszkfdb/datafile/zkfprddata105.dbf
channel c3: restoring datafile 00033 to +DATA_ZKF/pmszkfdb/datafile/zkfprdindex102.dbf
channel c3: restoring datafile 00037 to +DATA_ZKF/pmszkfdb/datafile/zkfprdindex106.dbf
channel c3: reading from backup piece /mnt/ZKFP:73:7804901851.bak
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00002 to +DATA_ZKF/pmszkfdb/datafile/sysaux.260.762623769
channel c4: restoring datafile 00011 to +DATA_ZKF/pmszkfdb/datafile/zkfdata103.dbf
channel c4: restoring datafile 00018 to +DATA_ZKF/pmszkfdb/datafile/zkfdata108.dbf
channel c4: restoring datafile 00021 to +DATA_ZKF/pmszkfdb/datafile/zkfindex106.dbf
channel c4: restoring datafile 00027 to +DATA_ZKF/pmszkfdb/datafile/zkfprddata104.dbf
channel c4: restoring datafile 00030 to +DATA_ZKF/pmszkfdb/datafile/zkfprddata107.dbf
channel c4: restoring datafile 00031 to +DATA_ZKF/pmszkfdb/datafile/zkfprddata108.dbf
channel c4: restoring datafile 00032 to +DATA_ZKF/pmszkfdb/datafile/zkfprdindex101.dbf
channel c4: restoring datafile 00036 to +DATA_ZKF/pmszkfdb/datafile/zkfprdindex105.dbf
channel c4: reading from backup piece /mnt/ZKFP:75:7804901991.bak
channel c1: piece handle=/mnt/ZKFP:74:7804901921.bak tag=TAG20120413T104943
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:20:07
channel c2: piece handle=/mnt/ZKFP:76:7804902061.bak tag=TAG20120413T104943
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:20:57
channel c3: piece handle=/mnt/ZKFP:73:7804901851.bak tag=TAG20120413T104943
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:22:07
channel c4: piece handle=/mnt/ZKFP:75:7804901991.bak tag=TAG20120413T104943
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:22:36
Finished restore at 13-APR-12

released channel: c1

released channel: c2

released channel: c3

released channel: c4

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24500180/viewspace-721388/，如需轉載，請註明出處，否則將追究法律責任。