[Recovery Manager] Database 사전 예방 점검 기능 (11g New Feature)

- 데이터베이스 장애가 발생하기 전에 (Bad Block 등) 미리 점검할수 있는 기능. 사전 예방 점검 기능 제공

- 11g RMAN 부터 사용가능

[주요 명령어]

RMAN > validate database; --database 전체 점검

RMAN > validate tablespace system; --특정 tablespace만 점검

RMAN > validate datafile 3; --특정 data file만 점검

RMAN > validate datafile 3 block 1; --특정 data file의 특정 block 점검

[실습]

## database 전체점검

RMAN> validate database;

Starting validate at 17-NOV-14

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=39 device type=DISK

channel ORA_DISK_1: starting validation of datafile

channel ORA_DISK_1: specifying datafile(s) for validation

input datafile file number=00001 name=/app/oracle/oradata/testdb/system01.dbf

input datafile file number=00002 name=/app/oracle/oradata/testdb/sysaux01.dbf

input datafile file number=00005 name=/app/oracle/oradata/testdb/example01.dbf

input datafile file number=00003 name=/app/oracle/oradata/testdb/undotbs01.dbf

input datafile file number=00004 name=/app/oracle/oradata/testdb/users01.dbf

input datafile file number=00006 name=/app/oracle/oradata/testdb/ts_b01.dbf

channel ORA_DISK_1: validation complete, elapsed time: 00:04:36

List of Datafiles

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

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

1    OK     0              14169        90951           1426250

  File Name: /app/oracle/oradata/testdb/system01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              60048

  Index      0              12795

  Other      0              3868

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

2    OK     0              21127        76842           1426248

  File Name: /app/oracle/oradata/testdb/sysaux01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              15373

  Index      0              11551

  Other      0              28749

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

3    OK     0              1            1280            1426250

  File Name: /app/oracle/oradata/testdb/undotbs01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              0

  Index      0              0

  Other      0              1279

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

4    OK     0              337          1315            1384528

  File Name: /app/oracle/oradata/testdb/users01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              279

  Index      0              65

  Other      0              599

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

5    OK     0              33651        44241           1205210

  File Name: /app/oracle/oradata/testdb/example01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              6604

  Index      0              1147

  Other      0              2838

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

6    OK     0              1153         1280            1424501

  File Name: /app/oracle/oradata/testdb/ts_b01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              0

  Index      0              0

  Other      0              127

channel ORA_DISK_1: starting validation of datafile

channel ORA_DISK_1: specifying datafile(s) for validation

including current control file for validation

channel ORA_DISK_1: validation complete, elapsed time: 00:00:02

List of Control File and SPFILE

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

File Type    Status Blocks Failing Blocks Examined

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

Control File OK     0              594

Finished validate at 17-NOV-14

## 특정 tablespace 점검

RMAN> validate tablespace system;

Starting validate at 17-NOV-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile

channel ORA_DISK_1: specifying datafile(s) for validation

input datafile file number=00001 name=/app/oracle/oradata/testdb/system01.dbf

channel ORA_DISK_1: validation complete, elapsed time: 00:01:15

List of Datafiles

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

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

1    OK     0              14169        90951           1426854

  File Name: /app/oracle/oradata/testdb/system01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              60048

  Index      0              12795

  Other      0              3868

channel ORA_DISK_1: starting validation of datafile

channel ORA_DISK_1: specifying datafile(s) for validation

including current control file for validation

channel ORA_DISK_1: validation complete, elapsed time: 00:00:01

List of Control File and SPFILE

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

File Type    Status Blocks Failing Blocks Examined

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

Control File OK     0              594

Finished validate at 17-NOV-14

## 특정 data file 점검

RMAN> validate datafile 3;

Starting validate at 17-NOV-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile

channel ORA_DISK_1: specifying datafile(s) for validation

input datafile file number=00003 name=/app/oracle/oradata/testdb/undotbs01.dbf

channel ORA_DISK_1: validation complete, elapsed time: 00:00:03

List of Datafiles

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

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

3    OK     0              1            1280            1426971

  File Name: /app/oracle/oradata/testdb/undotbs01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              0

  Index      0              0

  Other      0              1279

Finished validate at 17-NOV-14

## 특정 datafile의 특정 block 점검

RMAN> validate datafile 3 block 1;

Starting validate at 17-NOV-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile

channel ORA_DISK_1: specifying datafile(s) for validation

input datafile file number=00003 name=/app/oracle/oradata/testdb/undotbs01.dbf

channel ORA_DISK_1: validation complete, elapsed time: 00:00:01

List of Datafiles

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

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

3    OK     0              0            1               0

  File Name: /app/oracle/oradata/testdb/undotbs01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              0

  Index      0              0

  Other      0              1

Finished validate at 17-NOV-14