ORA-01152

• 코드
• ORA-01152
• 원인
• ADG 구성시 DB 종료상태에서 수동으로 Controlfile을 옮겨서 standby db를 open 할때 발생
• 해결
• SQL> select checkpoint_change#, controlfile_change# from v$database;

• 
  
  CHECKPOINT_CHANGE# CONTROLFILE_CHANGE#
  ------------------ -------------------
     1659928           1672939
  
  
  쿼리의 결과처럼 번호가 다를 때 발생하나  실제로는 이 에러가 아님
  
  
  SQL> select checkpoint_change#, controlfile_change# from v$database;
  
  
  CHECKPOINT_CHANGE# CONTROLFILE_CHANGE#
  ------------------ -------------------
  1. 0
  
  
  이것처럼 번호를 0으로 초기화 시켜도 발생되는 에러로 control file의 문제가 아님, 해결이 불가능하며 초기화해야됨
• 참고 MOS 문서번호 & 기타
• /
  / *Cause:  An incomplete recovery session was started, but an insufficient
  //       number of logs were applied to make the database consistent. This
  //         file is still in the future of the last log applied. The most
  //         likely cause of this error is forgetting to restore the file
  //         from a backup before doing incomplete recovery.
  // *Action: Either apply more logs until the database is consistent or
  //       restore the database file from an older backup and repeat recovery.