10GDATAGUARD增加REDO日志组、删除日志组、删除日志成员实验 - 数据库编程

/app/oracle/prod/disk2/log3b.log';
Database altered.

SQL> alter database recover managed standby database disconnect from session; --通过开启恢复应用来切换当前日志组，不要手动切换。
Database altered.

SQL> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 CLEARING_CURRENT
3 CLEARING
2 CLEARING

SQL> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 CLEARING
3 CLEARING_CURRENT
2 CLEARING

SQL> alter database drop logfile member '/u01/app/oracle/prod/disk2/log1b.log';
alter database drop logfile member '/u01/app/oracle/prod/disk2/log1b.log'
*
ERROR at line 1:
ORA-01156: recovery in progress may need access to files ---取消恢复应用

SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database drop logfile member '/u01/app/oracle/prod/disk2/log1b.log';
Database altered.
SQL> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 CLEARING
3 CLEARING_CURRENT
2 CLEARING
SQL>
SQL> select group#,member,status from v$logfile;
GROUP# MEMBER STATUS
---------- -------------------------------------------------- -------
1 /u01/app/oracle/prod/disk1/redo01.log
2 /u01/app/oracle/prod/disk1/redo02.log
3 /u01/app/oracle/prod/disk1/redo03.log
4 /u01/app/oracle/prod/disk1/standbylog1.log
5 /u01/app/oracle/prod/disk1/standbylog2.log
6 /u01/app/oracle/prod/disk1/standbylog3.log
7 /u01/app/oracle/prod/disk1/standbylog4.log
7 rows selected.
########
删除完成可以在主库上切换下日志看是否应用到备库，一般来说删除一个REDO日志MEMBER是没影响的。

10GDATAGUARD增加REDO日志组、删除日志组、删除日志成员实验(三)