11G R2 重做redo日志

xiaoxiao2021-02-28 60

先闲扯下这几天开发那边做一些大量数据操作cpu负载很高，而且发现归档目录被写满了造成用户登录不上，就赶紧进行处理，处理过程就是用rman，将前几天archivelog删除，再用rman进行全备份一次。归档目录大小根据业务来定，我的目录是80G，通常情况下可以用15天左右，后续会做相关调整。偷袭就用了2天，所以开发在做大量数据前务必通知数据库相关维护人员。当时开发做的数据量超过1亿。然后就带看了下alter日志发现，redo日志切换的很快，一分钟切三四次下面是8点到8点半的归档一个归档文件大概是将近50M,网上找了一些资料看到redo切换时间控制在15-30分钟之间，如果redo切换间距时间太长容易数据丢失, 也就是如果redo切换间距时间为1小时，如果在这个一小时内当前的redo文件被损坏，那你哭吧。俺小白是这样理解的不知道各位大神是怎么样理解的。后来就重做redo日志，查看归档到8：20归档大概是37个 50mx37=1850m, 8:15是50mx27=1325m, 最后将redo大小设为1024m，也就是1G，再后来重做redo已经做好了，但redo将近3个小时没有切换，手工切换正常，原来是开发大数据量已经做完了。呵呵，苦逼了。那怎么办呢，然后就找个开发和业务之间平衡点，然后又重做redo，将redo设定700m,在业务方面大概是15到25切一次，开发大数据量大概是7分钟切一次。上面是一些闲扯，俺小白，也不知道上面所做的是否合理，如果是大数据量都要每次重做redo吗，还是怎么着，带继续研究。

下面是重做redo全过程。大小为1024m的操作，700m的没有记录，操作方法一样只是改下redo大小

