oracle 12c 归档,Oracle 12C 新特性:关于归档日志的备份

关于归档日志的备份:

RMAN>

backup archivelog all;

Starting backup at 2014/12/10 10:38:50

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=165

RECID=3 STAMP=865293027

input archived log thread=2 sequence=7

RECID=1 STAMP=865288883

input archived log thread=2 sequence=8

RECID=2 STAMP=865293024

input archived log thread=2 sequence=9

RECID=4 STAMP=865328414

input archived log thread=1 sequence=166

RECID=5 STAMP=865342807

input archived log thread=2 sequence=10

RECID=7 STAMP=865362889

input archived log thread=1 sequence=167

RECID=6 STAMP=865362869

input archived log thread=1 sequence=168

RECID=8 STAMP=865362890

input archived log thread=2 sequence=11

RECID=9 STAMP=865375273

input archived log thread=1 sequence=169

RECID=11 STAMP=865407611

input archived log thread=2 sequence=12

RECID=10 STAMP=865379040

input archived log thread=2 sequence=13

RECID=12 STAMP=865418414

input archived log thread=1 sequence=170

RECID=13 STAMP=865458005

input archived log thread=2 sequence=14

RECID=14 STAMP=865461643

input archived log thread=1 sequence=171

RECID=17 STAMP=865486506

input archived log thread=2 sequence=15

RECID=15 STAMP=865461711

input archived log thread=2 sequence=16

RECID=16 STAMP=865486505

input archived log thread=2 sequence=17

RECID=19 STAMP=865533659

input archived log thread=1 sequence=172

RECID=18 STAMP=865533657

input archived log thread=1 sequence=173

RECID=20 STAMP=865548080

input archived log thread=2 sequence=18

RECID=22 STAMP=865576838

input archived log thread=1 sequence=174

RECID=21 STAMP=865569624

input archived log thread=1 sequence=175

RECID=23 STAMP=865588301

input archived log thread=2 sequence=19

RECID=24 STAMP=865605820

input archived log thread=1 sequence=176

RECID=25 STAMP=865616406

input archived log thread=2 sequence=20

RECID=26 STAMP=865623625

input archived log thread=1 sequence=177

RECID=27 STAMP=865641607

input archived log thread=2 sequence=21

RECID=28 STAMP=865652432

input archived log thread=1 sequence=178

RECID=29 STAMP=865663260

input archived log thread=2 sequence=22

RECID=31 STAMP=865692038

input archived log thread=1 sequence=179

RECID=30 STAMP=865677627

input archived log thread=1 sequence=180

RECID=32 STAMP=865692040

input archived log thread=2 sequence=23

RECID=33 STAMP=865721886

input archived log thread=1 sequence=181

RECID=34 STAMP=865728009

input archived log thread=2 sequence=24

RECID=35 STAMP=865742445

input archived log thread=1 sequence=182

RECID=36 STAMP=865771254

input archived log thread=2 sequence=25

RECID=37 STAMP=865781920

input archived log thread=1 sequence=183

RECID=38 STAMP=865807254

input archived log thread=2 sequence=26

RECID=41 STAMP=865811408

input archived log thread=1 sequence=184

RECID=39 STAMP=865807359

input archived log thread=1 sequence=185

RECID=40 STAMP=865811407

input archived log thread=1 sequence=186

RECID=42 STAMP=865814687

input archived log thread=2 sequence=27

RECID=44 STAMP=865857620

input archived log thread=1 sequence=187

RECID=43 STAMP=865846803

input archived log thread=1 sequence=188

RECID=45 STAMP=865890033

input archived log thread=2 sequence=28

RECID=46 STAMP=865893651

input archived log thread=1 sequence=189

RECID=48 STAMP=865901143

input archived log thread=2 sequence=29

RECID=47 STAMP=865893764

input archived log thread=2 sequence=30

RECID=49 STAMP=865908013

input archived log thread=1 sequence=190

RECID=50 STAMP=865922416

input archived log thread=2 sequence=31

RECID=51 STAMP=865938853

input archived log thread=1 sequence=191

RECID=52 STAMP=865939133

input archived log thread=2 sequence=32

RECID=53 STAMP=865939135

channel ORA_DISK_1: starting piece 1 at

2014/12/10 10:39:02

channel ORA_DISK_1: finished piece 1 at

2014/12/10 10:39:47

piece handle=+ARCH/CLOUD/BACKUPSET/2014_12_10/annnf0_tag20141210t103900_0.278.865939143

tag=TAG20141210T103900 comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:00:45

Finished backup at 2014/12/10 10:39:47

Starting Control File and SPFILE

Autobackup at 2014/12/10 10:39:48

piece

handle=+ARCH/CLOUD/AUTOBACKUP/2014_12_10/s_865939188.277.865939189 comment=NONE

Finished Control File and SPFILE Autobackup

at 2014/12/10 10:39:49

RMAN>

backup archivelog all database pdb01;

Starting backup at 2014/12/10 10:45:30

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=188

