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

SQL > SELECT * FROM v$logfile

GROUP# STATUS TYPEMEMBER

IS_ CON_ID

3 ONLINE

+ DATA/JY/ONLINELOG/group_3.264.968770057

NO 0

2 ONLINE

+ DATA/JY/ONLINELOG/group_2.263.968770045

NO 0

GROUP# STATUS TYPEMEMBER

IS_ CON_ID

1 ONLINE

+ DATA/JY/ONLINELOG/group_1.262.968770045

NO 0

SQL > select group#,status from v$log

GROUP# STATUS 1 INACTIVE 2 INACTIVE 3 CURRENT

SQL > alter database add logfile member'+ REDO','+ARCH' to group 1

Database altered.

SQL > alter database add logfile member'+ REDO','+ARCH' to group 2

Database altered.

SQL > alter database add logfile member'+ REDO','+ARCH' to group 3

Database altered.

SQL > select group#,status from v$log

GROUP# STATUS 1 INACTIVE 2 INACTIVE 3 CURRENT

SQL > alter system switch logfile

System altered.

SQL > alter database drop logfile member'+ DATA/JY/ONLINELOG/group_1.262.968770045'

Database altered.

SQL > alter system switch logfile

System altered.

SQL > alter database drop logfile member'+ DATA/JY/ONLINELOG/group_2.263.968770045'

Database altered.

SQL > alter system switch logfile

System altered.

SQL > alter database drop logfile member'+ DATA/JY/ONLINELOG/group_3.264.968770057'

Database altered.

SQL > select a. Groupmakers a. BytesBytesBytesUniverse 1024 mb,b.member from v$log a minute vandal logfile b where a.group#=b.group#

GROUP# MBMEMBER 1 200

+ REDO/JY/ONLINELOG/group_1.256.968854893

1 200

+ ARCH/JY/ONLINELOG/group_1.256.968854895

2 200

+ REDO/JY/ONLINELOG/group_2.257.968854901

GROUP# MBMEMBER 2 200

+ ARCH/JY/ONLINELOG/group_2.257.968854903

3 200

+ REDO/JY/ONLINELOG/group_3.258.968854907

3 200

+ ARCH/JY/ONLINELOG/group_3.258.968854909

6 rows selected.

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.