-rw-r----- 1 oracle oinstall 47512064 May 5 08:00 o1_mf_1_17287_djqj4l49_.arc -rw-r----- 1 oracle oinstall 49789440 May 5 08:00 o1_mf_1_17288_djqj56f5_.arc -rw-r----- 1 oracle oinstall 49543680 May 5 08:01 o1_mf_1_17289_djqj6k4k_.arc -rw-r----- 1 oracle oinstall 50039808 May 5 08:01 o1_mf_1_17290_djqj7jg0_.arc -rw-r----- 1 oracle oinstall 48469504 May 5 08:02 o1_mf_1_17291_djqj8f1r_.arc -rw-r----- 1 oracle oinstall 48882688 May 5 08:02 o1_mf_1_17292_djqj9lmj_.arc -rw-r----- 1 oracle oinstall 47800832 May 5 08:03 o1_mf_1_17293_djqjbh26_.arc -rw-r----- 1 oracle oinstall 48790528 May 5 08:03 o1_mf_1_17294_djqjcdyq_.arc -rw-r----- 1 oracle oinstall 50202624 May 5 08:04 o1_mf_1_17295_djqjdn8l_.arc -rw-r----- 1 oracle oinstall 48251392 May 5 08:04 o1_mf_1_17296_djqjf9z0_.arc -rw-r----- 1 oracle oinstall 50376704 May 5 08:05 o1_mf_1_17297_djqjgr0f_.arc -rw-r----- 1 oracle oinstall 47847424 May 5 08:06 o1_mf_1_17298_djqjhfqt_.arc -rw-r----- 1 oracle oinstall 48000000 May 5 08:06 o1_mf_1_17299_djqjjwvl_.arc -rw-r----- 1 oracle oinstall 46934528 May 5 08:07 o1_mf_1_17300_djqjkpyj_.arc -rw-r----- 1 oracle oinstall 49249280 May 5 08:08 o1_mf_1_17301_djqjm2qp_.arc -rw-r----- 1 oracle oinstall 48714240 May 5 08:08 o1_mf_1_17302_djqjn8sn_.arc -rw-r----- 1 oracle oinstall 50082304 May 5 08:09 o1_mf_1_17303_djqjok95_.arc -rw-r----- 1 oracle oinstall 50543616 May 5 08:09 o1_mf_1_17304_djqjp9yo_.arc -rw-r----- 1 oracle oinstall 50254336 May 5 08:10 o1_mf_1_17305_djqjqk57_.arc -rw-r----- 1 oracle oinstall 50699264 May 5 08:11 o1_mf_1_17306_djqjro2z_.arc -rw-r----- 1 oracle oinstall 48658432 May 5 08:11 o1_mf_1_17307_djqjsltc_.arc -rw-r----- 1 oracle oinstall 50687488 May 5 08:12 o1_mf_1_17308_djqjtx8t_.arc -rw-r----- 1 oracle oinstall 49117184 May 5 08:12 o1_mf_1_17309_djqjvoh3_.arc -rw-r----- 1 oracle oinstall 48347648 May 5 08:13 o1_mf_1_17310_djqjx0yv_.arc -rw-r----- 1 oracle oinstall 48188416 May 5 08:13 o1_mf_1_17311_djqjxt80_.arc -rw-r----- 1 oracle oinstall 48316928 May 5 08:14 o1_mf_1_17312_djqjyqox_.arc -rw-r----- 1 oracle oinstall 49675264 May 5 08:14 o1_mf_1_17313_djqjzx8p_.arc -rw-r----- 1 oracle oinstall 49580032 May 5 08:15 o1_mf_1_17314_djqk14mw_.arc -rw-r----- 1 oracle oinstall 50041344 May 5 08:16 o1_mf_1_17315_djqk2goo_.arc -rw-r----- 1 oracle oinstall 50118656 May 5 08:16 o1_mf_1_17316_djqk3f8v_.arc -rw-r----- 1 oracle oinstall 46252032 May 5 08:17 o1_mf_1_17317_djqk44vj_.arc -rw-r----- 1 oracle oinstall 49716736 May 5 08:17 o1_mf_1_17318_djqk5gt5_.arc -rw-r----- 1 oracle oinstall 50482688 May 5 08:18 o1_mf_1_17319_djqk6f6f_.arc -rw-r----- 1 oracle oinstall 47356416 May 5 08:18 o1_mf_1_17320_djqk7jsl_.arc -rw-r----- 1 oracle oinstall 49062400 May 5 08:19 o1_mf_1_17321_djqk8d2d_.arc -rw-r----- 1 oracle oinstall 49636864 May 5 08:20 o1_mf_1_17322_djqk9ksp_.arc -rw-r----- 1 oracle oinstall 50674688 May 5 08:20 o1_mf_1_17323_djqkbm5p_.arc -rw-r----- 1 oracle oinstall 50206208 May 5 08:21 o1_mf_1_17324_djqkcn9v_.arc -rw-r----- 1 oracle oinstall 49163776 May 5 08:21 o1_mf_1_17325_djqkdnq3_.arc -rw-r----- 1 oracle oinstall 50273792 May 5 08:22 o1_mf_1_17326_djqkfx8l_.arc -rw-r----- 1 oracle oinstall 49967104 May 5 08:22 o1_mf_1_17327_djqkgyyd_.arc -rw-r----- 1 oracle oinstall 49219584 May 5 08:23 o1_mf_1_17328_djqkj864_.arc -rw-r----- 1 oracle oinstall 48971776 May 5 08:24 o1_mf_1_17329_djqkkd3o_.arc -rw-r----- 1 oracle oinstall 49022976 May 5 08:24 o1_mf_1_17330_djqklf9q_.arc -rw-r----- 1 oracle oinstall 47977984 May 5 08:25 o1_mf_1_17331_djqkmor0_.arc -rw-r----- 1 oracle oinstall 50620928 May 5 08:25 o1_mf_1_17332_djqknj90_.arc -rw-r----- 1 oracle oinstall 46109184 May 5 08:26 o1_mf_1_17333_djqkoxkb_.arc -rw-r----- 1 oracle oinstall 46856704 May 5 08:27 o1_mf_1_17334_djqkptnp_.arc -rw-r----- 1 oracle oinstall 50667008 May 5 08:27 o1_mf_1_17335_djqkqth2_.arc -rw-r----- 1 oracle oinstall 47429632 May 5 08:28 o1_mf_1_17336_djqks7dx_.arc -rw-r----- 1 oracle oinstall 50085376 May 5 08:28 o1_mf_1_17337_djqktc9k_.arc -rw-r----- 1 oracle oinstall 49784320 May 5 08:29 o1_mf_1_17338_djqkvdm5_.arc -rw-r----- 1 oracle oinstall 49842688 May 5 08:30 o1_mf_1_17339_djqkwf9f_.arc -rw-r----- 1 oracle oinstall 47106048 May 5 08:30 o1_mf_1_17340_djqkxj6f_.arc 一 1，查看redo我的是一个组是一个文件，有5个组

SQL> select * from v$logfile; GROUP# STATUS TYPE ---------- -------------- -------------- MEMBER -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- IS_REC ------ 3 ONLINE /oracle/app/oradata/shpog/redo03.log NO 2 ONLINE /oracle/app/oradata/shpog/redo02.log NO GROUP# STATUS TYPE ---------- -------------- -------------- MEMBER -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- IS_REC ------ 1 ONLINE /oracle/app/oradata/shpog/redo01.log NO 4 ONLINE /oracle/app/oradata/shpog/redo04.log GROUP# STATUS TYPE ---------- -------------- -------------- MEMBER -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- IS_REC ------ NO 5 ONLINE /oracle/app/oradata/shpog/redo05.log NO 2，查看redo的大小是50m SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 CURRENT 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 INACTIVE 3,redo路径

SQL> SELECT group#,member FROM v$logfile; GROUP# ---------- MEMBER -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3 /oracle/app/oradata/shpog/redo03.log 2 /oracle/app/oradata/shpog/redo02.log 1 /oracle/app/oradata/shpog/redo01.log GROUP# ---------- MEMBER -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4 /oracle/app/oradata/shpog/redo04.log 5 /oracle/app/oradata/shpog/redo05.log SQL> SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 CURRENT 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 INACTIVE4,切换日志到合适位置 SQL> alter system switch logfile; System altered. SQL> SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 ACTIVE 2 1 50 ACTIVE 3 1 50 ACTIVE 4 1 50 ACTIVE 5 1 50 CURRENT SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 CURRENT 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 INACTIVE 5，检查点 SQL> alter system checkpoint; System altered. SQL> 6 ，添加redo 6,7,8，三个redo组

SQL> alter database add logfile group 6 '/oracle/app/oradata/shpog/redo03.log' size 1024M; alter database add logfile group 6 '/oracle/app/oradata/shpog/redo03.log' size 1024M * ERROR at line 1: ORA-01577: cannot add log file '/oracle/app/oradata/shpog/redo03.log' - file already part of database SQL> alter database add logfile group 6 '/oracle/app/oradata/shpog/redo06.log' size 1024M; Database altered. SQL> alter database add logfile group 7 '/oracle/app/oradata/shpog/redo07.log' size 1024M; Database altered. SQL> SQL> alter database add logfile group 8 '/oracle/app/oradata/shpog/redo08.log' size 1024M; Database altered. 7，查看redo SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 CURRENT 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 INACTIVE 6 1 1024 UNUSED 7 1 1024 UNUSED 8 1 1024 UNUSED 8 rows selected. 8，切换全部redo

SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> SQL> alter system switch logfile; System altered. SQL> SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 ACTIVE 2 1 50 ACTIVE 3 1 50 CURRENT 4 1 50 INACTIVE 5 1 50 INACTIVE 6 1 1024 ACTIVE 7 1 1024 ACTIVE 8 1 1024 ACTIVE 8 rows selected. 9，检查点

SQL> alter system checkpoint; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 INACTIVE 2 1 50 INACTIVE 3 1 50 CURRENT 4 1 50 INACTIVE 5 1 50 INACTIVE 6 1 1024 INACTIVE 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected. SQL> SQL> SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 INACTIVE 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 CURRENT 5 1 50 INACTIVE 6 1 1024 INACTIVE 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected. SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 CURRENT 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 INACTIVE 6 1 1024 INACTIVE 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected. SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 INACTIVE 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 INACTIVE 6 1 1024 INACTIVE 7 1 1024 ACTIVE 8 1 1024 CURRENT 8 rows selected. SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 INACTIVE 2 1 50 CURRENT 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 INACTIVE 6 1 1024 INACTIVE 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected. SQL> SQL> SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 INACTIVE 2 1 50 CURRENT 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 INACTIVE 6 1 1024 INACTIVE 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected. SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 INACTIVE 2 1 50 INACTIVE 3 1 50 CURRENT 4 1 50 INACTIVE 5 1 50 INACTIVE 6 1 1024 INACTIVE 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected. SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 INACTIVE 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 CURRENT 5 1 50 INACTIVE 6 1 1024 INACTIVE 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected. SQL> SQL> SQL> alter system switch logfile; System altered. SQL> SQL> SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 INACTIVE 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 CURRENT 6 1 1024 INACTIVE 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected. SQL> SQL> SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 CURRENT 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 INACTIVE 6 1 1024 INACTIVE 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected. 10 ，将redo切换到合适位置

SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 ACTIVE 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 INACTIVE 6 1 1024 CURRENT 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected. SQL> alter system checkpoint; System altered. SQL> SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 50 INACTIVE 2 1 50 INACTIVE 3 1 50 INACTIVE 4 1 50 INACTIVE 5 1 50 INACTIVE 6 1 1024 CURRENT 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected.11，删除redo 1,2,3,4,5 组 SQL> alter database drop logfile group 1; Database altered. SQL> SQL> SQL> alter database drop logfile group 2; Database altered. SQL> alter database drop logfile group 3; Database altered. SQL> alter database drop logfile group 4; Database altered. SQL> alter database drop logfile group 5; Database altered. SQL> SQL> SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 6 1 1024 CURRENT 7 1 1024 INACTIVE 8 1 1024 INACTIVE SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 6 1 1024 ACTIVE 7 1 1024 CURRENT 8 1 1024 INACTIVE SQL> alter system checkpoint; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 6 1 1024 INACTIVE 7 1 1024 CURRENT 8 1 1024 INACTIVE SQL> SQL> SQL> exit Disconnected from Oracle Database 11g Release 11.2.0.1.0 - 64bit Production [oracle@POGBAK ~]$ cd /oracle/app/oradata/shpog/ [oracle@POGBAK shpog]$ ll total 57750736 -rw-r----- 1 oracle oinstall 10862592 May 5 11:56 control01.ctl -rw-r----- 1 oracle oinstall 104865792 May 5 11:56 example01.dbf -rw-r----- 1 oracle oinstall 52429312 May 5 11:54 redo01.log -rw-r----- 1 oracle oinstall 52429312 May 5 11:54 redo02.log -rw-r----- 1 oracle oinstall 52429312 May 5 11:54 redo03.log -rw-r----- 1 oracle oinstall 52429312 May 5 11:54 redo04.log -rw-r----- 1 oracle oinstall 52429312 May 5 11:54 redo05.log -rw-r----- 1 oracle oinstall 1073742336 May 5 11:56 redo06.log -rw-r----- 1 oracle oinstall 1073742336 May 5 11:56 redo07.log -rw-r----- 1 oracle oinstall 1073742336 May 5 11:53 redo08.log -rw-r----- 1 oracle oinstall 5368717312 May 5 11:56 sysaux01.dbf -rw-r----- 1 oracle oinstall 4294975488 May 5 11:56 system01.dbf -rw-r----- 1 oracle oinstall 3326091264 May 4 22:00 temp01.dbf -rw-r----- 1 oracle oinstall 1745887232 May 5 11:56 undotbs01.dbf -rw-r----- 1 oracle oinstall 2147491840 May 5 11:56 undotbs02.dbf -rw-r----- 1 oracle oinstall 21474844672 May 5 11:56 users01.dbf -rw-r----- 1 oracle oinstall 17179877376 May 5 11:56 users02.dbf 12，在系统上删除redo1,2,3,4,5 文件 [oracle@POGBAK shpog]$ rm -rf redo01.log [oracle@POGBAK shpog]$ rm -rf redo02.log [oracle@POGBAK shpog]$ rm -rf redo03.log [oracle@POGBAK shpog]$ rm -rf redo04.log [oracle@POGBAK shpog]$ rm -rf redo05.log13，重新创建redo 1,2,3,4,5 组

