Friday 10 January 2014

How to validate the database backup?


++++++++++++++++++++++++++++++++++++++++++++++++
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