--添加在线日志组
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
3 1 0 52428800 512 1 YES UNUSED 0 0
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
SQL> alter database add logfile group 4('F:\DATA\DATAFILE\MXQ\REDO04.LOG','F:\DATA\DATAFILE\MXQ\REDO05.LOG') size 10m;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
4 1 0 10485760 512 2 YES UNUSED 0 0
3 1 0 52428800 512 1 YES UNUSED 0 0
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
1 ONLINE F:\DATA\DATAFILE\MXQ\REDO01.LOG NO
2 ONLINE F:\DATA\DATAFILE\MXQ\REDO02.LOG NO
3 ONLINE F:\DATA\DATAFILE\MXQ\REDO03.LOG NO
4 ONLINE F:\DATA\DATAFILE\MXQ\REDO04.LOG NO
4 ONLINE F:\DATA\DATAFILE\MXQ\REDO05.LOG NO
--添加日志成员
SQL> ALTER DATABASE ADD LOGFILE MEMBER 'F:\DATA\DATAFILE\MXQ\REDO07.LOG' TO GROUP 4;
Database altered
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
1 ONLINE F:\DATA\DATAFILE\MXQ\REDO01.LOG NO
2 ONLINE F:\DATA\DATAFILE\MXQ\REDO02.LOG NO
3 ONLINE F:\DATA\DATAFILE\MXQ\REDO03.LOG NO
4 ONLINE F:\DATA\REDO06.LOG NO
4 ONLINE F:\DATA\DATAFILE\MXQ\REDO05.LOG NO
4 ONLINE F:\DATA\DATAFILE\MXQ\REDO07.LOG NO
6 rows selected
--删除日志成员
物理文件是不会自动删除需要手动删除日志文件
SQL> ALTER DATABASE drop LOGFILE MEMBER 'F:\DATA\DATAFILE\MXQ\REDO07.LOG';
Database altered
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
1 ONLINE F:\DATA\DATAFILE\MXQ\REDO01.LOG NO
2 ONLINE F:\DATA\DATAFILE\MXQ\REDO02.LOG NO
3 ONLINE F:\DATA\DATAFILE\MXQ\REDO03.LOG NO
4 ONLINE F:\DATA\REDO06.LOG NO
4 ONLINE F:\DATA\DATAFILE\MXQ\REDO05.LOG NO
--删除在线日志组
物理文件是不会自动删除需要手动删除日志文件
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
3 1 0 52428800 512 1 YES UNUSED 0 0
4 1 0 10485760 512 2 YES UNUSED 0 0
SQL> alter database drop logfile group 4;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
3 1 0 52428800 512 1 YES UNUSED 0 0
SQL>
数据要启动mount状态
在把原来物理文件拷贝新的路径下面在执行下面语句进行移动正常重命名
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 3390558208 bytes
Fixed Size 2259920 bytes
Variable Size 1879049264 bytes
Database Buffers 1493172224 bytes
Redo Buffers 16076800 bytes
数据库装载完毕。
SQL> alter database rename file 'F:\DATA\DATAFILE\MXQ\REDO04.LOG' to 'F:\DATA\RE
DO04.LOG';
数据库已更改。
SQL> alter database rename file 'F:\DATA\REDO04.LOG' to 'F:\DATA\REDO06.LOG';
数据库已更改。
SQL> alter database open;
数据库已更改。
--重新初始化在线日志组
SQL> alter database clear logfile group 3;
数据库已更改。
--重新初始化当前没有归档在线日志住
SQL> alter database clear unarchived logfile group 1;
数据库已更改。
在线调整在线日志组大小
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
3 1 0 52428800 512 1 YES UNUSED 0 0
--添加两个日志组
SQL> alter database add logfile group 4('F:\DATA\DATAFILE\MXQ\REDO04.LOG') size 100m;
Database altered
SQL>
SQL> alter database add logfile group 5('F:\DATA\DATAFILE\MXQ\REDO05.LOG') size 100m;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
3 1 0 52428800 512 1 YES UNUSED 0 0
4 1 0 104857600 512 1 YES UNUSED 0 0
5 1 0 104857600 512 1 YES UNUSED 0 0
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 3 52428800 512 1 NO CURRENT 1342022 2015/5/9 22 281474976710
2 1 2 52428800 512 1 YES ACTIVE 1339339 2015/5/9 21 1342022 2015/5/9 22
3 1 0 52428800 512 1 YES UNUSED 0 0
4 1 0 104857600 512 1 YES UNUSED 0 0
5 1 0 104857600 512 1 YES UNUSED 0 0
--切换日志两次
SQL> alter system checkpoint;
System altered
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 3 52428800 512 1 YES ACTIVE 1342022 2015/5/9 22 1342068 2015/5/9 22
2 1 2 52428800 512 1 YES ACTIVE 1339339 2015/5/9 21 1342022 2015/5/9 22
3 1 4 52428800 512 1 YES ACTIVE 1342068 2015/5/9 22 1342078 2015/5/9 22
4 1 5 104857600 512 1 NO CURRENT 1342078 2015/5/9 22 281474976710
5 1 0 104857600 512 1 YES UNUSED 0 0
--让在日志组归档
SQL> alter system checkpoint;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 3 52428800 512 1 YES INACTIVE 1342022 2015/5/9 22 1342068 2015/5/9 22
2 1 2 52428800 512 1 YES INACTIVE 1339339 2015/5/9 21 1342022 2015/5/9 22
3 1 4 52428800 512 1 YES INACTIVE 1342068 2015/5/9 22 1342078 2015/5/9 22
4 1 5 104857600 512 1 NO CURRENT 1342078 2015/5/9 22 281474976710
5 1 0 104857600 512 1 YES UNUSED 0 0
--删除在线日志组1、2、3
SQL> alter database drop logfile group 1;
Database altered
SQL> alter database drop logfile group 2;
Database altered
SQL> alter database drop logfile group 3;
Database altered
--添加在日志组1、2、3
SQL> alter database add logfile group 1('F:\DATA\DATAFILE\MXQ\REDO01.LOG') size 100m;
Database altered
SQL> alter database add logfile group 2('F:\DATA\DATAFILE\MXQ\REDO02.LOG') size 100m;
Database altered
SQL> alter database add logfile group 3('F:\DATA\DATAFILE\MXQ\REDO03.LOG') size 100m;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 104857600 512 1 YES UNUSED 0 0
2 1 0 104857600 512 1 YES UNUSED 0 0
3 1 0 104857600 512 1 YES UNUSED 0 0
4 1 5 104857600 512 1 NO CURRENT 1342078 2015/5/9 22 281474976710
5 1 0 104857600 512 1 YES UNUSED 0 0
--切换日志两次
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system checkpoint;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 6 104857600 512 1 YES INACTIVE 1342251 2015/5/9 22 1342254 2015/5/9 22
2 1 7 104857600 512 1 NO CURRENT 1342254 2015/5/9 22 281474976710
3 1 0 104857600 512 1 YES UNUSED 0 0
4 1 5 104857600 512 1 YES INACTIVE 1342078 2015/5/9 22 1342251 2015/5/9 22
5 1 0 104857600 512 1 YES UNUSED 0 0
--删除在线日志组4、5
SQL> alter database drop logfile group 4;
Database altered
SQL> alter database drop logfile group 5;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 6 104857600 512 1 YES INACTIVE 1342251 2015/5/9 22 1342254 2015/5/9 22
2 1 7 104857600 512 1 NO CURRENT 1342254 2015/5/9 22 281474976710
3 1 0 104857600 512 1 YES UNUSED 0 0
ADD LOGFILE GOURP COMPLETE
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
3 1 0 52428800 512 1 YES UNUSED 0 0
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
SQL> alter database add logfile group 4('F:\DATA\DATAFILE\MXQ\REDO04.LOG','F:\DATA\DATAFILE\MXQ\REDO05.LOG') size 10m;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
4 1 0 10485760 512 2 YES UNUSED 0 0
3 1 0 52428800 512 1 YES UNUSED 0 0
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
1 ONLINE F:\DATA\DATAFILE\MXQ\REDO01.LOG NO
2 ONLINE F:\DATA\DATAFILE\MXQ\REDO02.LOG NO
3 ONLINE F:\DATA\DATAFILE\MXQ\REDO03.LOG NO
4 ONLINE F:\DATA\DATAFILE\MXQ\REDO04.LOG NO
4 ONLINE F:\DATA\DATAFILE\MXQ\REDO05.LOG NO
--添加日志成员
SQL> ALTER DATABASE ADD LOGFILE MEMBER 'F:\DATA\DATAFILE\MXQ\REDO07.LOG' TO GROUP 4;
Database altered
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
1 ONLINE F:\DATA\DATAFILE\MXQ\REDO01.LOG NO
2 ONLINE F:\DATA\DATAFILE\MXQ\REDO02.LOG NO
3 ONLINE F:\DATA\DATAFILE\MXQ\REDO03.LOG NO
4 ONLINE F:\DATA\REDO06.LOG NO
4 ONLINE F:\DATA\DATAFILE\MXQ\REDO05.LOG NO
4 ONLINE F:\DATA\DATAFILE\MXQ\REDO07.LOG NO
6 rows selected
--删除日志成员
物理文件是不会自动删除需要手动删除日志文件
SQL> ALTER DATABASE drop LOGFILE MEMBER 'F:\DATA\DATAFILE\MXQ\REDO07.LOG';
Database altered
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
1 ONLINE F:\DATA\DATAFILE\MXQ\REDO01.LOG NO
2 ONLINE F:\DATA\DATAFILE\MXQ\REDO02.LOG NO
3 ONLINE F:\DATA\DATAFILE\MXQ\REDO03.LOG NO
4 ONLINE F:\DATA\REDO06.LOG NO
4 ONLINE F:\DATA\DATAFILE\MXQ\REDO05.LOG NO
--删除在线日志组
物理文件是不会自动删除需要手动删除日志文件
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
3 1 0 52428800 512 1 YES UNUSED 0 0
4 1 0 10485760 512 2 YES UNUSED 0 0
SQL> alter database drop logfile group 4;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
3 1 0 52428800 512 1 YES UNUSED 0 0
SQL>
数据要启动mount状态
在把原来物理文件拷贝新的路径下面在执行下面语句进行移动正常重命名
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 3390558208 bytes
Fixed Size 2259920 bytes
Variable Size 1879049264 bytes
Database Buffers 1493172224 bytes
Redo Buffers 16076800 bytes
数据库装载完毕。
SQL> alter database rename file 'F:\DATA\DATAFILE\MXQ\REDO04.LOG' to 'F:\DATA\RE
DO04.LOG';
数据库已更改。
SQL> alter database rename file 'F:\DATA\REDO04.LOG' to 'F:\DATA\REDO06.LOG';
数据库已更改。
SQL> alter database open;
数据库已更改。
--重新初始化在线日志组
SQL> alter database clear logfile group 3;
数据库已更改。
--重新初始化当前没有归档在线日志住
SQL> alter database clear unarchived logfile group 1;
数据库已更改。
在线调整在线日志组大小
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
3 1 0 52428800 512 1 YES UNUSED 0 0
--添加两个日志组
SQL> alter database add logfile group 4('F:\DATA\DATAFILE\MXQ\REDO04.LOG') size 100m;
Database altered
SQL>
SQL> alter database add logfile group 5('F:\DATA\DATAFILE\MXQ\REDO05.LOG') size 100m;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 52428800 512 1 YES UNUSED 1339338 2015/5/9 21 1339339 2015/5/9 21
2 1 2 52428800 512 1 NO CURRENT 1339339 2015/5/9 21 281474976710
3 1 0 52428800 512 1 YES UNUSED 0 0
4 1 0 104857600 512 1 YES UNUSED 0 0
5 1 0 104857600 512 1 YES UNUSED 0 0
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 3 52428800 512 1 NO CURRENT 1342022 2015/5/9 22 281474976710
2 1 2 52428800 512 1 YES ACTIVE 1339339 2015/5/9 21 1342022 2015/5/9 22
3 1 0 52428800 512 1 YES UNUSED 0 0
4 1 0 104857600 512 1 YES UNUSED 0 0
5 1 0 104857600 512 1 YES UNUSED 0 0
--切换日志两次
SQL> alter system checkpoint;
System altered
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 3 52428800 512 1 YES ACTIVE 1342022 2015/5/9 22 1342068 2015/5/9 22
2 1 2 52428800 512 1 YES ACTIVE 1339339 2015/5/9 21 1342022 2015/5/9 22
3 1 4 52428800 512 1 YES ACTIVE 1342068 2015/5/9 22 1342078 2015/5/9 22
4 1 5 104857600 512 1 NO CURRENT 1342078 2015/5/9 22 281474976710
5 1 0 104857600 512 1 YES UNUSED 0 0
--让在日志组归档
SQL> alter system checkpoint;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 3 52428800 512 1 YES INACTIVE 1342022 2015/5/9 22 1342068 2015/5/9 22
2 1 2 52428800 512 1 YES INACTIVE 1339339 2015/5/9 21 1342022 2015/5/9 22
3 1 4 52428800 512 1 YES INACTIVE 1342068 2015/5/9 22 1342078 2015/5/9 22
4 1 5 104857600 512 1 NO CURRENT 1342078 2015/5/9 22 281474976710
5 1 0 104857600 512 1 YES UNUSED 0 0
--删除在线日志组1、2、3
SQL> alter database drop logfile group 1;
Database altered
SQL> alter database drop logfile group 2;
Database altered
SQL> alter database drop logfile group 3;
Database altered
--添加在日志组1、2、3
SQL> alter database add logfile group 1('F:\DATA\DATAFILE\MXQ\REDO01.LOG') size 100m;
Database altered
SQL> alter database add logfile group 2('F:\DATA\DATAFILE\MXQ\REDO02.LOG') size 100m;
Database altered
SQL> alter database add logfile group 3('F:\DATA\DATAFILE\MXQ\REDO03.LOG') size 100m;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 0 104857600 512 1 YES UNUSED 0 0
2 1 0 104857600 512 1 YES UNUSED 0 0
3 1 0 104857600 512 1 YES UNUSED 0 0
4 1 5 104857600 512 1 NO CURRENT 1342078 2015/5/9 22 281474976710
5 1 0 104857600 512 1 YES UNUSED 0 0
--切换日志两次
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system checkpoint;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 6 104857600 512 1 YES INACTIVE 1342251 2015/5/9 22 1342254 2015/5/9 22
2 1 7 104857600 512 1 NO CURRENT 1342254 2015/5/9 22 281474976710
3 1 0 104857600 512 1 YES UNUSED 0 0
4 1 5 104857600 512 1 YES INACTIVE 1342078 2015/5/9 22 1342251 2015/5/9 22
5 1 0 104857600 512 1 YES UNUSED 0 0
--删除在线日志组4、5
SQL> alter database drop logfile group 4;
Database altered
SQL> alter database drop logfile group 5;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 6 104857600 512 1 YES INACTIVE 1342251 2015/5/9 22 1342254 2015/5/9 22
2 1 7 104857600 512 1 NO CURRENT 1342254 2015/5/9 22 281474976710
3 1 0 104857600 512 1 YES UNUSED 0 0
ADD LOGFILE GOURP COMPLETE
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29065182/viewspace-1631744/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29065182/viewspace-1631744/