Oracle

ORA-01139: RESETLOGS option only valid after an incomplete database recovery

Bryan2019.01.03 23:54조회 수 92댓글 0

    • 글자 크기
URL 1 http://appsdbafix.blogspot.com/2014/06/o...valid.html

Error :

 

sql statement: alter database open resetlogs

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of sql command on default channel at 05/13/2004 09:18:54

RMAN-11003: failure during parse/execution of SQL statement: alter database open

resetlogs

ORA-01139: RESETLOGS option only valid after an incomplete database recovery

 

RMAN> exit

 

 

 

SOLUTION

 

Two solutions for this problem

=======================

1.Restore the old controlfile from rman , mount the database with old controlfile

and run following script.

 

RMAN> run {

restore database;

recover database noredo;

alter database open resetlogs;

}

 

2.Do the incomplete recovery using sqlplus

 

SQL>connect / as sysdba

SQL>recover database until cancel using backup controlfile;

 

Type 'cancel' here.

 

Then open the database with resetlogs

 

SQL>alter database open resetlogs;

 

This command worked for my test DB.

RMAN> run {

restore database;

recover database noredo;

alter database open resetlogs;

}

    • 글자 크기
ORA-03113: end-of-file on communication channel Notepad++ Download

댓글 달기 Textarea 사용

파일 첨부

여기에 파일을 끌어 놓거나 파일 첨부 버튼을 클릭하세요.

파일 크기 제한 : 0MB (허용 확장자 : *.*)

0개 첨부 됨 ( / )
글쓴이 비밀번호
번호 카테고리 제목 최근 수정일
53 하버드 구조 2019.01.14
52 폰 노이만 구조 2019.01.14
51 포트 목록 2018.12.03
50 Etc 지뢰찾기 게임 2019.01.08
49 Java 자료구조 스터디 2019.01.07
48 Etc 세계지도 및 대한민국 주변도 서비스 2019.01.04
47 뮤텍스 2018.12.04
46 나눔글꼴 - 네이버 한글한글아름답게 2018.11.30
45 [MySQL] 무한정 늘어나는 log-bin 파일 줄이기 2018.12.02
44 YARN 무엇에 쓰는 물건인고? 2018.12.04
43 Yarn - default command 2018.12.04
42 Why MySQL could be slow with large tables ? 2018.12.04
41 WebJars - Web Libraries in Jars 2018.12.04
40 VMware Workstation Pro download 2018.12.11
39 VisualVM 2018.12.05
38 UTF-8 string length & byte counter 2018.12.03
37 UltraVNC VNC 2018.12.30
36 UltraEdit - Download 2018.12.05
35 The 2018 Web Developer Roadmap 2018.12.27
34 TechSmith Codecs 2018.12.03
33 Suwoni-Codelab 2018.12.02
32 Oracle STATS 2019.01.07
31 spring security - ip based url pattern access 2018.12.06
30 Etc Slack Workspaces 2018.11.22
29 Oracle Shell Commands From PL/SQL 2019.01.05
28 Windows Remove Empty Directories 2018.12.01
27 Power Supply Calculator 2018.12.09
26 Driver PIXMA G4900 Driver 2018.12.03
25 ORA-03113: end-of-file on communication channel 2018.12.30
Oracle ORA-01139: RESETLOGS option only valid after an incomplete database recovery 2019.01.07
23 Notepad++ Download 2018.11.27
22 Linux Linux / Unix Find All The Files Owned By a Particular User / Group 2018.12.03
21 ktlint 2018.12.12
20 kotlin-playground - github 2018.12.04
19 Kotlin Generics 정의 2018.12.13
18 kotlin - github 2018.12.04
17 JIET 2018.11.30
16 Etc icon - star 2018.11.23
15 HTTP 란 2018.12.04
14 Gradle Gradle 파일 구성하기 2018.11.22
13 Free scripts and components for websites 2018.11.23
12 MySQL Exporting MySQL database to a dump file 2019.01.08
11 Elm elm fmt 2019.01.02
10 Elm Elm 2019.01.02
9 Windows disk bad sector check & repair 2018.12.01
8 DBMS_JAVA.grant_permission 2019.01.05
7 Cmder | Console Emulator 2018.12.13
6 chocolatey install 2018.11.23
5 change local_listener 2019.01.05
4 Best Error Page Templates 2018 2018.11.22
3 Oracle ACL 2019.01.07
2 2019년 경제전망 2018.12.30
1 Oracle 18c EM 포트 변경 쿼리 2019.01.07
첨부 (0)