ITPub博客

首页 > 数据库 > Oracle > Oracle 11g RMAN备份-备份标签

Oracle 11g RMAN备份-备份标签

Oracle 作者:yuntui 时间:2016-11-03 20:01:23 0 删除 编辑
参考《Backup and recover user’s guid-2.2.4.2》,详见之前发过的与备份恢复相关的博文。

--备份镜像

backup as copy....

copy datafile...

--备份集

backup database...

backup tablespace...

backup datafile...

--检查所有归档日志

MAN> crosscheck archivelog all;

 

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=26 device type=DISK

validation succeeded for archived log

archived log file name=/archive1/1_93_813665348.dbf RECID=1 STAMP=823320816

validation succeeded for archived log

archived log file name=/archive2/1_93_813665348.dbf RECID=2 STAMP=823320816

.....

--备份所有归档日志

RMAN> backup archivelog all;

 

Starting backup at 2013-08-14 04:30:04

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=93 RECID=2 STAMP=823320816

input archived log thread=1 sequence=94 RECID=8 STAMP=823322447

input archived log thread=1 sequence=95 RECID=9 STAMP=823322447

input archived log thread=1 sequence=96 RECID=12 STAMP=823322448

channel ORA_DISK_1: starting piece 1 at 2013-08-14 04:30:09

channel ORA_DISK_1: finished piece 1 at 2013-08-14 04:30:16

piece handle=/pooldisk02/backup03/1eoh8dih_1_1 tag=TAG20130814T043008 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07

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=1 RECID=14 STAMP=823323373

input archived log thread=1 sequence=2 RECID=15 STAMP=823323515

input archived log thread=1 sequence=4 RECID=18 STAMP=823328120

input archived log thread=1 sequence=5 RECID=20 STAMP=823328120

input archived log thread=1 sequence=6 RECID=21 STAMP=823328120

channel ORA_DISK_1: starting piece 1 at 2013-08-14 04:30:16

channel ORA_DISK_1: finished piece 1 at 2013-08-14 04:30:17

piece handle=/pooldisk02/backup03/1foh8dio_1_1 tag=TAG20130814T043008 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

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=1 RECID=24 STAMP=823349716

input archived log thread=1 sequence=2 RECID=26 STAMP=823363531

input archived log thread=1 sequence=3 RECID=28 STAMP=823363532

input archived log thread=1 sequence=4 RECID=30 STAMP=823363534

input archived log thread=1 sequence=5 RECID=32 STAMP=823363729

input archived log thread=1 sequence=6 RECID=34 STAMP=823363769

input archived log thread=1 sequence=7 RECID=36 STAMP=823363777

input archived log thread=1 sequence=8 RECID=37 STAMP=823363948

input archived log thread=1 sequence=9 RECID=39 STAMP=823363951

input archived log thread=1 sequence=10 RECID=42 STAMP=823363954

input archived log thread=1 sequence=11 RECID=43 STAMP=823364155

input archived log thread=1 sequence=12 RECID=45 STAMP=823364156

input archived log thread=1 sequence=13 RECID=47 STAMP=823364158

input archived log thread=1 sequence=14 RECID=50 STAMP=823364525

input archived log thread=1 sequence=15 RECID=52 STAMP=823364546

input archived log thread=1 sequence=16 RECID=53 STAMP=823365806

input archived log thread=1 sequence=17 RECID=56 STAMP=823367914

input archived log thread=1 sequence=18 RECID=57 STAMP=823384872

input archived log thread=1 sequence=19 RECID=60 STAMP=823392030

input archived log thread=1 sequence=20 RECID=61 STAMP=823408208

channel ORA_DISK_1: starting piece 1 at 2013-08-14 04:30:18

channel ORA_DISK_1: finished piece 1 at 2013-08-14 04:30:43

piece handle=/pooldisk02/backup03/1goh8dip_1_1 tag=TAG20130814T043008 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

Finished backup at 2013-08-14 04:30:43

 

Starting Control File and SPFILE Autobackup at 2013-08-14 04:30:43

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823408243_90pml4cv_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 2013-08-14 04:30:46

 

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30633755/viewspace-2127655/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-12-14

  • 博文量
    150
  • 访问量
    70818