Monthly Archives: April 2017

How to change the Redo Log File size in Oracle Database

The Redo Logs must be dropped and recreated for changing the redo log size. It can be done online without shutting down the database. However, you need to make sure that the Redo Group being dropped should be INACTIVE when

Posted in DBA

ORA-02062: distributed recovery received

Oracle error something like Errors in file /u01/app/oracle/diag/rdbms/dpdcapp/dpdcapp/trace/dpdcapp_reco_3513.trc: ORA-02062: distributed recovery received DBID 10a13ece, expected 773f337a Could be occurred if a transaction becomes in-doubt.   Oracle developed the two phase commit to allow the controlling SQL to ensure that all

Posted in DBA, ORA- Error