How to recover corrupt blocks using RMAN

Last updated on December 21st, 2015 at 05:34 am1. Recovering Data blocks By Using All Available Backups Run the BLOCKRECOVER command at the RMAN prompt, specifying the file and block numbers for the corrupted blocks RMAN>BLOCKRECOVER DATAFILE 11 BLOCK 15; Recover multiple blocks in single command RMAN>BLOCKRECOVER DATAFILE 11 BLOCK 15 DATAFILE 2 BLOCK 10; 2. Recovering Data blocks Using Selected Backups Run the BLOCKRECOVER … Continue reading How to recover corrupt blocks using RMAN »

How to identify corrupts blocks in the database

Last updated on December 21st, 2015 at 05:35 am1. Run below command to populate v$database_block_corruption view with information of all the corrupted blocks. RMAN> backup validate check logical database; “CHECK LOGICAL” option is used to identify both Physical and Logical Block Corruptions. Select the view to identify the corrupted blocks detected by RMAN. SQL> select * from v$database_block_corruption; Please note, After a corrupt block is … Continue reading How to identify corrupts blocks in the database »

JDBC connection scripts

Last updated on November 28th, 2015 at 12:34 pmOracle  OC4J connect to database using JDBC connection. Here is the list of some good scripts on JDBC connection A) To find total number of open database connections for a given JVM PID SELECT s.process, Count(*) all_count FROM v$session s WHERE s.process IN () GROUP BY s.process B) To find number of database connections per JVM that were … Continue reading JDBC connection scripts »

How to create recovery catalog and register database in catalog

Last updated on December 21st, 2015 at 04:46 amRecovery catalog is a very important registry. Control file registry get rotated after some time so you lost many backup information. By storing backup information in recovery catalog ,you get rid of this problem Also it provides a central repository where you can find all the backup information. Here are the steps on How to create recovery catalog … Continue reading How to create recovery catalog and register database in catalog »

FNDCPASS and AFPASSWD

Last updated on November 28th, 2015 at 12:32 pmChange APPS/APPLSYS Passwords FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS Note: AutoConfig must be run and all application tier services restarted after changing the APPS password. Change Oracle EBS Schema Password (e.g., GL, FA, AR, etc.) FNDCPASS apps/apps 0 Y system/manager ORACLE Change All Oracle EBS Schema Passwords (e.g., GL, FA, AR, etc.) FNDCPASS apps/apps 0 Y … Continue reading FNDCPASS and AFPASSWD »

How Table Monitoring and STATISTICS_LEVEL parameter are connected from 10g onwards

Last updated on July 17th, 2015 at 06:05 pmBefore Oracle 10g -Automated collection of statistics for objects that had become stale was controlled by the setting of the MONITORING flag on table. Depending on the MONITORING flag, the GATHER_STATS_JOB job collected “GATHER EMPTY” and “GATHER STALE” on the flagged objects. 10g onwards -The MONITORING and NOMONITORING keywords are deprecated and will be ignored.Table-monitoring feature is … Continue reading How Table Monitoring and STATISTICS_LEVEL parameter are connected from 10g onwards »

How to find how much space is actually used by the lobsegments

Last updated on November 28th, 2015 at 12:35 pmLet us take the example of FND_LOBS tables in Oracle Apps Database.FND_LOBS has LOB datatype column FILE_DATA How to  find how much space is actually used by the lobsegments Query to find the actual bytes used by the lob datatype select sum(dbms_lob.getlength (FILE_DATA)) from FND_LOBS; SUM(DBMS_LOB.GETLENGTH(FILE_DATA)) ———————————- 13313 The total space allocated in the extents could be … Continue reading How to find how much space is actually used by the lobsegments »

How to correct error RMAN-20004

Last updated on December 21st, 2015 at 04:14 amProblem:When Recovery catalog has been configured.and Production Database has been cloned and a connection has been made from the clone to Catalog database using rman with out changing the DBID of the clone,then we are in some trouble Then when you try to backup the production instance with the catalog,The backup fails with following error RMAN-06004: ORACLE … Continue reading How to correct error RMAN-20004 »

How to add debug codes in the application executable

Last updated on December 21st, 2015 at 03:53 amIt often happens the executable are either coredumping or not behaving exactly.We need to debug the executable. Here are the General steps on How to add debug codes in the application executable. Infact these are steps even followed  by adpatch to replace lib files in the product executables Let’s say that you need to link the object file … Continue reading How to add debug codes in the application executable »

Patch history tables in Oracle Apps

Last updated on November 28th, 2015 at 12:03 pmPatch history tables in Oracle Apps AD_APPL_TOPS – Stores information about all APPL_TOPS utilizing this instance. AD_APPLIED_PATCHES – Stores information about all distinct updates applied. AD_BUGS – Stores information about all distinct bug fixes applied. AD_DRIVERS – Stores information about the drivers that comprise an update. AD_FILE_VERSIONS – Stores version information for files. AD_FILES – Stores information … Continue reading Patch history tables in Oracle Apps »

Result cache in 11g

Last updated on September 1st, 2016 at 05:21 amPrior to 10g, every query must be re-executed even if there is no change in the tables. This reexecution is unnecessary for few static tables and only caching using at client tools resolve this issue. But, in 11g, query results can be cached in SGA. Just to avoid confusion, this is much different from buffer cache caching … Continue reading Result cache in 11g »