RECID=45 STAMP=865890033

input archived log thread=2 sequence=28

RECID=46 STAMP=865893651

input archived log thread=1 sequence=189

RECID=48 STAMP=865901143

input archived log thread=2 sequence=29

RECID=47 STAMP=865893764

input archived log thread=2 sequence=30

RECID=49 STAMP=865908013

input archived log thread=1 sequence=190

RECID=50 STAMP=865922416

input archived log thread=2 sequence=31

RECID=51 STAMP=865938853

input archived log thread=1 sequence=191

RECID=52 STAMP=865939133

input archived log thread=2 sequence=32

RECID=53 STAMP=865939135

input archived log thread=1 sequence=192

RECID=54 STAMP=865939442

input archived log thread=2 sequence=33

RECID=55 STAMP=865939444

input archived log thread=1 sequence=193

RECID=57 STAMP=865939532

input archived log thread=2 sequence=34

RECID=56 STAMP=865939531

channel ORA_DISK_1: starting piece 1 at

2014/12/10 10:45:36

channel ORA_DISK_1: finished piece 1 at

2014/12/10 10:45:43

piece

handle=+ARCH/CLOUD/BACKUPSET/2014_12_10/annnf0_tag20141210t104535_0.278.865939537

tag=TAG20141210T104535 comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:00:07

channel ORA_DISK_1: starting full datafile

backup set

channel ORA_DISK_1: specifying datafile(s)

in backup set

input datafile file number=00009

name=+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/sysaux.287.865165777

input datafile file number=00008

name=+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/system.286.865165777

input datafile file number=00011

name=+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/mon_asmtbs.290.865760705

input datafile file number=00010

name=+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/users.289.865165855

channel ORA_DISK_1: starting piece 1 at

2014/12/10 10:45:43

channel ORA_DISK_1: finished piece 1 at

2014/12/10 10:45:58

piece handle=+ARCH/CLOUD/09207FB3299032D4E055000000000001/BACKUPSET/2014_12_10/nnndf0_tag20141210t104535_0.317.865939543

tag=TAG20141210T104535 comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:00:15

Finished backup at 2014/12/10 10:45:58

Starting Control File and SPFILE Autobackup

at 2014/12/10 10:45:58

piece

handle=+ARCH/CLOUD/AUTOBACKUP/2014_12_10/s_865939558.316.865939559 comment=NONE

Finished Control File and SPFILE Autobackup

at 2014/12/10 10:45:59

RMAN>

list backup of archivelog all;

List of Backup Sets

===================

BS Key

Size       Device Type Elapsed

Time Completion Time

------- ---------- ----------- ------------

-------------------

29

299.19M    DISK        00:00:06     2014/12/10 10:45:41

BP Key: 29   Status:

AVAILABLE  Compressed: NO  Tag: TAG20141210T104535

Piece Name:

+ARCH/CLOUD/BACKUPSET/2014_12_10/annnf0_tag20141210t104535_0.278.865939537

List of Archived Logs in backup set 29

Thrd Seq     Low SCN    Low Time            Next SCN   Next Time

---- ------- ---------- ------------------- ---------- ---------

1    188

2855443    2014/12/09 09:00:01

2901502    2014/12/09 21:00:32

1    189     2901502

2014/12/09 21:00:32 2940886

2014/12/10 00:05:41

1    190     2940886

2014/12/10 00:05:41 2966958

2014/12/10 06:00:14

1    191     2966958

2014/12/10 06:00:14 2984480

2014/12/10 10:38:52

1    192     2984480

2014/12/10 10:38:52 2984758

2014/12/10 10:44:01

1    193     2984758

2014/12/10 10:44:01 2984883

2014/12/10 10:45:32

2    28      2867741

2014/12/09 12:00:19 2911287

2014/12/09 22:00:49

2    29      2911287

2014/12/09 22:00:49 2925974

2014/12/09 22:02:43

2    30      2925974

2014/12/09 22:02:43 2950235

2014/12/10 02:00:12

2    31      2950235

2014/12/10 02:00:12 2984280

2014/12/10 10:34:12

2    32      2984280

2014/12/10 10:34:12 2984484

2014/12/10 10:38:55

2    33      2984484

2014/12/10 10:38:55 2984762

2014/12/10 10:44:04

2    34     2984762    2014/12/10 10:44:04 2984879    2014/12/10 10:45:31

RMAN>

list backup of database;

List of Backup Sets

===================

BS Key

Type LV Size       Device Type

Elapsed Time Completion Time

------- ---- -- ---------- -----------

------------ -------------------

30

Full    780.38M    DISK

00:00:14     2014/12/10 10:45:57

BP Key: 30   Status:

AVAILABLE  Compressed: NO  Tag: TAG20141210T104535

Piece Name:

+ARCH/CLOUD/09207FB3299032D4E055000000000001/BACKUPSET/2014_12_10/nnndf0_tag20141210t104535_0.317.865939543

List of Datafiles in backup set 30

