Shulou(Shulou.com)06/01 Report--

The solution is to add standby redo to the primary library to delete the old standby redo, then add standby redo to the main library to delete the old standby redo, add new redo to the main library to delete the old redo, and finally add redo to the standby library to delete the old redo.

View the redo log information of the main library:

SELECT a.groupmakers, a.threadsheets, a.bytes / 1024 / 1024 "size_mb", a.members, a.status, b.MEMBER FROM v$log a, v$logfile b where a.groupmakers = b.group# and b.TYPERPERTONLINE 'ORDER BY a.GROUP# GROUP# THREAD# size_mb MEMBERS STATUS MEMBER -1 1 50 2 CURRENT + DATA/mecbs/onlinelog/group_1.261.862339607 1 1 50 2 CURRENT + RECO/mecbs/onlinelog/group_1.redo01.log 21 50 2 INACTIVE + DATA/mecbs/onlinelog/group_2.262.862339621 21 50 2 INACTIVE + RECO/mecbs/onlinelog/group_2. Redo01.log 3 2 50 2 INACTIVE + RECO/mecbs/onlinelog/group_3.redo01.log 3 2 50 2 INACTIVE + DATA/mecbs/onlinelog/group_3.266.862341957 4 2 50 2 CURRENT + RECO/mecbs/onlinelog/group_4.redo01.log 4 2 50 2 CURRENT + DATA/mecbs/onlinelog/group_4.267.862341967

View the Standbylog information of the main library:

SQL > set pagesize 100 SELECT a. Groupstores, a. Thread, a.bytes / 1024 / 1024 "size_mb", a.status, b.member FROM v$standby_log a, v$logfile b WHERE a.group# = b.group# AND b.type = 'STANDBY' ORDER BY a.group# GROUP# THREAD# size_mb STATUS MEMBER -- 5 150 UNASSIGNED + DATA/mecbs/onlinelog/group_5.269.862401827 5 150 UNASSIGNED + RECO/mecbs/onlinelog/group_5.261.862401835 61 50 UNASSIGNED + DATA/mecbs/onlinelog/group_6.270.862401861 61 50 UNASSIGNED + RECO/mecbs/onlinelog/group_6.262.862401871 71 50 UNASSIGNED + DATA/mecbs/onlinelog/group_7.271.862401977 71 50 UNASSIGNED + RECO/mecbs/onlinelog/group_7.263.862401983 8 250 UNASSIGNED + DATA/mecbs/onlinelog/group_8.272.862402121 8 2 50 UNASSIGNED + RECO/mecbs/onlinelog/group_8.264.862402137 9 250 UNASSIGNED + DATA/mecbs/onlinelog/group_9.273.862402187 9 250 UNASSIGNED + RECO/mecbs/onlinelog/group_9.265.862402189 10 250 UNASSIGNED + DATA/mecbs/onlinelog/group_ 10.274.862402213 10 2 50 UNASSIGNED + RECO/mecbs/onlinelog/group_10.266.862402217SELECT a.group# Thread, a.bytes / 1024 / 1024 "size_mb", a.status, b.member FROM v$standby_log a, v$logfile b WHERE a.group# = b.group# 7 8 AND b.type = 'STANDBY' 9 ORDER BY a.group# GROUP# THREAD# size_mb STATUS MEMBER 5 1 50 UNASSIGNED + DATA/phub/onlinelog/group_5.260.884293665 5 150 UNASSIGNED + RECO/phub/onlinelog/group_5.619.884293671 61 50 UNASSIGNED + DATA/phub/onlinelog/group_6.272.884293677 61 50 UNASSIGNED + RECO/phub/onlinelog/group_6.618.884293683 71 50 ACTIVE + DATA/phub/onlinelog/group_7.273.884293689 71 50 ACTIVE + RECO/phub/onlinelog/group_7.616.884293695 8 250 ACTIVE + DATA/phub/onlinelog/group_8.264.884293703 8 2 50 ACTIVE + RECO/phub/onlinelog/group_8.617.884293707 9 250 UNASSIGNED + DATA/phub/onlinelog/group_9.286.884293715 9 250 UNASSIGNED + RECO/phub/onlinelog/group_9.615.884293727 10 250 UNASSIGNED + DATA/ Phub/onlinelog/group_10.256.884293735 10 2 50 UNASSIGNED + RECO/phub/onlinelog/group_10.614.884293739SELECT a.group# Thread, a.bytes / 1024 / 1024 "size_mb", a.members, a.status, b.member FROM v$log a, v$logfile b WHERE a.group# = b.group# AND b.type = 'ONLINE' 10 ORDER BY a.group# GROUP# THREAD# size_mb MEMBERS STATUS MEMBER -11 50 2 CURRENT + DATA/phub/onlinelog/group_1.282.884293611 11 50 2 CURRENT + RECO/phub/onlinelog/group_1.624.884293619 2 1 50 2 CLEARING + DATA/phub/onlinelog/group_2.281.884293627 2 1 50 2 CLEARING + RECO/phub/onlinelog/group_2 .622.884293629 3 2 50 2 CLEARING + RECO/phub/onlinelog/group_3.620.884293641 3 2 50 2 CLEARING + DATA/phub/onlinelog/group_3.280.884293635 42 50 2 CURRENT + RECO/phub/onlinelog/group_4.621.884293661 42 50 2 CURRENT + DATA/phub/onlinelog/group_4.266.884293655

