12C RMAN 通过网络恢复还原数据

在12C中，可以通过网络从其他服务器的备份集中恢复数据库，数据文件，表空间，控制文件，参数文件。特别是在DG中，主库可以从备库恢复，且备库也可以从主库的备份集中恢复。
从standby_tns中还原users.dbf：
RESTORE DATAFILE '/oradata/files/users.dbf'
FROM SERVICE standby_tns
SECTION SIZE 200M
USING COMPRESSED BACKUPSET;
standby_tns为tnsnames中配置的备库的TNS

下面是在网上转载的整个实验过程：
[code]oracle@dbvlin603[/home/oracle]: rman
Recovery Manager: Release 12.1.0.1.0 - Production on Wed Jul 3 23:41:44 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target /
connected to target database: TESTDB (DBID=2602403303)

RMAN> select file#, name from v$datafile;

using target database control file instead of recovery catalog
FILE# NAME
---------- --------------------------------------------------------------------------------
1 +DATA/TESTDB/DATAFILE/system.258.819075077
3 +DATA/TESTDB/DATAFILE/sysaux.257.819075011
4 +DATA/TESTDB/DATAFILE/undotbs1.260.819075143
6 +DATA/TESTDB/DATAFILE/users.259.819075141

RMAN> alter database datafile 6 offline;

Statement processed

RMAN> restore datafile '+DATA/TESTDB/DATAFILE/users.259.819075141' from service testdbdr using compressed backupset;

Starting restore at 03/07/2013:23:46:38
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using compressed network backup set from service testdbdr
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00006 to +DATA/TESTDB/DATAFILE/users.259.819075141
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 03/07/2013:23:46:42

RMAN> select name, status from v$datafile;

NAME STATUS
---------------------------------------------- --------
+DATA/TESTDB/DATAFILE/system.258.819075077 SYSTEM
+DATA/TESTDB/DATAFILE/sysaux.257.819075011 ONLINE
+DATA/TESTDB/DATAFILE/undotbs1.260.819075143 ONLINE
+DATA/TESTDB/DATAFILE/users.259.819075141 RECOVER

RMAN> recover datafile 6;

Starting recover at 03/07/2013:23:47:14
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 5 is already on disk as file +FRA/TESTDB/ARCHIVELOG/2013_06_26/thread_1_seq_5.257.819151251
archived log for thread 1 with sequence 6 is already on disk as file +FRA/TESTDB/ARCHIVELOG/2013_06_26/thread_1_seq_6.258.819151417
archived log for thread 1 with sequence 7 is already on disk as file +FRA/TESTDB/ARCHIVELOG/2013_06_26/thread_1_seq_7.259.819156941
archived log for thread 1 with sequence 8 is already on disk as file +FRA/TESTDB/ARCHIVELOG/2013_06_28/thread_1_seq_8.260.819244859
archived log for thread 1 with sequence 9 is already on disk as file +FRA/TESTDB/ARCHIVELOG/2013_06_29/thread_1_seq_9.261.819352823
archived log for thread 1 with sequence 10 is already on disk as file +FRA/TESTDB/ARCHIVELOG/2013_06_29/thread_1_seq_10.262.819411105
archived log for thread 1 with sequence 11 is already on disk as file +FRA/TESTDB/ARCHIVELOG/2013_06_30/thread_1_seq_11.263.819468251
archived log for thread 1 with sequence 12 is already on disk as file +FRA/TESTDB/ARCHIVELOG/2013_07_01/thread_1_seq_12.264.819656061
archived log for thread 1 with sequence 13 is already on disk as file +FRA/TESTDB/ARCHIVELOG/2013_07_02/thread_1_seq_13.265.819756027
archived log for thread 1 with sequence 14 is already on disk as file +FRA/TESTDB/ARCHIVELOG/2013_07_03/thread_1_seq_14.266.819842455
archived log file name=+FRA/TESTDB/ARCHIVELOG/2013_06_26/thread_1_seq_5.257.819151251 thread=1 sequence=5
archived log file name=+FRA/TESTDB/ARCHIVELOG/2013_06_26/thread_1_seq_6.258.819151417 thread=1 sequence=6
archived log file name=+FRA/TESTDB/ARCHIVELOG/2013_06_26/thread_1_seq_7.259.819156941 thread=1 sequence=7
archived log file name=+FRA/TESTDB/ARCHIVELOG/2013_06_28/thread_1_seq_8.260.819244859 thread=1 sequence=8
archived log file name=+FRA/TESTDB/ARCHIVELOG/2013_06_29/thread_1_seq_9.261.819352823 thread=1 sequence=9
archived log file name=+FRA/TESTDB/ARCHIVELOG/2013_06_29/thread_1_seq_10.262.819411105 thread=1 sequence=10
archived log file name=+FRA/TESTDB/ARCHIVELOG/2013_06_30/thread_1_seq_11.263.819468251 thread=1 sequence=11
archived log file name=+FRA/TESTDB/ARCHIVELOG/2013_07_01/thread_1_seq_12.264.819656061 thread=1 sequence=12
media recovery complete, elapsed time: 00:00:15
Finished recover at 03/07/2013:23:47:36

RMAN> alter database datafile 6 online;

Statement processed[/code]