OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview
DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview
DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Database

SQL - V4.4.2

    Download PDF

    OceanBase logo

    The Unified Distributed Database for the AI Era.

    Follow Us
    Products
    OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
    Resources
    DocsBlogWhite PaperLive DemosTraining & CertificationTicket
    Company
    About OceanBaseTrust CenterLegalPartnerContact Us
    Follow Us

    © OceanBase 2026. All rights reserved

    Cloud Service AgreementPrivacy PolicySecurity
    Contact Us
    Document Feedback
    1. Documentation Center
    2. OceanBase Database
    3. SQL
    4. V4.4.2
    iconOceanBase Database
    SQL - V 4.4.2
    Databases
    • OceanBase Database
    • OceanBase Cloud
    • OceanBase Tugraph
    • Interactive Tutorials
    • OceanBase Best Practices
    Tools
    • OceanBase Cloud Platform
    • OceanBase Migration Service
    • OceanBase Developer Center
    • OceanBase Migration Assessment
    • OceanBase Admin Tool
    • OceanBase Loader and Dumper
    • OceanBase Deployer
    • Kubernetes operator for OceanBase
    • OceanBase Diagnostic Tool
    • OceanBase Binlog Service
    Connectors and Middleware
    • OceanBase Database Proxy
    • Embedded SQL in C for OceanBase
    • OceanBase Call Interface
    • OceanBase Connector/C
    • OceanBase Connector/J
    • OceanBase Connector/ODBC
    • OceanBase Connector/NET
    SQL
    KV
    • V 4.6.0
    • V 4.4.2
    • V 4.3.5
    • V 4.3.3
    • V 4.3.1
    • V 4.3.0
    • V 4.2.5
    • V 4.2.2
    • V 4.2.1
    • V 4.2.0
    • V 4.1.0
    • V 4.0.0
    • V 3.1.4 and earlier

    Initiate restore

    Last Updated:2026-04-02 06:23:57  Updated
    Share
    What is on this page
    Procedure

    folded

    Share

    You can initiate a restore for a backed-up tenant from the following two entry points in the obshell Dashboard:

    • Entry 1: Log in to the obshell Dashboard, go to the TENANTS page, and click Initiate Restore in the upper-right corner.

    • Entry 2: Log in to the obshell Dashboard, go to the TENANTS page, click the name of the tenant in the tenant list to go to the Overview page, click Backup Restore in the left-side navigation pane to go to the Backup Restore page, and click Initiate Restore in the upper-right corner.

    Note

    Entry 1 allows you to initiate a restore from the global **TENANTS** page, and you need to specify or modify the storage configuration when initiating a restore. Entry 2 allows you to initiate a restore from the tenant page, and you can reuse the backup storage configuration of the tenant without specifying or modifying it.

    Procedure

    The following steps are based on Entry Point 1.

    1. Log in to the obshell console.

    2. In the left-side navigation pane, click Tenant Management.

    3. In the upper-right corner of the page that appears, click Initiate Restoration.

    4. When you initiate a restoration on the global page, you need to configure the storage settings for the backed-up file to be restored (this step is only required for Entry Point 1).

    5. After filling in or modifying the settings, click Test.

      Note

      After you click Test, obshell will test the storage settings for the backed-up file to be restored. If the test is successful, the Restore Source Information section will display the name of the source tenant to be restored. If the test fails, an error message will be displayed. Please make sure to enter the correct storage settings.

    6. Fill in the Restore Source Information section. The restore date must be within the specified time range. To obtain the restore time range, you need to install the oceanbase-ce-utils tool package, which allows the system to parse backup set information. For detailed installation instructions, please refer to Introduction to ob_admin. If no restore time is specified, the latest point-in-time will be restored by default.

    7. Fill in the Restore Target Information section.

      Parameter
      Description
      Target Tenant Specify a tenant name, which must be unique. The system will create a corresponding tenant based on the specified tenant name and restore the backup content to this tenant.
      Number of Units per Zone Specify the number of units for each zone. The maximum number of units is determined by the minimum number of OBServer nodes in the zone.
      Replica Type Valid values:
      • General Replica: A standard replica that supports all features and data types, including transaction logs, MemTables, and SSTables. It can quickly switch to a leader to provide services.
      • Read-Only Replica: Contains complete logs, MemTables, and SSTables. It is recommended for scenarios where read consistency requirements are not high.
      Unit Specification The resource specification occupied by the unit. You can manually enter a value within the current configurable range.
      Number of Units Displays the number of units for each zone.

      Note

      The number of units is consistent with the Number of Units per Zone configuration and cannot be modified.

      Zone Priority Specify the priority for the primary replica of the tenant. The zone with the highest priority is considered the primary zone, and there can only be one. If no zone priority is configured, the default priority is Random. The sorting method is as follows:
      1. Select one or more zones from the left list. The left list displays all available zones in the current cluster.
      2. Click the > button in the middle. The selected zones will be moved to the Priority Sorting list.
      3. Repeat steps a and b to add zones with lower priorities.
      4. To adjust the priority, drag and drop zones in the Priority Sorting list to change their order. The priority decreases from top to bottom in the list.
      5. Click the delete button next to a zone or click Restore to Default to move the zone back to the left list in the Priority Sorting list.
    8. Click Initiate Restore to generate a restore task. You can click View Task to view the restore task progress.

    Previous topic

    Immediately backup
    Last

    Next topic

    Performance Monitoring
    Next
    What is on this page
    Procedure