Cancel the application of preparing the database log:

SQL > alter database recover managed standby database cancel;Database altered.

4. Add standby log to the slave library:

Alter database add standby logfile thread 1 ('+ BACK','+RECO') size 100m alter database add standby logfile thread 1 ('+ BACK','+RECO') size 100m alter database add standby logfile thread 1 ('+ BACK','+RECO') size 100m alter database add standby logfile thread 2 ('+ BACK','+RECO') size 100m alter database add standby logfile thread 2 ('+ BACK','+RECO') size 100m alter database add standby logfile thread 2 ('+ BACK','+RECO') size 100m

(added to the DATA diskgroup because there is not enough space in the lab environment)

SELECT a. Groupstores, a. Thread, a.bytes / 1024 / 1024 "size_mb", a.status, b.member FROM v$standby_log a, v$logfile b WHERE a.group# = b.group# AND b.type = 'STANDBY' 9 ORDER BY a.group# GROUP# THREAD# size_mb STATUS MEMBER 5 1 50 UNASSIGNED + DATA/phub/onlinelog/group_5.260.884293665 5 150 UNASSIGNED + RECO/phub/onlinelog/group_5.619.884293671 61 50 UNASSIGNED + DATA/phub/onlinelog/group_6.272.884293677 61 50 UNASSIGNED + RECO/phub/onlinelog/group_6.618.884293683 71 50 ACTIVE + DATA/phub/onlinelog/group_7.273.884293689 71 50 ACTIVE + RECO/phub/onlinelog/group_7.616.884293695 8 250 ACTIVE + DATA/phub/onlinelog/group_8.264.884293703 8 2 50 ACTIVE + RECO/phub/onlinelog/group_8.617.884293707 9 250 UNASSIGNED + DATA/phub/onlinelog/group_9.286.884293715 9 250 UNASSIGNED + RECO/phub/onlinelog/group_9.615.884293727 10 250 UNASSIGNED + DATA/ Phub/onlinelog/group_10.256.884293735 10 2 50 UNASSIGNED + RECO/phub/onlinelog/group_10.614.884293739 11 1 100 UNASSIGNED + BACK/phub/onlinelog/group_11.306.886088609 11 1 100 UNASSIGNED + RECO/phub/onlinelog/group_11.548.886088623 12 1 100 UNASSIGNED + BACK/phub/onlinelog/group_12.307.886088647 12 1 100 UNASSIGNED + RECO/phub/onlinelog/group_12.550.886088653 13 1 100 UNASSIGNED + BACK/phub/onlinelog/group_13.289.886088921 13 1 100 UNASSIGNED + RECO/phub/onlinelog/group_13.551.886088931 14 2 100 UNASSIGNED + BACK/phub/onlinelog/group_14.288.886088951 14 2 100 UNASSIGNED + RECO/phub/onlinelog/group_14.553.886088963 15 2 100 UNASSIGNED + BACK/phub/onlinelog/group_15.305.886088979 15 2 100 UNASSIGNED + RECO/phub/onlinelog/group_15. 552.886088993 16 2 100 UNASSIGNED + BACK/phub/onlinelog/group_16.304.886089015 16 2 100 UNASSIGNED + RECO/phub/onlinelog/group_16.638.886089027

5. Delete standby standby log

