증분백업 복구가 잘 않되고 있습니다.

by reerror posted Nov 08, 2011

8.3.1 사용중입니다.

실수로 테이블 하나의 데이터를 삭제해서 복구하려고 합니다.

cron을 이용한 백업 자동화
(http://cubrid.com/zbxe/?_filter=search&mid=bbs_developer_tutorial&search_target=title_content&search_keyword=%EB%B0%B1%EC%97%85&document_srl=40180)

위 글을 통해 매일 백업을 받고 있어서 레벨 0,1 두 파일(myrose_bk0v000, myrose_bk1v000)로 복구를 진행하려고 합니다.

다른 서버에 똑같은 위치에 경로를 만들어 놓고 복구를 시도했습니다.


]# cubrid restoredb  -l 0  -B /home/cubrid/111106/ myrose

CUBRID 2008 R3.1

]#
]#
]# cubrid restoredb  -l 1  -B /home/cubrid/111108/myrose_bk1v000 myrose
** WARNING ** Incorrect backup volume mounted.
Backup volume /home/cubrid/111108/myrose_bk1v000 is from another backup level
   (Level: 1, expecting 0).

*************************************************************************
The following database backup volume is needed to continue restoring:

Database Name: /home/CUBRID/databases/myrose/myrose
     Volume Name: /home/cubrid/111108/myrose_bk1v000
        Unit Num: 0
    Backup Level: 0 (FULL LEVEL)
Enter one of the following options:
Type
   -  0 to quit.
   -  1 to continue after the volume is mounted/loaded. (retry)
   -  2 to continue after changing the volume's directory or device.

*************************************************************************
0
An error occurred during a database restore, while processing
     Backup Volume: /home/cubrid/111108/myrose_bk1v000
          Unit Num: 0
   Database Volume: /home/CUBRID/databases/myrose/myrose_lgat_001_tmp
    Database Volid: -1
** WARNING: Do not use the database until an error-free restore is achieved.

--->>>
*** FATAL ERROR ***
Media recovery may be needed on volume "/home/CUBRID/databases/myrose/myrose_bkvinf".
Please consult error_log file = /home/CUBRID/log/myrose_restoredb.err for additional information
... ABORT/EXIT IMMEDIATELY ...<<<---
]#

전체 백업만 복구가 되고,
1차 증분 백업은 복구가 않된것 맞죠?


그래서 찾아보니 저와 거의 똑같은 증상에 대한 질문글이 있네요.
http://cubrid.com/zbxe/?mid=bbs_developer_qa&search_target=title_content&search_keyword=Incorrect+backup+volume+mounted&document_srl=39470

-p 옵션에 대한 차이만 있고 증상은 똑같습니다.


완전한 복구 가능한 방법을 알려주십시요.


----------


참고로 백업 파일에 대한 정보는 아래와 같습니다.

]# cubrid restoredb  --list   -B /home/cubrid/111106/myrose_bk0v000 myrose


*** BACKUP HEADER INFORMATION ***

Database Name: /home/CUBRID/databases/myrose/myrose
 DB Creation Time: Thu Nov 11 14:13:20 2010
         Pagesize: 4096
Backup Level: 0 (FULL LEVEL)
        Start_lsa: -1|-1
         Last_lsa: 154458|1184
Backup Time: Sun Nov  6 03:00:02 2011
  Backup Unit Num: 0
Release: 8.3.1
     Disk Version: 8.301
Backup Pagesize: 131072
Zip Method: 1 (LZO1X)
        Zip Level: 1 (ZIP LEVEL 1 - BEST SPEED)
Include Active Log: YES

Database Volume name: /home/CUBRID/databases/myrose/myrose_vinf
   Volume Identifier: -5, Size: 280 bytes (1 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose
   Volume Identifier: 0, Size: 41943040 bytes (10240 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_x001
   Volume Identifier: 1, Size: 41943040 bytes (10240 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_lgar051
   Volume Identifier: -20, Size: 41938944 bytes (10239 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_lginf
   Volume Identifier: -4, Size: 28361 bytes (7 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_lgat
   Volume Identifier: -2, Size: 41943040 bytes (10240 pages)

]#
]# cubrid restoredb  --list   -B /home/cubrid/111108/myrose_bk1v000 myrose


*** BACKUP HEADER INFORMATION ***

Database Name: /home/CUBRID/databases/myrose/myrose
 DB Creation Time: Thu Nov 11 14:13:20 2010
         Pagesize: 4096
Backup Level: 1 (INCREMENTAL LEVEL 1)
        Start_lsa: 154458|1184
         Last_lsa: 196794|416
Backup Time: Tue Nov  8 03:00:12 2011
  Backup Unit Num: 0
Release: 8.3.1
     Disk Version: 8.301
Backup Pagesize: 4096
Zip Method: 1 (LZO1X)
        Zip Level: 1 (ZIP LEVEL 1 - BEST SPEED)
Include Active Log: YES

Database Volume name: /home/CUBRID/databases/myrose/myrose_vinf
   Volume Identifier: -5, Size: 374 bytes (1 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose
   Volume Identifier: 0, Size: 41943040 bytes (10240 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_x001
   Volume Identifier: 1, Size: 41943040 bytes (10240 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_x002
   Volume Identifier: 2, Size: 41943040 bytes (10240 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_x003
   Volume Identifier: 3, Size: 41943040 bytes (10240 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_lgar056
   Volume Identifier: -20, Size: 41943040 bytes (10240 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_lgar057
   Volume Identifier: -20, Size: 41943040 bytes (10240 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_lgar058
   Volume Identifier: -20, Size: 41938944 bytes (10239 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_lginf
   Volume Identifier: -4, Size: 30434 bytes (8 pages)
Database Volume name: /home/CUBRID/databases/myrose/myrose_lgat
   Volume Identifier: -2, Size: 41943040 bytes (10240 pages)

]#