Posts Tagged ‘10g’

Upgrade from Oracle 9i to 10g

+18 Steps to upgrade 9i to 10g: Take a manual cold backup or RMAN backup of all running databases. You can get backup steps through below links:  http://oracledbahub.com/2011/04/cloning-a-database-using-cold-backup/  http://oracledbahub.com/rman/  

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