Oracle

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

Bryan2019.01.03 23:54조회 수 1663댓글 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;

}

    • 글자 크기
ACL Shell Commands From PL/SQL

댓글 달기 Textarea 사용

파일 첨부

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

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

0개 첨부 됨 ( / )
글쓴이 비밀번호
번호 카테고리 제목 최근 수정일
5 Oracle 18c EM 포트 변경 쿼리 2019.01.07
4 Oracle ACL 2019.01.07
Oracle ORA-01139: RESETLOGS option only valid after an incomplete database recovery 2019.01.07
2 Oracle Shell Commands From PL/SQL 2019.01.05
1 Oracle STATS 2019.01.07
첨부 (0)