数据库不能open
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
SYS@orcl AS SYSDBA> startup mount; ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2257520 bytes Variable Size 889195920 bytes Database Buffers 2298478592 bytes Redo Buffers 16904192 bytes Database mounted. SYS@orcl AS SYSDBA> alter database open ; alter database open * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 8671 Session ID: 351 Serial number: 3 |
恢复过程：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
SYS@orcl AS SYSDBA> set line 999 SYS@orcl AS SYSDBA> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------ ------------ ------------ 1 1 238 134217728 512 1 NO INACTIVE 8194615 30-MAY-19 8262706 31-MAY-19 3 1 240 134217728 512 1 NO CURRENT 8341259 01-JUN-19 2.8147E+14 2 1 239 134217728 512 1 NO INACTIVE 8262706 31-MAY-19 8341259 01-JUN-19 SYS@orcl AS SYSDBA> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01139: RESETLOGS option only valid after an incomplete database recovery SYS@orcl AS SYSDBA> recover database until time '2019-05-31'; Media recovery complete. SYS@orcl AS SYSDBA> alter database open resetlogs; |
RMAN备份
|
1 2 |
SYS@orcl AS SYSDBA> alter database enable block change tracking; |