Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Verify the validity of RMAN backup of oracle 11g database

2025-04-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

[oracle@db1 ~] $rman target /

Recovery Manager: Release 11.2.0.3.0-Production on Tue Dec 12 16:08:43 2017

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

Connected to target database: PRD (DBID=893924085)

RMAN > list backup of database

Using target database control file instead of recovery catalog

List of Backup Sets

=

BS Key Type LV Size Device Type Elapsed Time Completion Time

18552 Full 5.70G DISK 00:10:08 08-DEC-17

BP Key: 18552 Status: AVAILABLE Compressed: YES Tag: TAG20171208T230015

Piece Name: / backup/scprd1/rman/Full_SCPRD_20171208_18569.bak

List of Datafiles in backup set 18552

File LV Type Ckp SCN Ckp Time Name

6 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/sce_common.296.929901311

7 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/sce_component.298.929901313

10 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse3_data.304.929901317

17 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse10_data.318.929901327

21 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse14_data.326.929901333

25 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse18_data.334.929901339

27 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse20_data.338.929901343

30 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse16_data.392.938904035

BS Key Type LV Size Device Type Elapsed Time Completion Time

18674 Full 5.73G DISK 00:09:39 11-DEC-17

BP Key: 18674 Status: AVAILABLE Compressed: YES Tag: TAG20171211T230016

Piece Name: / backup/scprd1/rman/Full_SCPRD_20171211_18691.bak

List of Datafiles in backup set 18674

File LV Type Ckp SCN Ckp Time Name

6 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/sce_common.296.929901311

7 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/sce_component.298.929901313

10 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse3_data.304.929901317

17 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse10_data.318.929901327

21 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse14_data.326.929901333

25 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse18_data.334.929901339

27 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse20_data.338.929901343

30 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse16_data.392.938904035

RMAN > validate backupset 18674

Starting validate at 12-DEC-17

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=3401 instance=SCPRD1 device type=DISK

Channel ORA_DISK_1: starting validation of datafile backup set

Channel ORA_DISK_1: reading from backup piece / backup/scprd1/rman/Full_SCPRD_20171211_18691.bak

Channel ORA_DISK_1: piece handle=/backup/scprd1/rman/Full_SCPRD_20171211_18691.bak tag=TAG20171211T230016

Channel ORA_DISK_1: restored backup piece 1

Channel ORA_DISK_1: validation complete, elapsed time: 00:11:45

Finished validate at 12-DEC-17

Only complete verification is carried out for RMAN's FULL.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report