SQL > alter database drop logfile group 5: database altered.SQL > alter database drop logfile group 6: database altered.SQL > alter database drop logfile group 7 alter database drop logfile group 7*ERROR at line 1:ORA-00261: log 7 of thread 1 is being archived or modifiedORA-00312: onlinelog 7 thread 1:'+ DATA/phub/onlinelog/group_7.273.884293689'ORA-00312: onlinelog 7 thread 1:'+ RECO/phub/onlinelog/group_7.616.884293695'SQL > alter database drop logfile group 7 Singapore database altered.SQL > alter database drop logfile group 8 Database altered.SQL > alter database drop logfile group 9: database altered.SQL > alter database drop logfile group 10: database altered.

While switching logs on the main database, query those groups UNASSIGNED on the slave database, and then drop them one by one:

When you are finished, query the slave standby_log again:

SELECT a. Groupstores, a. Thread, a.bytes / 1024 / 1024 "size_mb", a.status, b.member FROM v$standby_log a, v$logfile b WHERE a.group# = b.group# AND b.type = 'STANDBY' ORDER BY a.group# GROUP# THREAD# size_mb STATUS MEMBER 11 1 100 UNASSIGNED + BACK/phub/onlinelog/group_11.306.886088609 11 1 100 UNASSIGNED + RECO/phub/onlinelog/group_11.548.886088623 12 1 100 ACTIVE + BACK/phub/onlinelog/group_12.307.886088647 12 1 100 ACTIVE + RECO/phub/onlinelog/group_12.550.886088653 13 1 100 UNASSIGNED + BACK/phub/onlinelog/group_13.289.886088921 13 1 100 UNASSIGNED + RECO/phub / onlinelog/group_13.551.886088931 14 2 100 ACTIVE + BACK/phub/onlinelog/group_14.288.886088951 14 2 100 ACTIVE + RECO/phub/onlinelog/group_14.553.886088963 15 2 100 UNASSIGNED + BACK/phub/onlinelog/group_15.305.886088979 15 2 100 UNASSIGNED + RECO/phub/onlinelog/group_15.552.886088993 16 2 100 UNASSIGNED + BACK/phub/onlinelog/group_16.304.886089015 16 2 100 UNASSIGNED + RECO/phub/onlinelog/group_16.638.886089027

6. The main library standbylog adds:

Alter database add standby logfile thread 1 ('+ DATA','+RECO') size 100m alter database add standby logfile thread 1 ('+ DATA','+RECO') size 100m alter database add standby logfile thread 1 ('+ DATA','+RECO') size 100m alter database add standby logfile thread 2 ('+ DATA','+RECO') size 100m alter database add standby logfile thread 2 ('+ DATA','+RECO') size 100m alter database add standby logfile thread 2 ('+ DATA','+RECO') size 100m SELECT a. Groupstores, a. Thread, a.bytes / 1024 / 1024 "size_mb", a.status, b.member FROM v$standby_log a, v$logfile b WHERE a.group# = b.group# AND b.type = 'STANDBY' 9 ORDER BY a.group# GROUP# THREAD# size_mb STATUS MEMBER 5 1 50 UNASSIGNED + DATA/mecbs/onlinelog/group_5.269.862401827 5 150 UNASSIGNED + RECO/mecbs/onlinelog/group_5.261.862401835 61 50 UNASSIGNED + DATA/mecbs/onlinelog/group_6.270.862401861 61 50 UNASSIGNED + RECO/mecbs/onlinelog/group_6.262.862401871 71 50 UNASSIGNED + DATA/mecbs/onlinelog/group_7.271.862401977 71 50 UNASSIGNED + RECO/mecbs/onlinelog/group_7.263.862401983 8 250 UNASSIGNED + DATA/mecbs/onlinelog/group_8.272.862402121 8 250 UNASSIGNED + RECO/mecbs/onlinelog/group_8.264.862402137 9 250 UNASSIGNED + DATA/mecbs/onlinelog/group_9.273.862402187 9 250 UNASSIGNED + RECO/mecbs/onlinelog/group_9.265.862402189 10 250 UNASSIGNED + DATA/mecbs/onlinelog/group_10. 274.862402213 10 2 50 UNASSIGNED + RECO/mecbs/onlinelog/group_10.266.862402217 11 1 100 UNASSIGNED + DATA/mecbs/onlinelog/group_11.277.886086953 11 1 100 UNASSIGNED + RECO/mecbs/onlinelog/group_11.927.886086965 12 1 100 UNASSIGNED + DATA/mecbs/onlinelog/group_12.282.886086997 12 1 100 UNASSIGNED + RECO/mecbs/onlinelog/group_12.928.886087017 13 1 100 UNASSIGNED + DATA/mecbs / onlinelog/group_13.283.886087033 13 1 100 UNASSIGNED + RECO/mecbs/onlinelog/group_13.929.886087047 14 2 100 UNASSIGNED + DATA/mecbs/onlinelog/group_14.284.886087059 14 2 100 UNASSIGNED + RECO/mecbs/onlinelog/group_14.930.886087067 15 2 100 UNASSIGNED + DATA/mecbs/onlinelog/group_15.285.886087089 15 2 100 UNASSIGNED + RECO/mecbs/onlinelog/group_15.931.886087099 16 2 100 UNASSIGNED + DATA/mecbs/onlinelog/group_16.286.886087115 16 2 100 UNASSIGNED + RECO/mecbs/onlinelog/group_16.932.886087125alter database drop logfile group 5 Alter database drop logfile group 6 alter database drop logfile group 7 alter database drop logfile group 8 alter database drop logfile group 9 alter database drop logfile group 10 alter select a.groupkeeper, a thread, a.bytes / 1024 / 1024 "size_mb", a.status, b.member FROM v$standby_log a, v$logfile b WHERE a.group# = b.group# AND b.type = 'STANDBY' 9 ORDER BY a.group# GROUP# THREAD# size_mb STATUS MEMBER 11 1 100 UNASSIGNED + DATA/mecbs/onlinelog/group_11.277.886086953 11 1 100 UNASSIGNED + RECO/mecbs/onlinelog/group_11.927.886086965 12 1 100 UNASSIGNED + DATA/mecbs/onlinelog/group_12.282.886086997 12 1 100 UNASSIGNED + RECO/mecbs/onlinelog/group_12.928.886087017 13 1 100 UNASSIGNED + DATA/mecbs/onlinelog/group_13.283.886087033 13 1 100 UNASSIGNED + RECO/mecbs/onlinelog/group _ 13.929.886087047 14 2 100 UNASSIGNED + DATA/mecbs/onlinelog/group_14.284.886087059 14 2 100 UNASSIGNED + RECO/mecbs/onlinelog/group_14.930.886087067 15 2 100 UNASSIGNED + DATA/mecbs/onlinelog/group_15.285.886087089 15 2 100 UNASSIGNED + RECO/mecbs/onlinelog/group_15.931.886087099 16 2 100 UNASSIGNED + DATA/mecbs/onlinelog/group_16.286.886087115 16 2 100 UNASSIGNED + RECO/mecbs/onlinelog/group_16.932.886087125

7. Add a new ONLINE REDO LOG to the main library:

SQL > alter database add logfile thread 1 ('+ DATA','+RECO') size 100M database altered.SQL > alter database add logfile thread 1 ('+ DATA','+RECO') size 100M database altered.SQL > alter database add logfile thread 1 ('+ DATA','+RECO') size 100M database altered.SQL > alter database add logfile thread 2 ('+ DATA','+RECO') size 100M database altered.SQL > alter database add logfile thread 2 ('+ DATA','+RECO') size 100M database altered.SQL > alter database add logfile thread 2 ('+ DATA','+RECO') size 100M database altered.

Query add result:

SELECT a. Groupstores, a. Thread, a.bytes / 1024 / 1024 "size_mb", a.members, a.status, b.member FROM v$log a, v$logfile b WHERE a.group# = b.group# AND b.type = 'ONLINE' 5 6 7 8 9 10 ORDER BY a.group# GROUP# THREAD# size_mb MEMBERS STATUS MEMBER -1 1 50 2 CURRENT + RECO/mecbs/onlinelog/group_1.redo01.log 1 1 50 2 CURRENT + DATA/mecbs/onlinelog/group_1.261.862339607 21 50 2 INACTIVE + DATA/mecbs/onlinelog/group_2.262.862339621 21 50 2 INACTIVE + RECO/mecbs/onlinelog/group_2 .redo01.log 3 2 50 2 CURRENT + DATA/mecbs/onlinelog/group_3.266.862341957 3 2 50 2 CURRENT + RECO/mecbs/onlinelog/group_3.redo01.log 4 2 50 2 INACTIVE + RECO/mecbs/onlinelog/group_4.redo01.log 4 2 50 2 INACTIVE + DATA/mecbs/onlinelog/group_4.267.862341967 5 1 100 2 UNUSED + DATA/mecbs/onlinelog/group_5.274.886087389 5 1 100 2 UNUSED + RECO/mecbs/onlinelog/group_5.266.886087403 6 1 100 2 UNUSED + RECO/mecbs/onlinelog/group_6.265.886087423 6 1 100 2 UNUSED + DATA/mecbs/onlinelog/group_6.273.886087413 7 1 100 2 UNUSED + DATA/mecbs/onlinelog/group_7.272.886087433 7 1 100 2 UNUSED + RECO/mecbs/onlinelog/group_7.264.886087441 8 2 100 2 UNUSED + RECO/mecbs/onlinelog/group_8.263.886087483 8 2 100 2 UNUSED + DATA/mecbs/onlinelog/group_8.271.886087455 9 2 100 2 UNUSED + RECO/mecbs/onlinelog/group_9.262.886087513 9 2 100 2 UNUSED + DATA/mecbs/onlinelog/group_9.270.886087497 10 2 100 2 UNUSED + DATA/mecbs/onlinelog/group_10.269.886087541 10 2 100 2 UNUSED + RECO/mecbs/onlinelog/group_10.261.886087553

