Tibero Active Storage  Administrator's Guide

Tibero 6


Restricted Rights Legend

All TmaxData Software (Tibero®) and documents are protected by copyright laws and international convention. TmaxData software and documents are made available under the terms of the TmaxData License Agreement and this document may only be distributed or copied in accordance with the terms of this agreement. No part of this document may be transmitted, copied, deployed, or reproduced in any form or by any means, electronic, mechanical, or optical, without the prior written consent of TmaxData Co., Ltd. Nothing in this software document and agreement constitutes a transfer of intellectual property rights regardless of whether or not such rights are registered) or any rights to TmaxData trademarks, logos, or any other brand features.

This document is for information purposes only. The company assumes no direct or indirect responsibilities for the contents of this document, and does not guarantee that the information contained in this document satisfies certain legal or commercial conditions. The information contained in this document is subject to change without prior notice due to product upgrades or updates. The company assumes no liability for any errors in this document.

Trademarks

Tibero® is a registered trademark of TmaxData Co., Ltd. Other products, titles or services may be registered trademarks of their respective companies.

Open Source Software Notice

Some modules or files of this product are subject to the terms of the following licenses. : OpenSSL, RSA Data Security, Inc., Apache Foundation, Jean-loup Gailly and Mark Adler, Paul Hsieh's hash

Detailed Information related to the license can be found in the following directory : ${INSTALL_PATH}/license/oss_licenses

Document Information

Title: Tibero Active Storage  Administrator's Guide

Publication Date: 2020-03-13

Software Version: Tibero 6 (FixSet07)

Edition: v2.1.7.4


Table of Contents

About This Document
1. TAS Overview
1.1. Overview
1.2. Basic Concepts of TAS
1.2.1. TAS Instance
1.2.2. TAS Disk Space
1.2.3. Mirroring and Failure Groups
1.2.4. TAS Disk
1.2.5. TAS File
2. TAS Instance Management
2.1. TAS Initialization Parameter Configuration
2.2. TAS Instance Management
2.2.1. Preparations
2.2.2. TAS Startup
2.2.3. TAS Shutdown
2.3. Tibero Instance Configuration
3. TAS Disk Space Management
3.1. Disk Space Properties
3.2. Creating a Disk Space
3.2.1. Using the CREATE DISKSPACE SQL Statement
3.2.2. Example
3.3. Modifying a Disk Space
3.3.1. Adding a Disk
3.3.2. Removing a Disk Space
3.3.3. Unpreparing a Disk
3.3.4. Disk Space Rebalancing
3.3.5. Deleting a File
3.4. Deleting a Disk Space
4. TAS Information Views
4.1. TAS Disk Space Related Views
4.1.1. V$AS_ALIAS
4.1.2. V$AS_DISK
4.1.3. V$AS_DISKSPACE
4.1.4. V$AS_OPERATION
4.1.5. V$AS_EXTENT_MAP
4.1.6. V$AS_FILE
5. Backup and Recovery
5.1. Backup
5.2. Recovery
6. Command Line Tool
6.1. Overview
6.2. TASCMD Execution
6.3. TASCMD Commands
6.3.1. cd
6.3.2. du
6.3.3. exit
6.3.4. help
6.3.5. ls
6.3.6. lsds
6.3.7. pwd
6.3.8. rm
6.3.9. cp, cpfromlocal, cptolocal
A. Tibero Configuration Example
A.1. Preparing for Installation
A.1.1. Installation Environment
A.1.2. Disk Preparation
A.1.3. Kernel Parameter Setting
A.2. TAS Instance Installation
A.2.1. Environment Variable Configuration
A.2.2. Initialization Parameter Configuration
A.2.3. Connection String Configuration
A.2.4. Creating and Starting a Disk Space
A.3. Tibero Instance Installation
A.3.1. Environment Variable Configuration
A.3.2. Initialization Parameter Configuration
A.3.3. Connection String Configuration
A.3.4. Creating and Starting Up a Database
A.4. TAS Recommendations
Index

List of Figures

[Figure 1.1] Configuration of Tibero using TAS
[Figure 1.2] Configuration of Tibero and TAC using the Cluster Function
[Figure 1.3] TAS File Allocation

List of Examples

[Example 2.1] TAS Instance tip File Example
[Example 2.2] TAS Instance Clustering tip File Example: <as0.tip>
[Example 2.3] TAS Instance Clustering tip File Example: <cm0.tip>
[Example 2.4] TAS Instance Clustering tip File Example: <as1.tip>
[Example 2.5] TAS Instance Clustering tip File Example: <cm1.tip>
[Example 2.6] Creating a Configuration File for the as Resource: <as0.profile>
[Example 2.7] Creating a Configuration File for the as Resource: <as1.profile>
[Example 2.8] Example of a Tibero Instance tip File that uses a TAS instance.
[Example 2.9] Example of the CREATE DATABASE of the Tibero Instance that uses a TAS File
[Example 3.1] Creating Disk Space ds0
[Example 3.2] Adding a Disk in Disk Space ds0
[Example 3.3] Removing a Disk from Disk Space ds0
[Example 3.4] Removing a disk in the 'FAIL' state from Disk Space ds0
[Example 3.5] Removing Disks of Failure Group fg1 in Disk Space ds0
[Example 3.6] Adding or Removing a Disk in Disk Space ds0
[Example 3.7] Restoring disk105 State from PREPARE_DROP to ONLINE
[Example 3.8] Rebalancing Disk Space ds0 (1)
[Example 3.9] Rebalancing Disk Space ds0 (2)
[Example 3.10] Deleting a File from Disk Space ds0
[Example 3.11] Deleting Multiple Files from Disk Space ds0
[Example 3.12] Deleting Disk Space ds0
[Example 4.1] Viewing Jobs in Progress
[Example 4.2] Viewing Files and Aliases
[Example 5.1] Backing Up TAS Disk Space Data
[Example 5.2] Recovering TAS Disk Space Data
[Example 6.1] TASCMD Execution Parameters
[Example 6.2] Absolute Path Example
[Example 6.3] Relative Path Example
[Example 6.4] Relative Path Symbol Example