SQL> alter database add logfile group 1 '/oracle/app/oradata/shpog/redo01.log' size 1024M; Database altered. SQL> alter database add logfile group 2 '/oracle/app/oradata/shpog/redo02.log' size 1024M; Database altered. SQL> alter database add logfile group 3 '/oracle/app/oradata/shpog/redo03.log' size 1024M; Database altered. SQL> alter database add logfile group 4 '/oracle/app/oradata/shpog/redo04.log' size 1024M; Database altered. SQL> alter database add logfile group 5 '/oracle/app/oradata/shpog/redo05.log' size 1024M; Database altered. ，切换到合适位置

SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 1024 ACTIVE 2 1 1024 CURRENT 3 1 1024 INACTIVE 4 1 1024 INACTIVE 5 1 1024 INACTIVE 6 1 1024 INACTIVE 7 1 1024 INACTIVE 8 1 1024 INACTIVE 8 rows selected. 删除redo 6，7,8 SQL> alter database drop logfile group 6; Database altered. SQL> alter database drop logfile group 7; Database altered. SQL> alter database drop logfile group 8; Database altered. SQL> SQL> SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 1024 ACTIVE 2 1 1024 CURRENT 3 1 1024 INACTIVE 4 1 1024 INACTIVE 5 1 1024 INACTIVE SQL> SQL> SQL> SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 1024 CURRENT 2 1 1024 ACTIVE 3 1 1024 ACTIVE 4 1 1024 ACTIVE 5 1 1024 ACTIVE 17，检查点 SQL> alter system checkpoint; System altered. SQL> SELECT group#, members, bytes/1024/1024 byte_mb, status FROM v$log; GROUP# MEMBERS BYTE_MB STATUS ---------- ---------- ---------- -------------------------------- 1 1 1024 CURRENT 2 1 1024 INACTIVE 3 1 1024 INACTIVE 4 1 1024 INACTIVE 5 1 1024 INACTIVE SQL> SQL> SQL> SQL> exit Disconnected from Oracle Database 11g Release 11.2.0.1.0 - 64bit Production [oracle@POGBAK shpog]$ [oracle@POGBAK shpog]$ [oracle@POGBAK shpog]$ [oracle@POGBAK shpog]$ [oracle@POGBAK shpog]$ ll total 62737636 -rw-r----- 1 oracle oinstall 10862592 May 5 12:07 control01.ctl -rw-r----- 1 oracle oinstall 104865792 May 5 12:06 example01.dbf -rw-r----- 1 oracle oinstall 1073742336 May 5 12:07 redo01.log -rw-r----- 1 oracle oinstall 1073742336 May 5 12:06 redo02.log -rw-r----- 1 oracle oinstall 1073742336 May 5 12:06 redo03.log -rw-r----- 1 oracle oinstall 1073742336 May 5 12:06 redo04.log -rw-r----- 1 oracle oinstall 1073742336 May 5 12:06 redo05.log -rw-r----- 1 oracle oinstall 1073742336 May 5 12:04 redo06.log -rw-r----- 1 oracle oinstall 1073742336 May 5 12:04 redo07.log -rw-r----- 1 oracle oinstall 1073742336 May 5 12:04 redo08.log -rw-r----- 1 oracle oinstall 5368717312 May 5 12:06 sysaux01.dbf -rw-r----- 1 oracle oinstall 4294975488 May 5 12:06 system01.dbf -rw-r----- 1 oracle oinstall 3326091264 May 4 22:00 temp01.dbf -rw-r----- 1 oracle oinstall 1745887232 May 5 12:06 undotbs01.dbf -rw-r----- 1 oracle oinstall 2147491840 May 5 12:06 undotbs02.dbf -rw-r----- 1 oracle oinstall 21474844672 May 5 12:06 users01.dbf -rw-r----- 1 oracle oinstall 17179877376 May 5 12:06 users02.dbf 18，在系统上删除redo 6,7,8文件 [oracle@POGBAK shpog]$ rm -rf redo06.log [oracle@POGBAK shpog]$ rm -rf redo07.log [oracle@POGBAK shpog]$ rm -rf redo08.log这样重做redo就做完了

转载请注明原文地址: https://www.6miu.com/read-57761.html

技术

最新回复(0)