- 论坛徽章:
- 3
|
备份参数文件
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
8 rows selected.
SQL>
ASMCMD> ls -s
Block_Size Blocks Bytes Space Name
512 819201 419430912 428867584 group_1.258.784499383
512 819201 419430912 428867584 group_1.259.784499435
512 819201 419430912 428867584 group_2.260.784499481
512 819201 419430912 428867584 group_2.261.784499527
512 819201 419430912 428867584 group_3.262.784499571
512 819201 419430912 428867584 group_3.263.784499621
512 819201 419430912 428867584 group_4.264.784499667
512 819201 419430912 428867584 group_4.265.784499717
group_5.266 => +DATA1/ORCL/ONLINELOG/group_5.274.809045727
group_5.267 => +DATA1/ORCL/ONLINELOG/group_5.275.809045745
512 1638401 838861312 848297984 group_5.274.809045727
512 1638401 838861312 848297984 group_5.275.809045745
512 819201 419430912 428867584 group_5.282.809046857
512 819201 419430912 428867584 group_5.283.809046867
512 819201 419430912 428867584 group_6.276.809046369
512 819201 419430912 428867584 group_6.277.809046381
512 819201 419430912 428867584 group_7.278.809046517
512 819201 419430912 428867584 group_7.279.809046525
512 819201 419430912 428867584 group_8.280.809046555
512 819201 419430912 428867584 group_8.281.809046565
删除之前组5的日志文件
ASMCMD> rm +DATA1/ORCL/ONLINELOG/group_5.274.809045727
ASMCMD> rm +DATA1/ORCL/ONLINELOG/group_5.275.809045745
ASMCMD> ls -s
Block_Size Blocks Bytes Space Name
512 819201 419430912 428867584 group_1.258.784499383
512 819201 419430912 428867584 group_1.259.784499435
512 819201 419430912 428867584 group_2.260.784499481
512 819201 419430912 428867584 group_2.261.784499527
512 819201 419430912 428867584 group_3.262.784499571
512 819201 419430912 428867584 group_3.263.784499621
512 819201 419430912 428867584 group_4.264.784499667
512 819201 419430912 428867584 group_4.265.784499717
512 819201 419430912 428867584 group_5.282.809046857
512 819201 419430912 428867584 group_5.283.809046867
512 819201 419430912 428867584 group_6.276.809046369
512 819201 419430912 428867584 group_6.277.809046381
512 819201 419430912 428867584 group_7.278.809046517
512 819201 419430912 428867584 group_7.279.809046525
512 819201 419430912 428867584 group_8.280.809046555
512 819201 419430912 428867584 group_8.281.809046565
ASMCMD>
已经解决了。谢谢大家 |
|