Posts Tagged ‘oracle 10g’

oracle database upgrade from 10.2.0.3 to 10.2.0.5

+23 Upgrade From 10.2.0.3 to 10.2.0.5 On Standalone Machine (Non RAC):  Step1. Take full backup.(You can choose your own way to take full backup, below script will take full backup through RMAN) Export ORACLE_SID=kpdb

Increase Redo Log File Size in Oracle 10g

+5  How to Increase Redo Log File Size :   Steps to Increase Redo Log File Size : SQL> select * from v$log; GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS  FIRST_CHANGE# FIRST_TIM