Oracle重做日志文件组-清除
发布时间:2020-12-12 14:26:58 所属栏目:百科 来源:网络整理
导读:启动数据库的最后的选择 一旦清楚 全备份将不可用! 清除group3 SQL alter database clear logfile group 3; Database altered SQL select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_
启动数据库的最后的选择 一旦清楚 全备份将不可用! 清除group3 SQL> alter database clear logfile group 3; 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 13 52428800 512 1 NO INACTIVE 21995736819 2017-9-21 9 21995740613 2017-9-21 1 2 1 14 52428800 512 2 NO CURRENT 21995740613 2017-9-21 1 281474976710 3 1 0 52428800 512 1 NO UNUSED 21995708930 2017-9-21 7 21995736819 2017-9-21 9 切换日志查看 3已重新启用 但是恢复数据需要group 2 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 13 52428800 512 1 NO INACTIVE 21995736819 2017-9-21 9 21995740613 2017-9-21 1 2 1 14 52428800 512 2 NO ACTIVE 21995740613 2017-9-21 1 21995744015 2017-9-21 1 3 1 15 52428800 512 1 NO CURRENT 21995744015 2017-9-21 1 281474976710 SQL> 不归档 清除group3 unarchived 关键字 SQL> alter database clear unarchived logfile group 3; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |