GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
1 1 105597 419430400 2 NO ACTIVE 2.4815E+10 2013-03-02 15:41:40
2 1 105598 419430400 2 NO CURRENT 2.4815E+10 2013-03-02 15:43:21
3 1 105595 419430400 2 NO ACTIVE 2.4815E+10 2013-03-02 15:38:01
4 1 105596 419430400 2 NO ACTIVE 2.4815E+10 2013-03-02 15:39:29
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---
1 ONLINE +DATA1/orcl/onlinelog/group_1.258.784499383 NO
1 ONLINE +DATA1/orcl/onlinelog/group_1.259.784499435 YES
2 ONLINE +DATA1/orcl/onlinelog/group_2.260.784499481 NO
2 ONLINE +DATA1/orcl/onlinelog/group_2.261.784499527 YES
3 ONLINE +DATA1/orcl/onlinelog/group_3.262.784499571 NO
3 ONLINE +DATA1/orcl/onlinelog/group_3.263.784499621 YES
4 ONLINE +DATA1/orcl/onlinelog/group_4.264.784499667 NO
4 ONLINE +DATA1/orcl/onlinelog/group_4.265.784499717 YES
8 rows selected.
ASMCMD> pwd
+DATA1/ORCL/ONLINELOG
ASMCMD> ls -l
Type Redund Striped Time Sys Name
ONLINELOG UNPROT FINE FEB 23 10:00:00 Y group_1.258.784499383
ONLINELOG UNPROT FINE FEB 23 10:00:00 Y group_1.259.784499435
ONLINELOG UNPROT FINE FEB 23 10:00:00 Y group_2.260.784499481
ONLINELOG UNPROT FINE FEB 23 10:00:00 Y group_2.261.784499527
ONLINELOG UNPROT FINE FEB 23 10:00:00 Y group_3.262.784499571
ONLINELOG UNPROT FINE FEB 23 10:00:00 Y group_3.263.784499621
ONLINELOG UNPROT FINE FEB 23 10:00:00 Y group_4.264.784499667
ONLINELOG UNPROT FINE FEB 23 10:00:00 Y group_4.265.784499717
ASMCMD>
备份参数文件
SQL> create pfile='/opt/oracle/liu/pfile_20130302.ora' from spfile;
File created.
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /opt/oracle/product/11gR1/db/d
bs/spfileorcl.ora
备份控制文件
SQL> alter database backup controlfile to '/opt/oracle/liu/controlfile_20130302.ctl';
Database altered.
增加第五个日志组,并在每个日志组里添加两个日志文件,大小800M
SQL> alter database add logfile group 5 ('+DATA1/orcl/onlinelog/group_5.266','+DATA1/orcl/onlinelog/group_5.267') size 800M;
Database altered.
SQL> alter database add logfile group 6 size 400M;
Database altered.
SQL>
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
1 1 105781 419430400 2 NO INACTIVE 2.4854E+10 2013-03-02 22:54:22
2 1 105783 419430400 2 NO INACTIVE 2.4855E+10 2013-03-02 23:02:15
3 1 105784 419430400 2 NO ACTIVE 2.4855E+10 2013-03-02 23:06:01
4 1 105780 419430400 2 NO INACTIVE 2.4854E+10 2013-03-02 22:51:36
5 1 105782 838860800 2 NO INACTIVE 2.4854E+10 2013-03-02 22:57:33
6 1 105785 419430400 2 NO CURRENT 2.4855E+10 2013-03-02 23:09:49
7 1 0 419430400 2 YES UNUSED 0
8 1 0 419430400 2 YES UNUSED 0
8 rows selected.
SQL> alter database drop logfile group 5;
删除第五组日志
Database altered.
SQL> SQL>
SQL> alter database add logfile group 5 size 400M;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
1 1 105781 419430400 2 NO INACTIVE 2.4854E+10 2013-03-02 22:54:22
2 1 105783 419430400 2 NO INACTIVE 2.4855E+10 2013-03-02 23:02:15
3 1 105784 419430400 2 NO ACTIVE 2.4855E+10 2013-03-02 23:06:01
4 1 105780 419430400 2 NO INACTIVE 2.4854E+10 2013-03-02 22:51:36
5 1 0 419430400 2 YES UNUSED 0
6 1 105785 419430400 2 NO ACTIVE 2.4855E+10 2013-03-02 23:09:49
7 1 105786 419430400 2 NO CURRENT 2.4856E+10 2013-03-02 23:14:13
8 1 0 419430400 2 YES UNUSED 0