增加联机重做日志组
要增加联机重做日志组的数量,通过“alter database add logfile group…”语句实现。
具体如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
SQL> desc v$logfile; Name Null? Type ----------------------------------------- -------- ---------------------------- GROUP# NUMBER STATUS VARCHAR2(7) TYPE VARCHAR2(7) MEMBER VARCHAR2(513) IS_RECOVERY_DEST_FILE VARCHAR2(3) CON_ID NUMBER SQL> SQL> set linesize 400 SQL> set pagesize 400 SQL> SQL> col member for a68 SQL> SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_ CON_ID ---------- ------- ------- -------------------------------------------------------------------- --- ---------- 1 ONLINE /oradata/ATLAS/onlinelog/o1_mf_1_b5cyjr0s_.log NO 0 1 ONLINE /oradata/fast_recovery_area/ATLAS/onlinelog/o1_mf_1_b5cyjrgf_.log YES 0 2 ONLINE /oradata/ATLAS/onlinelog/o1_mf_2_b5cyjs6t_.log NO 0 2 ONLINE /oradata/fast_recovery_area/ATLAS/onlinelog/o1_mf_2_b5cyjsoj_.log YES 0 3 ONLINE /oradata/ATLAS/onlinelog/o1_mf_3_b5cyjt8v_.log NO 0 3 ONLINE /oradata/fast_recovery_area/ATLAS/onlinelog/o1_mf_3_b5cyjvkg_.log YES 0 6 rows selected. SQL> SQL> alter database add logfile group 4 ('/oradata/ATLAS/onlinelog/redo04a.log','/oradata/fast_recovery_area/ATLAS/onlinelog/redo04b.log') size 50m; Database altered. SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_ CON_ID ---------- ------- ------- -------------------------------------------------------------------- --- ---------- 1 ONLINE /oradata/ATLAS/onlinelog/o1_mf_1_b5cyjr0s_.log NO 0 1 ONLINE /oradata/fast_recovery_area/ATLAS/onlinelog/o1_mf_1_b5cyjrgf_.log YES 0 2 ONLINE /oradata/ATLAS/onlinelog/o1_mf_2_b5cyjs6t_.log NO 0 2 ONLINE /oradata/fast_recovery_area/ATLAS/onlinelog/o1_mf_2_b5cyjsoj_.log YES 0 3 ONLINE /oradata/ATLAS/onlinelog/o1_mf_3_b5cyjt8v_.log NO 0 3 ONLINE /oradata/fast_recovery_area/ATLAS/onlinelog/o1_mf_3_b5cyjvkg_.log YES 0 4 ONLINE /oradata/ATLAS/onlinelog/redo04a.log NO 0 4 ONLINE /oradata/fast_recovery_area/ATLAS/onlinelog/redo04b.log NO 0 8 rows selected. SQL> |
————————————————————————
Ending。