---查看当前日志组状态
---操作系统层删除第一组日志组
---发现丢失后，没等数据库反应过来，立即恢复
---完成恢复
-
SQL> select group#,members,status from v$log;
-
-
GROUP# MEMBERS STATUS
-
---------- ---------- ----------------
-
1 1 INACTIVE
-
2 1 CURRENT
-
3 1 INACTIVE
-
-
SQL> select group#,member from v$logfile order by 1;
-
-
GROUP#
-
----------
-
MEMBER
-
--------------------------------------------------------------------------------
-
1
-
/u01/app/oracle/oradata/HU/redo01.log
-
-
2
-
/u01/app/oracle/oradata/HU/redo02.log
-
-
3
-
/u01/app/oracle/oradata/HU/redo03.log
-
-
- SQL>
---操作系统层删除第一组日志组
-
SQL> !ls /u01/app/oracle/oradata/HU/*.log
-
/u01/app/oracle/oradata/HU/redo01.log /u01/app/oracle/oradata/HU/redo03.log
-
/u01/app/oracle/oradata/HU/redo02.log
-
-
SQL> !rm /u01/app/oracle/oradata/HU/redo01.log
-
-
SQL> !ls /u01/app/oracle/oradata/HU/*.log
-
/u01/app/oracle/oradata/HU/redo02.log /u01/app/oracle/oradata/HU/redo03.log
-
- SQL>
---发现丢失后，没等数据库反应过来，立即恢复
-
SQL> alter database drop logfile group 1;
-
-
Database altered.
-
-
SQL> select group#,members,status,bytes/1024/1024 as m from v$log;
-
-
GROUP# MEMBERS STATUS M
-
---------- ---------- ---------------- ----------
-
2 1 CURRENT 50
-
3 1 INACTIVE 50
-
-
SQL> alter database add logfile group 1 ('/u01/app/oracle/oradata/HU/redo01.log') size 50m;
-
-
Database altered.
-
-
SQL> select group#,members,status,bytes/1024/1024 as m from v$log;
-
-
GROUP# MEMBERS STATUS M
-
---------- ---------- ---------------- ----------
-
1 1 UNUSED 50
-
2 1 CURRENT 50
- 3 1 INACTIVE 50
---完成恢复
-
SQL> alter system switch logfile;
-
-
System altered.
-
-
SQL> select group#,members,status from v$log;
-
-
GROUP# MEMBERS STATUS
-
---------- ---------- ----------------
-
1 1 CURRENT
-
2 1 ACTIVE
-
3 1 INACTIVE
-
- SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31399171/viewspace-2138618/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
自动tempfile恢复
请登录后发表评论
登录
全部评论
