DB_ULTRA_SAFE

SQL> select * from v$database_block_corruption;

CONFIGURACION DE PARAMETROS EN LA BASE DE DATOS




DB_ULTRA_SAFE sets the default values for other parameters that control protection levels.

Values

• OFF
  When any of DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, or DB_LOST_WRITE_PROTECT are explicitly set, no changes are made.
• DATA_ONLY
  • DB_BLOCK_CHECKING will be set to MEDIUM.
  • DB_LOST_WRITE_PROTECT will be set to TYPICAL.
  • DB_BLOCK_CHECKSUM will be set to FULL.
• DATA_AND_INDEX
• DB_BLOCK_CHECKING will be set to FULL.
• DB_LOST_WRITE_PROTECT will be set to TYPICAL.
• DB_BLOCK_CHECKSUM will be set to FULL.
• [oracle@localhost ~]$ rman target /
• 
  
• Recovery Manager: Release 12.1.0.1.0 - Production on Thu Feb 21 18:27:14 2019
• 
  
• Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
• 
  
• connected to target database: ACME (DBID=2033062067)
• 
  
• RMAN> validate database;
• 
  
• Starting validate at 21-FEB-19
• using target database control file instead of recovery catalog
• allocated channel: ORA_DISK_1
• channel ORA_DISK_1: SID=216 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=+DATA/ACME/DATAFILE/system.258.1000676203
• input datafile file number=00003 name=+DATA/ACME/DATAFILE/sysaux.257.848597951
• input datafile file number=00002 name=+DATA/ACME/DATAFILE/example.266.1000672081
• input datafile file number=00004 name=+DATA/ACME/DATAFILE/undotbs1.260.848598093
• input datafile file number=00006 name=+DATA/ACME/DATAFILE/users.259.848598091
• channel ORA_DISK_1: validation complete, elapsed time: 00:00:16
• List of Datafiles
• =================
• File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
• ---- ------ -------------- ------------ --------------- ----------
• 1    OK     0              17647        101133          1969757   
•   File Name: +DATA/ACME/DATAFILE/system.258.1000676203
•   Block Type Blocks Failing Blocks Processed
•   ---------- -------------- ----------------
•   Data       0              65947           
•   Index      0              13810           
•   Other      0              3716            
• 
  
• File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
• ---- ------ -------------- ------------ --------------- ----------
• 2    OK     0              34171        45840           1918839   
•   File Name: +DATA/ACME/DATAFILE/example.266.1000672081
•   Block Type Blocks Failing Blocks Processed
•   ---------- -------------- ----------------
•   Data       0              6788            
•   Index      0              1219            
•   Other      0              3662            
• 
  
• File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
• ---- ------ -------------- ------------ --------------- ----------
• 3    OK     0              26437        97287           1969765   
•   File Name: +DATA/ACME/DATAFILE/sysaux.257.848597951
•   Block Type Blocks Failing Blocks Processed
•   ---------- -------------- ----------------
•   Data       0              17320           
•   Index      0              10482           
•   Other      0              43041           
• 
  
• File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
• ---- ------ -------------- ------------ --------------- ----------
• 4    OK     0              129          9600            1969765   
•   File Name: +DATA/ACME/DATAFILE/undotbs1.260.848598093
•   Block Type Blocks Failing Blocks Processed
•   ---------- -------------- ----------------
•   Data       0              0               
•   Index      0              0               
•   Other      0              9471            
• 
  
• File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
• ---- ------ -------------- ------------ --------------- ----------
• 6    OK     0              17           642             1769342   
•   File Name: +DATA/ACME/DATAFILE/users.259.848598091
•   Block Type Blocks Failing Blocks Processed
•   ---------- -------------- ----------------
•   Data       0              31              
•   Index      0              5               
•   Other      0              587             
• 
  
• 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              612             
• Finished validate at 21-FEB-19
• 
  
• RMAN>