[RMAN]Database 사전 예방 점검 기능

데이터베이스가 장애(Bad block등)가 발생하기 전에 미리 점검할 수 있는 기능으로써, 11g부터 제공 됩니다.

 

(1) 데이터베이스 점검

RMAN> validate database;

 

Starting validate at 19/12/06

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=267 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=/oradata/ORCL19C/system01.dbf

input datafile file number=00003 name=/oradata/ORCL19C/sysaux01.dbf

input datafile file number=00007 name=/oradata/ORCL19C/users01.dbf

input datafile file number=00004 name=/oradata/ORCL19C/undotbs01.dbf

input datafile file number=00005 name=/oradata/ORCL19C/test01.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

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

1    OK     0              16668        117768          2872262

  File Name: /oradata/ORCL19C/system01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              81676

  Index      0              13372

  Other      0              6044

 

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

3    OK     0              18232        89631           2872392

  File Name: /oradata/ORCL19C/sysaux01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              12783

  Index      0              10645

  Other      0              47940

 

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

4    OK     0              1            43527           2872392

  File Name: /oradata/ORCL19C/undotbs01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              0

  Index      0              0

  Other      0              43519

 

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

5    OK     0              1            6401            2844182

  File Name: /oradata/ORCL19C/test01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              5

  Index      0              0

  Other      0              6394

 

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN

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

7    OK     0              31557        45443           2853554

  File Name: /oradata/ORCL19C/users01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              6319

  Index      0              1193

  Other      0              6371

 

channel ORA_DISK_1: starting validation of datafile

channel ORA_DISK_1: specifying datafile(s) for validation

including current control file for validation

including current SPFILE in backup set

channel ORA_DISK_1: validation 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              652

Finished validate at 19/12/06

 

(2) 특정 테이블스페이스만 점검

RMAN> validate tablespace users;

 

Starting validate at 19/12/06

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=00007 name=/oradata/ORCL19C/users01.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

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

7    OK     0              31557        45443           2853554

  File Name: /oradata/ORCL19C/users01.dbf

  Block Type Blocks Failing Blocks Processed

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

  Data       0              6319

  Index      0              1193

  Other      0              6371

 

Finished validate at 19/12/06