暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

有关pdb的碎片笔记

原创 2020-08-21
781

Creation of a PDB by Relocating

To relocate a PDB from one CDB to another, use the CREATE PLUGGABLE DATABASE statement with the FROM clause and RELOCATE keyword.

This technique has the following advantages:

The relocation occurs with minimal downtime.
The technique keeps the PDB being relocated open in read/write mode during the relocation, and then brings the PDB online in its new location.
A database link created at the destination CDB is required. Also, the source PDB must use local undo data

How to create application seed

You can create application seeds in several different ways, including using the CDB seed, cloning an existing PDB or non-CDB, and plugging in an unplugged PDB. You can also remove application seeds from application containers.

Global name

When you manage database links in a CDB, the root has a unique global database name, and so does each PDB. The global name of the root is defined by the DB_NAME and DB_DOMAIN initialization parameters. The global database name of a PDB is defined by the PDB name and the DB_DOMAIN initialization parameter. The global database name of each PDB must be unique within the domain.

Managing the following components:(WITH ROOT CDB)

Processes
Memory
Errors and alerts
Diagnostic data
Control files
The online redo log and the archived redo log files
Undo

RESTRICTED mode(about PDB rename)

If you specify the optional RESTRICTED keyword, then the PDB is accessible only to users with the RESTRICTED SESSION privilege in the PDB.

when rename PDB’s global_name:
For an Oracle Real Application Clusters (Oracle RAC) database, the PDB must be open on the current instance only. The PDB must be closed on all other instances.
When you change the global database name of a PDB, the PDB name is changed to the first part of the new global name, which is the part before the first period. Also, Oracle Database changes the name of the default database service for the PDB automatically. Oracle Database also changes the PDB property of all database services in the PDB to the new global name of the PDB. You must close the PDB and open it in read/write mode for Oracle Database to complete the integration of the new PDB service name into the CDB, as shown in steps 3 and 4.当您更改PDB的全局数据库名称时,PDB名称将更改为新的全局名称的第一部分,即第一期间之前的部分。 另外,Oracle数据库会自动更改PDB的默认数据库服务的名称。 Oracle数据库还将PDB中所有数据库服务的PDB属性更改为PDB的新全局名称。 您必须关闭PDB并以读/写模式打开Oracle数据库,以完成新PDB服务名称到CDB的集成,如步骤3和4所示。(close and open in read write)

Oracle Net Services must be configured properly for clients to access database services. You might need to alter your Oracle Net Services configuration as a result of the PDB name change.必须正确配置Oracle Net Services,以便客户端访问数据库服务。 由于PDB名称更改,您可能需要更改Oracle Net Services配置。

when shutdown abort

For a single-instance CDB, PDB media recovery is required when you specify SHUTDOWN ABORT. For an Oracle Real Application Clusters (Oracle RAC) CDB, PDB media recovery is required if the SHUTDOWN ABORT command closes the last open instance.

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论