重做日志文件管理(增,删,改,查,切)

《重做日志文件管理(增,删,改,查,切)》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、【实验】重做日志文件（redologfiles）管理（增，删，改，查，切）上-篇/下一篇2009-03-0917:39:30/天气天气不错，能看到蓝天/心情：高兴/个人分类：Oracle杳看（46）/评论（0）/评分（0/0）1•当前日志相关信息sys@orallg>select*fromv$log;sys@orallg>select*fromv$logfile;GROUP#STATUSTYPEMEMBERIS_ONLINE/oracle/u02/oradata/orallg/redoOl.logNOONLINE/oracle/u02/oradata/orallg/redo0

2、2•logNOGROUP#THREAD#SEQUENCE#BYTESMEMBERSARCSTATUSFIRST_CHANGE#FIRST_TIM11102097152001YESINACTIVE46193809-MAR-0921112097152001NOCURRENT48588509-MAR-093192097152001YESINACTIVE43263604—MAR—09ONLINE/oracle/u02/oradata/orallg/redo03•logNO1•添加重做日志组sys@orallg>alterdatabaseaddlogfilegroup4(1/oracl

3、e/u02/oradate/orallg/redoO4_01.logf,1/oracle/u02/oradata/orallg/redo04_02.log1)size50m;Databasealtered.sys@orallg>select*fromv$log;GROUP#THREAD#SEQUENCE#BYTESMEMBERSARCSTATUSFIRST—CHANGE#FIRST_TIM11102097152001YESINACTIVE46193809-MAR-0921112097152001NOCURRENT48588509-MAR-093192097152001YESI

4、NACTIVE43263604-MAR-09410524288002YESUNUSED01ONLINE/oracle/u02/oradata/orallg/redoOl.logNO2ONLINE/oracle/u02/oradata/orallg/redo02•logNO3ONLINE/oracle/u02/oradata/orallg/redo03.logNO4ONLINE/oracle/u02/oradata/orallg/redo04_01.logNO4ONLINE/oracle/u02/oradata/orallg/redo04_02•logNOtogroup1,to

5、group乙togroup3;1•添加日志文件sys@orallg>alterdatabaseaddlogfilemember*/oracle/u02/oradata/orallg/redo01_02•log11/oracle/u02/oradata/orallg/redo02_02.log11/oracle/u02/oradata/orallg/redo03_02.log1Databasealtered•GROUP#THREAD#SEQUENCE#BYTESMEMBERSARCSTATUSFIRST_CHANGE#FIRST_TIM11102097152002YESINAC

6、TIVE46193809-MAR-0921112097152002NOCURRENT48588509-MAR-093192097152002YESINACTIVE43263604-MAR-09410524288002YESUNUSED0sys@orallg>select*fromv$logfileorderby1;GROUP#STATUSTYPEMEMBERIS1ONLINE/oracle/u02/oradata/orallg/redo01•logNO1INVALIDONLINE/oracle/u02/oradata/orallg/redoOl_02.logNO2INVALI

7、DONLINE/oracle/u02/oradata/orallg/redoO2_02.logNO2ONLINE/oracle/u02/oradata/ora1lg/redoO2•logNO3ONLINE/oracle/u02/oradata/orallg/redo03.logNO3INVALIDONLINE/oracle/u02/oradata/orallg/redo03_02•logNO4ONLINE4ONLINE/oracle/u02/oradata/ora1lg/redoO4_02.logNO/