8. The main library deletes the old ONLINE REDOLOG; (

Alter database drop logfile group 1 alter database drop logfile group 2 alter database drop logfile group 3 alter database drop logfile group 4;) SELECT a.groupkeeper, a.threadbasket, a.bytes / 1024 / 1024 "size_mb", a.members, a.status, b.member FROM v$log a, v$logfile b WHERE a.group# = b.group# AND b.type = 'ONLINE' 10 ORDER BY a.group# GROUP# THREAD# size_mb MEMBERS STATUS MEMBER -5 1 100 2 CURRENT + DATA/mecbs/onlinelog/group_5.274.886087389 5 1 100 2 CURRENT + RECO/mecbs/onlinelog/group_5.266.886087403 6 1 100 2 INACTIVE + DATA/mecbs/onlinelog/group_6.273.886087413 6 1 100 2 INACTIVE + RECO/mecbs/onlinelog/group_6.265.886087423 71 100 2 INACTIVE + DATA/mecbs/onlinelog/group_7.272.886087433 71 100 2 INACTIVE + RECO/mecbs/onlinelog/group_7.264.886087441 8 2 100 2 INACTIVE + DATA/mecbs/onlinelog/group_8.271.886087455 8 2 100 2 INACTIVE + RECO/mecbs/onlinelog/group_8.263.886087483 9 2 100 2 CURRENT + DATA/mecbs/onlinelog/group_ 9.270.886087497 9 2100 2 CURRENT + RECO/mecbs/onlinelog/group_9.262.886087513 10 2 100 2 INACTIVE + DATA/mecbs/onlinelog/group_10.269.886087541 10 2 100 2 INACTIVE + RECO/mecbs/onlinelog/group_10.261.88608755312 rows selected.

9. Add new ONLINE REDO LOG to standby library

SELECT a. Groupstores, a. Thread, a.bytes / 1024 / 1024 "size_mb", a.members, a.status, b.member FROM v$log a, v$logfile b WHERE a.group# = b.group# AND b.type = 'ONLINE' 10 ORDER BY a.group# GROUP# THREAD# size_mb MEMBERS STATUS MEMBER -11 50 2 CLEARING + DATA/phub/onlinelog/group_1.282.884293611 11 50 2 CLEARING + RECO/phub/onlinelog/group_1.624.884293619 2 1 50 2 CLEARING + DATA/phub/onlinelog/group_2.281.884293627 2 1 50 2 CLEARING + RECO/phub/onlinelog/group_2 .622.884293629 3 2 50 2 CLEARING + RECO/phub/onlinelog/group_3.620.884293641 3 2 50 2 CLEARING + DATA/phub/onlinelog/group_3.280.884293635 42 50 2 CLEARING + RECO/phub/onlinelog/group_4.621.884293661 42 50 2 CLEARING + DATA/phub/onlinelog/group_4.266.8842936558 rows selected.ORA-01275: Operation ADD LOGFILE is not Allowed if standby file management is automatic.SQL > alter system set standby_file_management='MANUAL' System altered.SQL > alter database add logfile thread 1 ('+ BACK','+RECO') size 100M database alteredSQL > alter database add logfile thread 1 ('+ BACK','+RECO') size 100M database altered.SQL > alter database add logfile thread 1 ('+ BACK','+RECO') size 100M database altered.SQL > alter database add logfile thread 2 ('+ BACK','+RECO') size 100M database altered.SQL > alter database add logfile thread 2 ('+ BACK','+RECO') size 100M database altered.SQL > alter database add logfile thread 2 ('+ BACK','+RECO') size 100M database altered.

