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)
]#
