用rman全库备份,包括归档归档日志文件备份,控制文件与参数文件自动备份:
[oracle@oracle ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 16 17:22:56 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA11GR2 (DBID=238796283)
RMAN> backup database plus archivelog;
Starting backup at 16-OCT-16
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=44 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=59 RECID=37 STAMP=924897627
input archived log thread=1 sequence=60 RECID=38 STAMP=924968778
input archived log thread=1 sequence=61 RECID=39 STAMP=925156048
input archived log thread=1 sequence=62 RECID=40 STAMP=925157378
input archived log thread=1 sequence=63 RECID=41 STAMP=925157838
input archived log thread=1 sequence=64 RECID=42 STAMP=925164026
input archived log thread=1 sequence=65 RECID=43 STAMP=925166147
input archived log thread=1 sequence=66 RECID=44 STAMP=925168784
input archived log thread=1 sequence=67 RECID=45 STAMP=925169035
input archived log thread=1 sequence=68 RECID=46 STAMP=925205840
input archived log thread=1 sequence=69 RECID=47 STAMP=925224968
input archived log thread=1 sequence=70 RECID=48 STAMP=925230868
input archived log thread=1 sequence=71 RECID=49 STAMP=925253889
input archived log thread=1 sequence=72 RECID=50 STAMP=925255635
input archived log thread=1 sequence=73 RECID=51 STAMP=925257078
input archived log thread=1 sequence=74 RECID=52 STAMP=925257134
input archived log thread=1 sequence=75 RECID=53 STAMP=925257135
input archived log thread=1 sequence=76 RECID=54 STAMP=925257169
input archived log thread=1 sequence=77 RECID=55 STAMP=925257203
input archived log thread=1 sequence=78 RECID=56 STAMP=925257242
input archived log thread=1 sequence=79 RECID=57 STAMP=925257291
input archived log thread=1 sequence=80 RECID=58 STAMP=925399179
input archived log thread=1 sequence=81 RECID=59 STAMP=925406620
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0irih5ct_1_1.rmn tag=TAG20161016T172340 comment=NONE #归档日志文件备份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 16-OCT-16
Starting backup at 16-OCT-16
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/ORA11GR2/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11GR2/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11GR2/users01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0jrih5eu_1_1.rmn tag=TAG20161016T172446 comment=NONE #数据文件备份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:58
Finished backup at 16-OCT-16
Starting backup at 16-OCT-16
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=82 RECID=60 STAMP=925406865
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0krih5kh_1_1.rmn tag=TAG20161016T172745 comment=NONE #最新归档日志文件备份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-OCT-16
Starting Control File and SPFILE Autobackup at 16-OCT-16
piece handle=/u01/app/FRA/ORA11GR2/autobackup/2016_10_16/o1_mf_s_925406866_d06l0mmn_.bkp comment=NONE #参数文件与控制文件备份集
Finished Control File and SPFILE Autobackup at 16-OCT-16
备份完成。
[oracle@oracle ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 16 17:22:56 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA11GR2 (DBID=238796283)
RMAN> backup database plus archivelog;
Starting backup at 16-OCT-16
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=44 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=59 RECID=37 STAMP=924897627
input archived log thread=1 sequence=60 RECID=38 STAMP=924968778
input archived log thread=1 sequence=61 RECID=39 STAMP=925156048
input archived log thread=1 sequence=62 RECID=40 STAMP=925157378
input archived log thread=1 sequence=63 RECID=41 STAMP=925157838
input archived log thread=1 sequence=64 RECID=42 STAMP=925164026
input archived log thread=1 sequence=65 RECID=43 STAMP=925166147
input archived log thread=1 sequence=66 RECID=44 STAMP=925168784
input archived log thread=1 sequence=67 RECID=45 STAMP=925169035
input archived log thread=1 sequence=68 RECID=46 STAMP=925205840
input archived log thread=1 sequence=69 RECID=47 STAMP=925224968
input archived log thread=1 sequence=70 RECID=48 STAMP=925230868
input archived log thread=1 sequence=71 RECID=49 STAMP=925253889
input archived log thread=1 sequence=72 RECID=50 STAMP=925255635
input archived log thread=1 sequence=73 RECID=51 STAMP=925257078
input archived log thread=1 sequence=74 RECID=52 STAMP=925257134
input archived log thread=1 sequence=75 RECID=53 STAMP=925257135
input archived log thread=1 sequence=76 RECID=54 STAMP=925257169
input archived log thread=1 sequence=77 RECID=55 STAMP=925257203
input archived log thread=1 sequence=78 RECID=56 STAMP=925257242
input archived log thread=1 sequence=79 RECID=57 STAMP=925257291
input archived log thread=1 sequence=80 RECID=58 STAMP=925399179
input archived log thread=1 sequence=81 RECID=59 STAMP=925406620
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0irih5ct_1_1.rmn tag=TAG20161016T172340 comment=NONE #归档日志文件备份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 16-OCT-16
Starting backup at 16-OCT-16
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/ORA11GR2/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11GR2/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11GR2/users01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0jrih5eu_1_1.rmn tag=TAG20161016T172446 comment=NONE #数据文件备份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:58
Finished backup at 16-OCT-16
Starting backup at 16-OCT-16
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=82 RECID=60 STAMP=925406865
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0krih5kh_1_1.rmn tag=TAG20161016T172745 comment=NONE #最新归档日志文件备份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-OCT-16
Starting Control File and SPFILE Autobackup at 16-OCT-16
piece handle=/u01/app/FRA/ORA11GR2/autobackup/2016_10_16/o1_mf_s_925406866_d06l0mmn_.bkp comment=NONE #参数文件与控制文件备份集
Finished Control File and SPFILE Autobackup at 16-OCT-16
备份完成。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31392094/viewspace-2127105/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31392094/viewspace-2127105/