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.
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.
ReplyDeleteSitus 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
Hello Everybody,
ReplyDeleteMy 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.