【RMAN】单实例环境RMAN备份和还原

一 实验环境

SQL> column product for a50
SQL> column version for a15
SQL> column status for a20
SQL> select * from product_component_version;

PRODUCT 					   VERSION	   STATUS
-------------------------------------------------- --------------- --------------------
NLSRTL						   11.2.0.4.0	   Production
Oracle Database 11g Enterprise Edition		   11.2.0.4.0	   64bit Production
PL/SQL						   11.2.0.4.0	   Production
TNS for Linux:					   11.2.0.4.0	   Production

二 备份数据库

1 全备数据库

[oracle@strong ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jun 4 17:23:32 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1502844793)

RMAN> backup database plus archivelog; #备份整库以及归档日志


Starting backup at 04-JUN-18
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=32 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=2 RECID=132 STAMP=977937115
input archived log thread=1 sequence=3 RECID=133 STAMP=977937824
channel ORA_DISK_1: starting piece 1 at 04-JUN-18
channel ORA_DISK_1: finished piece 1 at 04-JUN-18
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_06_04/o1_mf_annnn_TAG20180604T172345_fkb191oo_.bkp tag=TAG20180604T172345 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 04-JUN-18

Starting backup at 04-JUN-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/orcl/users02.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/orcl/test01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/orcl/maintain01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 04-JUN-18
channel ORA_DISK_1: finished piece 1 at 04-JUN-18
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_06_04/o1_mf_nnndf_TAG20180604T172346_fkb1939b_.bkp tag=TAG20180604T172346 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:05:48
Finished backup at 04-JUN-18

Starting backup at 04-JUN-18
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=134 STAMP=977938176
channel ORA_DISK_1: starting piece 1 at 04-JUN-18
channel ORA_DISK_1: finished piece 1 at 04-JUN-18
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_06_04/o1_mf_annnn_TAG20180604T172936_fkb1n12c_.bkp tag=TAG20180604T172936 comment=