Wednesday, July 27, 2016

_datafile_write_errors_crash_instance

If _datafile_write_errors_crash_instance = TRUE (default in 11gR2 & after)  then any write to a datafile which fails due to an IO error causes  an instance crash.

 If _datafile_write_errors_crash_instance = FALSE(default before 11gR2) then the behaviour reverts to the previous behaviour (before this fix) such that a write error to a datafile offlines the file if the DB is in archivelog mode and the file is not in system tablespace. If DB in noarchivelog mode , instance will be still aborted.
at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to Compile Forms , Reports & Custom.pll in R12.2

How to Compile Custom.pll   cd $AU_TOP/resource  cp CUSTOM.plx CUSTOM.plx_bkup  cp CUSTOM.pll CUSTOM.pll_bkup  frmcmp_batch module=CUSTOM.pl...

  • Terraform - count vs for_each
      Count: Before Terraform 0.12.6, the only way to create multiple instances of the same resource was to use a  count  parameter. One o...
  • How to check If a patch is applied in R12.2
    In eBusiness Suite (EBS) 12.2.x you cannot query the AD_BUGS table to check if patches have been applied.The AD_BUGS table may have entries...
  • How to Export DB_LINKS
    We used to refresh our DEV database from production.so we need to preserve the DEV dblinks before we start refresh . we need to restore aft...