Updated on 2025-05-29 GMT+08:00

IMPDP PLUGGABLE DATABASE RECOVER

Description

Specifies the rectification phase of importing a PDB.

The IMPDP PLUGGABLE DATABASE RECOVER syntax is used for fine-grained backup and restoration and is called by the backup and restoration tool. You are advised not to directly call the syntax.

Syntax

IMPDP PLUGGABLE DATABASE RECOVER;

Examples

  • Importing and restoring a PDB
    -- Connect to the postgres database as a system administrator and allocate the resource plan instructions for the PDB created during the import.
    gaussdb=# call resource_manager.create_pending_area();
     create_pending_area 
    ---------------------
    
    (1 row)
    -- This API is used to create resources. The resource specifications of the current instance determine whether the resources can be successfully created. If the API reports an error, adjust the parameters based on the error description and try again.
    gaussdb=# CALL resource_manager.create_resource_plan_directive(pdb_name =>'my_pdb1', min_cpu => 4, max_dynamic_memory => '18022MB', max_shared_memory => '14745MB', io_limits=> 300, io_priority => 'High', max_connections => 880);
     create_resource_plan_directive 
    --------------------------------
    
    (1 row)
    gaussdb=# CALL resource_manager.submit_pending_area();
     submit_pending_area 
    ---------------------
    
    (1 row)
    
    -- Connect to the postgres database as a system administrator and enable the PDB created during the import.
    gaussdb=# alter pluggable database my_pdb1 open;
    ALTER PLUGGABLE DATABASE
    
    -- Connect to the PDB and perform the import and restoration operations.
    gaussdb=# \c my_pdb1;
    my_pdb=# IMPDP PLUGGABLE DATABASE RECOVER;
    IMPDP PLUGGABLE DATABASE RECOVER