[B&R] [HotBackup] 복구

1. mount까지 기동

SQL> alter database mount;
Database altered.

 

2. recover 시도

SQL> recover database using backup controlfile;
ORA-00279: change 2457956 generated at 07/15/2024 14:00:20 needed for thread 1
ORA-00289: suggestion : /backup/orcl11/hot/arch/1_1_1174399217.dbf
ORA-00280: change 2457956 for thread 1 is in sequence #1  **************************** 해당 시퀀스 로그파일 확인

 

3. 로그 파일 확인

SQL> select group#, SEQUENCE#, STATUS from v$log where SEQUENCE#=1;
    GROUP#  SEQUENCE# STATUS
---------- ---------- ----------------
         1          1 CURRENT

SQL> select member from v$logfile where group#=1;
MEMBER
--------------------------------------------------------------------------------
/backup/orcl11/hot/redo01.log

 

4. recover 재시도 후 redolog 적용

SQL> recover database using backup controlfile;
ORA-00279: change 2457956 generated at 07/15/2024 14:00:20 needed for thread 1
ORA-00289: suggestion : /backup/orcl11/hot/arch/1_1_1174399217.dbf
ORA-00280: change 2457956 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/backup/orcl11/hot/redo01.log   **********해당 로그파일 입력
Log applied.
Media recovery complete.

 

5. DB open

SQL> alter database open resetlogs;

Database altered.