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

• Prerequisites

  For details about how to import the PDB, see Examples in chapter IMPDP PLUGGABLE DATABASE CREATE.

• 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