Sunday, 29 June 2014

Resize Online Redo Log size in Oracle 11g R2

Re size Online Redolog size in Oracle 11gR2

Step 1. Check the status of redolog files

Step2. Create 3 three new redolog file with size 100 MB

alter database add logfile group 4  '/u01/app/oracle/oradata/ORCL/redo04.log' size 100M; 
alter database add logfile group 5  '/u01/app/oracle/oradata/ORCL/redo05.log' size 100M; 
alter database add logfile group 6  '/u01/app/oracle/oradata/ORCL/redo06.log' size 100M; 

Step 4. Check the status of redolog files 

select group#, status from v$log;

Step 5. Switch logfile to change the status 

alter system switch logfile;

Step 6. Wait untill the status set INACTIVE of old three logfiles

Step 7. Once the logfile status set to INACTIVE drop the logfiles

SQL> alter database drop logfile group 1;
SQL> alter database drop logfile group 2;
SQL> alter database drop logfile group 3;

Note: Above steps tested in my lab.

2 comments:

  1. Jadwal Daftar Sabung Ayam SV388 26 Februari 2019 - Selasa, 26 Februari 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.

    Situs Judi Sabung Ayam Online SV388 Merupakan Situs Judi Asal Thailand Yang Sangat Terkenal Dengan Permainan Sabung Ayam Yang Fair dan Menghibur Para Penonton Judi Sabung Ayam.

    Untuk Info Lebih Lanjut Bisa Hub kami Di :
    wechat : bolavita
    line : cs_bolavita
    whatsapp : +628122222995
    BBM: BOLAVITA

    ReplyDelete
  2. Hello Everybody,
    My name is Mrs Sharon Sim. I live in Singapore and i am a happy woman today? and i told my self that any lender that rescue my family from our poor situation, i will refer any person that is looking for loan to him, he gave me happiness to me and my family, i was in need of a loan of $250,000.00 to start my life all over as i am a single mother with 3 kids I met this honest and GOD fearing man loan lender that help me with a loan of $250,000.00 SG. Dollar, he is a GOD fearing man, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Sharon, that refer you to him. contact Dr Purva Pius, call/whats-App Contact Number +918929509036 via email:(urgentloan22@gmail.com) Thank you.

    ReplyDelete