++++++++++++++++++++++++++++++++++++++++++++++++
How to validate the database backup?
++++++++++++++++++++++++++++++++++++++++++++++++
[oracle@wasiq ~]$ rman
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jan 10 22:30:18 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /;
connected to target database: PROD (DBID=246965557)
RMAN> BACKUP VALIDATE DATABASE;
Starting backup at 10-JAN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=131 device type=DISK
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=/d01/oracle/oradata/prod/system01.dbf
input datafile file number=00002 name=/d01/oracle/oradata/prod/sysaux01.dbf
input datafile file number=00005 name=/d01/oracle/oradata/prod/users02.dbf
input datafile file number=00006 name=/d01/oracle/oradata/prod/example01.dbf
input datafile file number=00009 name=/d01/oracle/oradata/prod/abdulwasiq01.dbf
input datafile file number=00003 name=/d01/oracle/oradata/prod/undotbs01.dbf
input datafile file number=00007 name=/d01/oracle/oradata/prod/abdulwasiq.dbf
input datafile file number=00008 name=/d01/oracle/oradata/prod/tbs.dbf
input datafile file number=00004 name=/d01/oracle/oradata/prod/users01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 13489 87043 948309
File Name: /d01/oracle/oradata/prod/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 58556
Index 0 12305
Other 0 2690
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2 OK 0 17824 62731 948307
File Name: /d01/oracle/oradata/prod/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 11877
Index 0 8385
Other 0 24634
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 1 5760 948309
File Name: /d01/oracle/oradata/prod/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 5759
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 466 640 901698
File Name: /d01/oracle/oradata/prod/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 20
Index 0 3
Other 0 151
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 25473 25600 821002
File Name: /d01/oracle/oradata/prod/users02.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 25469 25600 904394
File Name: /d01/oracle/oradata/prod/example01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 1
Index 0 0
Other 0 130
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 1149 1280 932979
File Name: /d01/oracle/oradata/prod/abdulwasiq.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 1
Index 0 0
Other 0 130
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 1153 1280 931032
File Name: /d01/oracle/oradata/prod/tbs.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9 OK 0 12673 12800 934939
File Name: /d01/oracle/oradata/prod/abdulwasiq01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
Control File OK 0 594
Finished backup at 10-JAN-14
RMAN>
No comments:
Post a Comment