SQL*Plus: Release 9.2.0.1.0 - Production on Sun Jan 25 21:08:14 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn /as sysdba;
Connected.
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO03.LOG
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO01.LOG
============================================================================================== ADDING ONLINE REDO LOG FILE GROUP
============================================================================================
SQL>
SQL> alter database add logfile group 4 'e:\oracle\oradata\iacm\redo04.rdo' size
10m;
Database altered.
SQL> alter database add logfile group 5 ('e:\oracle\oradata\iacm\redo05.rdo','e:
\oracle\oradata\iacm\redo005.rdo') size 10m;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO03.LOG
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO01.LOG
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
4 ONLINE
E:\ORACLE\ORADATA\IACM\REDO04.RDO
5 ONLINE
E:\ORACLE\ORADATA\IACM\REDO05.RDO
5 ONLINE
E:\ORACLE\ORADATA\IACM\REDO005.RDO
6 rows selected.
SQL>
============================================================================================
ADDING ONLINE REDO LOG FILE MEMBERS
==============================================================================================
SQL> alter database add logfile member 'e:\oracle\oradata\iacm\redo00001.rdo' to
group 1, 'e:\oracle\oradata\iacm\redo002.rdo' to group 2, 'e:\oracle\oradata\i
acm\redo003.rdo' to group 3;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO03.LOG
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO01.LOG
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
4 ONLINE
E:\ORACLE\ORADATA\IACM\REDO04.RDO
5 ONLINE
E:\ORACLE\ORADATA\IACM\REDO05.RDO
5 ONLINE
E:\ORACLE\ORADATA\IACM\REDO005.RDO
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
1 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO001.RDO
1 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO00001.RDO
2 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO002.RDO
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO003.RDO
10 rows selected.
SQL>
SQL> desc v$logfile;
Name Null? Type
----------------------------------------- -------- ---------------------
GROUP# NUMBER
STATUS VARCHAR2(7)
TYPE VARCHAR2(7)
MEMBER VARCHAR2(513)
SQL> select * from v$logfile where group#=2;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
-------------------------------------------------------------------------
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
2 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO002.RDO
SQL> select member from v$logfile where group#=2;
MEMBER
-------------------------------------------------------------------------
E:\ORACLE\ORADATA\IACM\REDO02.LOG
E:\ORACLE\ORADATA\IACM\REDO002.RDO
SQL> select member from v$logfile where group#=5;
MEMBER
------------------------------------------------------
E:\ORACLE\ORADATA\IACM\REDO05.RDO
E:\ORACLE\ORADATA\IACM\REDO005.RDO
============================================================================================
DROPPING ONLINE REDO LOG FILE MEMBERS
============================================================================================
SQL> alter database drop logfile member 'e:\oracle\oradata\iacm\redo05.rdo';
Database altered.
SQL> select member from v$logfile where group#=5;
MEMBER
--------------------------------------------------------------------------------
E:\ORACLE\ORADATA\IACM\REDO005.RDO
============================================================================================
DROPPING ONLINE REDO LOG FILE GROUPS
===========================================================================================
SQL> alter database drop logfile group 5;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO03.LOG
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO01.LOG
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------
4 ONLINE
E:\ORACLE\ORADATA\IACM\REDO04.RDO
1 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO001.RDO
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO00001.RDO
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO002.RDO
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO003.RDO
8 rows selected.
SQL>
============================================================================================ CLEARING ONLINE REDO LOG FILES
============================================================================================
SQL> alter database clear logfile group 3;
Database altered.
SQL> alter database clear unarchived logfile group 3;
Database altered.
============================================================================================= SWITCHING AND CHECKPOINT
===========================================================================================
SQL> alter system switch logfile;
System altered.
SQL> alter system checkpoint;
System altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO03.LOG
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO01.LOG
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------
4 ONLINE
E:\ORACLE\ORADATA\IACM\REDO04.RDO
1 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO001.RDO
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO00001.RDO
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO002.RDO
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO003.RDO
8 rows selected.
SQL>
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn /as sysdba;
Connected.
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO03.LOG
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO01.LOG
============================================================================================== ADDING ONLINE REDO LOG FILE GROUP
============================================================================================
SQL>
SQL> alter database add logfile group 4 'e:\oracle\oradata\iacm\redo04.rdo' size
10m;
Database altered.
SQL> alter database add logfile group 5 ('e:\oracle\oradata\iacm\redo05.rdo','e:
\oracle\oradata\iacm\redo005.rdo') size 10m;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO03.LOG
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO01.LOG
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
4 ONLINE
E:\ORACLE\ORADATA\IACM\REDO04.RDO
5 ONLINE
E:\ORACLE\ORADATA\IACM\REDO05.RDO
5 ONLINE
E:\ORACLE\ORADATA\IACM\REDO005.RDO
6 rows selected.
SQL>
============================================================================================
ADDING ONLINE REDO LOG FILE MEMBERS
==============================================================================================
SQL> alter database add logfile member 'e:\oracle\oradata\iacm\redo00001.rdo' to
group 1, 'e:\oracle\oradata\iacm\redo002.rdo' to group 2, 'e:\oracle\oradata\i
acm\redo003.rdo' to group 3;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO03.LOG
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO01.LOG
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
4 ONLINE
E:\ORACLE\ORADATA\IACM\REDO04.RDO
5 ONLINE
E:\ORACLE\ORADATA\IACM\REDO05.RDO
5 ONLINE
E:\ORACLE\ORADATA\IACM\REDO005.RDO
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
1 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO001.RDO
1 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO00001.RDO
2 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO002.RDO
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO003.RDO
10 rows selected.
SQL>
SQL> desc v$logfile;
Name Null? Type
----------------------------------------- -------- ---------------------
GROUP# NUMBER
STATUS VARCHAR2(7)
TYPE VARCHAR2(7)
MEMBER VARCHAR2(513)
SQL> select * from v$logfile where group#=2;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
-------------------------------------------------------------------------
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
2 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO002.RDO
SQL> select member from v$logfile where group#=2;
MEMBER
-------------------------------------------------------------------------
E:\ORACLE\ORADATA\IACM\REDO02.LOG
E:\ORACLE\ORADATA\IACM\REDO002.RDO
SQL> select member from v$logfile where group#=5;
MEMBER
------------------------------------------------------
E:\ORACLE\ORADATA\IACM\REDO05.RDO
E:\ORACLE\ORADATA\IACM\REDO005.RDO
============================================================================================
DROPPING ONLINE REDO LOG FILE MEMBERS
============================================================================================
SQL> alter database drop logfile member 'e:\oracle\oradata\iacm\redo05.rdo';
Database altered.
SQL> select member from v$logfile where group#=5;
MEMBER
--------------------------------------------------------------------------------
E:\ORACLE\ORADATA\IACM\REDO005.RDO
============================================================================================
DROPPING ONLINE REDO LOG FILE GROUPS
===========================================================================================
SQL> alter database drop logfile group 5;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO03.LOG
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO01.LOG
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------
4 ONLINE
E:\ORACLE\ORADATA\IACM\REDO04.RDO
1 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO001.RDO
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO00001.RDO
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO002.RDO
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO003.RDO
8 rows selected.
SQL>
============================================================================================ CLEARING ONLINE REDO LOG FILES
============================================================================================
SQL> alter database clear logfile group 3;
Database altered.
SQL> alter database clear unarchived logfile group 3;
Database altered.
============================================================================================= SWITCHING AND CHECKPOINT
===========================================================================================
SQL> alter system switch logfile;
System altered.
SQL> alter system checkpoint;
System altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO03.LOG
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO02.LOG
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO01.LOG
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------
4 ONLINE
E:\ORACLE\ORADATA\IACM\REDO04.RDO
1 INVALID ONLINE
E:\ORACLE\ORADATA\IACM\REDO001.RDO
1 ONLINE
E:\ORACLE\ORADATA\IACM\REDO00001.RDO
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------
2 ONLINE
E:\ORACLE\ORADATA\IACM\REDO002.RDO
3 ONLINE
E:\ORACLE\ORADATA\IACM\REDO003.RDO
8 rows selected.
SQL>
No comments:
Post a Comment