Container ID: 3, PDB Name: PDB01

File LV Type Ckp SCN    Ckp

Time            Name

---- -- ---- ---------- ------------------- ----

8       Full 2984892    2014/12/10 10:45:43

+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/system.286.865165777

9       Full 2984892    2014/12/10 10:45:43

+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/sysaux.287.865165777

10      Full 2984892    2014/12/10 10:45:43

+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/users.289.865165855

11      Full 2984892    2014/12/10 10:45:43

+DATA/CLOUD/09207FB3299032D4E055000000000001/DATAFILE/mon_asmtbs.290.865760705

RMAN>

list backupset of controlfile;

List of Backup Sets

===================

BS Key

Type LV Size       Device Type Elapsed Time Completion

Time

------- ---- -- ---------- -----------

------------ -------------------

31

Full    18.17M     DISK

00:00:01     2014/12/10 10:45:59

BP Key: 31   Status:

AVAILABLE  Compressed: NO  Tag: TAG20141210T104558

Piece Name: +ARCH/CLOUD/AUTOBACKUP/2014_12_10/s_865939558.316.865939559

Control File Included: Ckp SCN: 2984907      Ckp time: 2014/12/10 10:45:58

RMAN>

list backup of spfile;

List of Backup Sets

===================

BS Key

Type LV Size       Device Type

Elapsed Time Completion Time

------- ---- -- ---------- -----------

------------ -------------------

31

Full    18.17M     DISK

00:00:01     2014/12/10 10:45:59

BP Key: 31   Status:

AVAILABLE  Compressed: NO  Tag: TAG20141210T104558

Piece Name: +ARCH/CLOUD/AUTOBACKUP/2014_12_10/s_865939558.316.865939559

SPFILE Included: Modification time: 2014/12/09 22:00:11

SPFILE db_unique_name: CLOUD

RMAN>

backup archivelog all database root;

Starting backup at 2014/12/10 10:50:58

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=188

RECID=45 STAMP=865890033

input archived log thread=2 sequence=28

RECID=46 STAMP=865893651

input archived log thread=1 sequence=189

RECID=48 STAMP=865901143

input archived log thread=2 sequence=29

RECID=47 STAMP=865893764

input archived log thread=2 sequence=30

RECID=49 STAMP=865908013

input archived log thread=1 sequence=190

RECID=50 STAMP=865922416

input archived log thread=2 sequence=31

RECID=51 STAMP=865938853

input archived log thread=1 sequence=191

RECID=52 STAMP=865939133

input archived log thread=2 sequence=32

RECID=53 STAMP=865939135

input archived log thread=1 sequence=192

RECID=54 STAMP=865939442

input archived log thread=2 sequence=33

RECID=55 STAMP=865939444

input archived log thread=1 sequence=193

RECID=57 STAMP=865939532

input archived log thread=2 sequence=34

RECID=56 STAMP=865939531

input archived log thread=2 sequence=35

RECID=58 STAMP=865939859

input archived log thread=1 sequence=194

RECID=59 STAMP=865939859

channel ORA_DISK_1: starting piece 1 at

2014/12/10 10:51:00

channel ORA_DISK_1: finished piece 1 at

2014/12/10 10:51:07

piece

handle=+ARCH/CLOUD/BACKUPSET/2014_12_10/annnf0_tag20141210t105059_0.278.865939861

tag=TAG20141210T105059 comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:00:07

channel ORA_DISK_1: starting full datafile

backup set

channel ORA_DISK_1: specifying datafile(s)

in backup set

input datafile file number=00003

name=+DATA/CLOUD/DATAFILE/sysaux.262.864952711

input datafile file number=00005

name=+DATA/CLOUD/DATAFILE/undotbs1.264.864952717

input datafile file number=00001 name=+DATA/CLOUD/DATAFILE/system.260.864952703

input datafile file number=00006

name=+DATA/CLOUD/DATAFILE/undotbs2.267.864952747

input datafile file number=00007

name=+DATA/CLOUD/DATAFILE/users.268.864952749

channel ORA_DISK_1: starting piece 1 at

2014/12/10 10:51:07

channel ORA_DISK_1: finished piece 1 at

2014/12/10 10:51:42

piece

handle=+ARCH/CLOUD/BACKUPSET/2014_12_10/nnndf0_tag20141210t105059_0.315.865939867

tag=TAG20141210T105059 comment=NONE

channel ORA_DISK_1: backup set complete,

elapsed time: 00:00:35

Finished backup at 2014/12/10 10:51:42

Starting Control File and SPFILE Autobackup

at 2014/12/10 10:51:42

piece

handle=+ARCH/CLOUD/AUTOBACKUP/2014_12_10/s_865939902.314.865939903 comment=NONE

Finished Control File and SPFILE Autobackup

at 2014/12/10 10:51:43

从上述两个归档日志的备份来看,无论如何指定需要备份的数据库归档,最终结果都是所有的归档日志均做备份,同时将指定的数据库也做了备份。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值