Získejte konzultaci v hodnotě 1 500 Kč k vaší databázi Oracle zcela zdarma. Ozvěte se mi ještě dnes.
SQL> SELECT a.group#, a.member, b.bytes
FROM v$logfile a, v$log b WHERE a.group# = b.group#; 2
GROUP# MEMBER BYTES
——————————————————————————–
1 /oradata/ORCL/log01a.rdo 157286400
2 /oradata/ORCL/log02a.rdo 157286400
3 /oradata/ORCL/log03a.rdo 157286400
4 /oradata/ORCL/log04a.rdo 157286400
select group#, status from v$log;
GROUP# STATUS
———- —————-
1 INACTIVE
2 INACTIVE
3 CURRENT
4 INACTIVE
SQL> alter database add logfile group 1 (
‚/oradata/ORCL/log01a.rdo‘,
‚/oradata/ORCL/log01b.rdo‘) size 250m reuse; 2 3
Database altered.
SQL> select group#, status from v$log;
GROUP# STATUS
———- —————-
1 UNUSED
2 INACTIVE
3 CURRENT
4 INACTIVE
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database add logfile group 2 (
‚/oradata/ORCL/log02a.rdo‘,
‚/oradata/ORCL/log02b.rdo‘) size 250m reuse; 2 3
Database altered.
SQL> select group#, status from v$log;
GROUP# STATUS
———- —————-
1 UNUSED
2 UNUSED
3 CURRENT
4 INACTIVE
SQL> alter system switch logfile;
System altered.
SQL> select group#, status from v$log;
GROUP# STATUS
———- —————-
1 CURRENT
2 UNUSED
3 ACTIVE
4 INACTIVE
SQL> alter database drop logfile group 4;
Database altered.
SQL> select group#, status from v$log;
GROUP# STATUS
———- —————-
1 CURRENT
2 UNUSED
3 ACTIVE
SQL> ALTER SYSTEM CHECKPOINT GLOBAL;
System altered.
SQL> select group#, status from v$log;
GROUP# STATUS
———- —————-
1 CURRENT
2 UNUSED
3 INACTIVE
alter database drop logfile group 3;
SQL> alter database add logfile group 4 (
‚/oradata/ORCL/log04a.rdo‘,
‚/oradata/ORCL/log04b.rdo‘) size 250m reuse; 2 3
Database altered.