BACKUPVOLINFO
설명
BACKUPVOLINFO 명령은 해당 데이터베이스의 백업 정보를 확인하는 데 사용된다. BACKUPDBINFO는 해당 DB의 전반적인 백업 정보를 출력하고 BACKUPVOLINFO는 해당 DB의 해당 백업 볼륨에 대한 정보를 상세하게 출력한다.
구문
BACKUPVOLINFO 명령의 문법은 다음과 같다. 볼드체는 필수 입력 정보이다.
task:backupvolinfo
token:{cmserver 인증후 받은 token 문자열}
dbname:{조회할 데이터베이스명}
예제
demodb 데이터베이스 백업 정보를 조회하는 예제이다.
--request--
task:backupvolinfo
token:4504b930fc1be99bcd937c8bdb7f87608375a218acf865b0918e032c738469ff7926f07dd201b6aa
dbname:demodb
level:0
pathname:/opt/frameworks/cubrid/databases/demodb/backup/demodb_backup_lv0
--response:success--
task:backupvolinfo
status:success
note:none
line:
line:
line:*** BACKUP HEADER INFORMATION ***
line:
line:Database Name: /opt/frameworks/cubrid2/databases/demodb/demodb
line: DB Creation Time: Sun Jun 14 09:53:15 2009
line: Pagesize: 4096
line:Backup Level: 0 (FULL LEVEL)
line: Start_lsa: -1|-1
line: Last_lsa: 4836|40
line:Backup Time: Fri Jun 26 22:37:32 2009
line: Backup Unit Num: 0
line:Release: 8.2.0
line: Disk Version: 8.2
line:Backup Pagesize: 131072
line:Zip Method: 1 (LZO1X)
line: Zip Level: 1 (ZIP LEVEL 1 - BEST SPEED)
line:Include Active Log: YES
line:
line:Database Volume name: /opt/frameworks/cubrid2/databases/demodb/demodb_vinf
line: Volume Identifier: -5, Size: 351 bytes (1 pages)
line:Database Volume name: /opt/frameworks/cubrid2/databases/demodb/demodb
line: Volume Identifier: 0, Size: 10485760 bytes (2560 pages)
line:Database Volume name: /opt/frameworks/cubrid2/databases/demodb/demodb_data_x001
line: Volume Identifier: 1, Size: 10485760 bytes (2560 pages)
line:Database Volume name: /opt/frameworks/cubrid2/databases/demodb/demodb_lginf
line: Volume Identifier: -4, Size: 665 bytes (1 pages)
line:Database Volume name: /opt/frameworks/cubrid2/databases/demodb/demodb_lgat
line: Volume Identifier: -2, Size: 10485760 bytes (2560 pages)
line:
--response:success(운영 상태의 DB)--
task:backupvolinfo
status:failure
note:Database(activedb) is active state.
--response:success(존재하지 않는 백업 볼륨)--
task:backupvolinfo
status:success
note:none
line:Unable to mount disk volume "/opt/frameworks/cubrid/databases/demodb/backup/demodb_backup_lv3".... No such file or directory
line:
line:*************************************************************************
line:The following database backup volume is needed to continue restoring:
line:
line:Database Name: /opt/frameworks/cubrid2/databases/demodb/demodb
line: Volume Name: /opt/frameworks/cubrid/databases/demodb/backup/demodb_backup_lv3
line: Unit Num: 0
line: Backup Level: 0 (FULL LEVEL)
line:Enter one of the following options:
line:Type
line: - 0 to quit.
line: - 1 to continue after the volume is mounted/loaded. (retry)
line: - 2 to continue after changing the volume's directory or device.
line:
line:*************************************************************************
--response:success(존재하지 않는 DB : 에러는 발생하지 않음)--
task:backupvolinfo
status:success
note:none
※ dbname에 해당하는 데이터베이스가 없어도 에러가 발생하지 않는다.
설명
BACKUPVOLINFO 명령은 해당 데이터베이스의 백업 정보를 확인하는 데 사용된다. BACKUPDBINFO는 해당 DB의 전반적인 백업 정보를 출력하고 BACKUPVOLINFO는 해당 DB의 해당 백업 볼륨에 대한 정보를 상세하게 출력한다.
구문
BACKUPVOLINFO 명령의 문법은 다음과 같다. 볼드체는 필수 입력 정보이다.
task:backupvolinfo
token:{cmserver 인증후 받은 token 문자열}
dbname:{조회할 데이터베이스명}
예제
demodb 데이터베이스 백업 정보를 조회하는 예제이다.
--request--
task:backupvolinfo
token:4504b930fc1be99bcd937c8bdb7f87608375a218acf865b0918e032c738469ff7926f07dd201b6aa
dbname:demodb
level:0
pathname:/opt/frameworks/cubrid/databases/demodb/backup/demodb_backup_lv0
--response:success--
task:backupvolinfo
status:success
note:none
line:
line:
line:*** BACKUP HEADER INFORMATION ***
line:
line:Database Name: /opt/frameworks/cubrid2/databases/demodb/demodb
line: DB Creation Time: Sun Jun 14 09:53:15 2009
line: Pagesize: 4096
line:Backup Level: 0 (FULL LEVEL)
line: Start_lsa: -1|-1
line: Last_lsa: 4836|40
line:Backup Time: Fri Jun 26 22:37:32 2009
line: Backup Unit Num: 0
line:Release: 8.2.0
line: Disk Version: 8.2
line:Backup Pagesize: 131072
line:Zip Method: 1 (LZO1X)
line: Zip Level: 1 (ZIP LEVEL 1 - BEST SPEED)
line:Include Active Log: YES
line:
line:Database Volume name: /opt/frameworks/cubrid2/databases/demodb/demodb_vinf
line: Volume Identifier: -5, Size: 351 bytes (1 pages)
line:Database Volume name: /opt/frameworks/cubrid2/databases/demodb/demodb
line: Volume Identifier: 0, Size: 10485760 bytes (2560 pages)
line:Database Volume name: /opt/frameworks/cubrid2/databases/demodb/demodb_data_x001
line: Volume Identifier: 1, Size: 10485760 bytes (2560 pages)
line:Database Volume name: /opt/frameworks/cubrid2/databases/demodb/demodb_lginf
line: Volume Identifier: -4, Size: 665 bytes (1 pages)
line:Database Volume name: /opt/frameworks/cubrid2/databases/demodb/demodb_lgat
line: Volume Identifier: -2, Size: 10485760 bytes (2560 pages)
line:
--response:success(운영 상태의 DB)--
task:backupvolinfo
status:failure
note:Database(activedb) is active state.
--response:success(존재하지 않는 백업 볼륨)--
task:backupvolinfo
status:success
note:none
line:Unable to mount disk volume "/opt/frameworks/cubrid/databases/demodb/backup/demodb_backup_lv3".... No such file or directory
line:
line:*************************************************************************
line:The following database backup volume is needed to continue restoring:
line:
line:Database Name: /opt/frameworks/cubrid2/databases/demodb/demodb
line: Volume Name: /opt/frameworks/cubrid/databases/demodb/backup/demodb_backup_lv3
line: Unit Num: 0
line: Backup Level: 0 (FULL LEVEL)
line:Enter one of the following options:
line:Type
line: - 0 to quit.
line: - 1 to continue after the volume is mounted/loaded. (retry)
line: - 2 to continue after changing the volume's directory or device.
line:
line:*************************************************************************
--response:success(존재하지 않는 DB : 에러는 발생하지 않음)--
task:backupvolinfo
status:success
note:none
※ dbname에 해당하는 데이터베이스가 없어도 에러가 발생하지 않는다.
TAG 큐브리드
