RMAN恢複測試-丟失聯機重做日誌文件(LINUX-11.2.0.1.0)

火星人 @ 2014-03-09 , reply:0


此處刪除非當前聯機重做日誌文件

[oracle@localhost ~]$ sqlplus sys as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 8 09:39:36 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup ORACLE instance started.
Total System Global Area 1653518336 bytes Fixed Size 2213896 bytes Variable Size 973080568 bytes Database Buffers 671088640 bytes Redo Buffers 7135232 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 4889 Session ID: 1 Serial number: 5

SQL> alter database clear logfile group 2; ERROR: ORA-03114: not connected to ORACLE



SQL> conn Enter user-name: sys as sysdba Enter password: Connected to an idle instance. SQL> alter database clear logfile group 2; alter database clear logfile group 2 * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile; alter system set "_allow_resetlogs_corruption"=true scope=spfile * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 警報文件節選 Errors in file /oracle/oracle/diag/rdbms/test/test/trace/test_m000_4452.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/oracle/oracledata/test/redo02.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory

Additional information: 3 Instance terminated by USER, pid = 4442

本文出自 「Xin23的歷程」 博客,謝絕轉載!




[火星人 via ] RMAN恢複測試-丟失聯機重做日誌文件(LINUX-11.2.0.1.0)已經有115次圍觀

http://www.coctec.com/docs/linux/show-post-48112.html