10. Delete the old ONLINE REDO LOG from the repository:

If the log status is always CLEARING, do the following:

SQL > alter database clear logfile group 1x database altered.SQL > alter database clear logfile group 2th database altered.SQL > alter database drop logfile group 1b database altered.SQL > alter database drop logfile group 2th database altered.SELECT a.groupdatabases, a.threadsheets, a.bytes / 1024 / 1024 "size_mb", a.members, a.status, b.member FROM v$log a, v$logfile b WHERE a.group# = b.group# AND b.type = 'ONLINE' 10 ORDER BY a.group# GROUP# THREAD# size_mb MEMBERS STATUS MEMBER -5 1 100 2 CURRENT + BACK/phub/onlinelog/group_5.303.886091387 5 1 100 2 CURRENT + RECO/phub/onlinelog/group_5.599.886091395 6 1 100 2 CLEARING + BACK/phub/onlinelog/group_6.302.886091401 6 1 100 2 CLEARING + RECO/phub/onlinelog/group_6.604.886091411 7 1 100 2 CLEARING + BACK/phub/onlinelog/group_7.301.886091425 7 1 100 2 CLEARING + RECO/phub/onlinelog/group_7.603.886091435 8 2 100 2 CURRENT + BACK/phub/onlinelog/group_8.300.886091441 8 2 100 2 CURRENT + RECO/phub/onlinelog/group_8.609.886091449 9 2 100 2 CLEARING + BACK/phub/onlinelog/group_ 9.299.886091457 9 2 100 2 CLEARING + RECO/phub/onlinelog/group_9.611.886091467 10 2 100 2 CLEARING + BACK/phub/onlinelog/group_10.298.886091479 10 2 100 2 CLEARING + RECO/phub/onlinelog/group_10.612.88609150112 rows selected.SQL > alter system set standby_file_management='AUTO' scope=both System altered.SQL > alter database recover managed standby database using current logfile disconnect from session;Database altered.

-- View redo log switching frequency

Select round (FIRST_TIME, 'DD'), THREAD#, Count (SEQUENCE#) From v$log_history Group By round (FIRST_TIME,' DD'), THREAD# Order By 1, 2SELECT trunc (first_time) "Date", to_char (first_time, 'Dy') "Day", count (1) "Total", SUM (decode (to_char (first_time,' hh34') "h0" SUM (decode (to_char (first_time, 'hh34'),' 01)) "H2", SUM (decode (to_char (first_time, 'hh34'),' 02)) "h3", SUM (decode (to_char (first_time, 'hh34'),' 03)) "h4", SUM (to_char (first_time, 'hh34'),' 04' ) "h5", SUM (decode (to_char (first_time, 'hh34'),' 05jin1)) "H6", SUM (decode (to_char (first_time, 'hh34'),' 06)) "H7", SUM (decode (to_char (first_time, 'hh34'),' 07 (first_time, 'hh34') "H7", SUM (to_char (first_time,' hh34') ) "H8", SUM (decode (to_char (first_time, 'hh34'),' 09)) "H9", SUM (decode (to_char (first_time, 'hh34'),' 10)) "H20", SUM (decode (to_char (first_time, 'hh34'),' 11) (to_char (first_time) "H21", SUM (to_char (first_time) ) "H22", "SUM" (decode (to_char (first_time, 'hh34'),' 1300 hh34')) "H23", SUM (decode (to_char (first_time, 'hh34'),' 14)) "h24", SUM (decode (to_char (first_time, 'hh34'),' 15pence1) "H25") SUM (decode (to_char (first_time, 'hh34') "h26", SUM (decode (to_char (first_time,' hh34'), '170010)) "h27", SUM (decode (to_char (first_time,' hh34'), '1813)) "h28", SUM (to_char (first_time,' hh34'), '19' )) "H29", SUM (decode (to_char (first_time, 'hh34'),' 20 million (hh34') "H30", SUM (decode (to_char (first_time, 'hh34'),' 21)) "H31", SUM (to_char (first_time, 'hh34'),' 22)) "H32", SUM (to_char (first_time, 'hh34') FROM V$log_historygroup by trunc (first_time), to_char (first_time, 'Dy') Order by 1

= = THE END==

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.