主库：
SQL> create pluggable database pdb04 from xxx@xxx tempfile reuse standbys=none;
备库：
查看alert.log
Recovery created pluggable database PDB04
PDB04(6):File #91 added to control file as 'UNNAMED00091'. Originally created as:
PDB04(6):'+DATA/TEST/C7B3767B7134316DE0537A784E0A5D9E/DATAFILE/system.464.1078592193'
PDB04(6):because the pluggable database was created with nostandby
PDB04(6):or the tablespace belonging to the pluggable database is
PDB04(6):offline.
PDB04(6):File #92 added to control file as 'UNNAMED00092'. Originally created as:
PDB04(6):'+DATA/TEST/C7B3767B7134316DE0537A784E0A5D9E/DATAFILE/sysaux.541.1078592193'
PDB04(6):because the pluggable database was created with nostandby
PDB04(6):or the tablespace belonging to the pluggable database is
PDB04(6):offline.
PDB04(6):File #93 added to control file as 'UNNAMED00093'. Originally created as:
PDB04(6):'+DATA/TEST/C7B3767B7134316DE0537A784E0A5D9E/DATAFILE/undotbs1.548.1078592193'
PDB04(6):because the pluggable database was created with nostandby
PDB04(6):or the tablespace belonging to the pluggable database is
PDB04(6):offline.
PDB04(6):File #94 added to control file as 'UNNAMED00094'. Originally created as:
PDB04(6):'+DATA/TEST/C7B3767B7134316DE0537A784E0A5D9E/DATAFILE/undotbs2.327.1078592193'
PDB04(6):because the pluggable database was created with nostandby
PDB04(6):or the tablespace belonging to the pluggable database is
PDB04(6):offline.
1、从主库拉一遍PDB
[oracle@szk1 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jul 22 17:00:19 2021
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: TEST (DBID=2376458686)
RMAN> @copy.cmd
RMAN> run{
2> set newname for pluggable database PDB04 to new;
3> restore pluggable database PDB04 from service "test";
4> }
executing command: SET NEWNAME
Starting restore at 22-JUL-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4501 instance=testadg1 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service test
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00091 to +DATA
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service test
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00092 to +DATA
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service test
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00093 to +DATA
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: using network backup set from service test
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00094 to +DATA
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 22-JUL-21
RMAN> switch pluggable database pdb04 to copy;
datafile 91 switched to datafile copy "+DATA/TESTADG/C7B3767B7134316DE0537A784E0A5D9E/DATAFILE/system.2372.1078592431"
datafile 92 switched to datafile copy "+DATA/TESTADG/C7B3767B7134316DE0537A784E0A5D9E/DATAFILE/sysaux.2373.1078592445"
datafile 93 switched to datafile copy "+DATA/TESTADG/C7B3767B7134316DE0537A784E0A5D9E/DATAFILE/undotbs1.2374.1078592461"
datafile 94 switched to datafile copy "+DATA/TESTADG/C7B3767B7134316DE0537A784E0A5D9E/DATAFILE/undotbs2.2375.1078592467"
RMAN> **end-of-file**
RMAN>
SQL> select name, recovery_status from v$pdbs;
NAME RECOVERY
---------------------------------------------------------------------------------------------------- --------
PDB$SEED ENABLED
PDB01 ENABLED
PDB04 DISABLED
6 rows selected.
SQL> col name for a100
SQL> select name, status from v$datafile;
NAME STATUS
---------------------------------------------------------------------------------------------------- -------
+DATA/TESTADG/DATAFILE/system.2291.1078504113 SYSTEM
+DATA/TESTADG/DATAFILE/sysaux.2292.1078504115 ONLINE
+DATA/TESTADG/DATAFILE/undotbs1.2293.1078504119 ONLINE
+DATA/TESTADG/C7725F37F62C56B2E05379784E0A8D94/DATAFILE/system.2318.1078504119 SYSTEM
+DATA/TESTADG/C7725F37F62C56B2E05379784E0A8D94/DATAFILE/sysaux.2319.1078504121 ONLINE
+DATA/TESTADG/DATAFILE/users.2320.1078504121 ONLINE
+DATA/TESTADG/C7725F37F62C56B2E05379784E0A8D94/DATAFILE/undotbs1.2321.1078504123 ONLINE
+DATA/TESTADG/DATAFILE/undotbs2.2322.1078504125 ONLINE
+DATA/TESTADG/C78B2D0BF1A8325BE0537A784E0AFBA9/DATAFILE/system.2323.1078504125 SYSTEM
+DATA/TESTADG/C78B2D0BF1A8325BE0537A784E0AFBA9/DATAFILE/sysaux.2324.1078504127 ONLINE
+DATA/TESTADG/C78B2D0BF1A8325BE0537A784E0AFBA9/DATAFILE/undotbs1.2325.1078504127 ONLINE
+DATA/TESTADG/C78B2D0BF1A8325BE0537A784E0AFBA9/DATAFILE/undo_2.2326.1078504129 ONLINE
+DATA/TESTADG/C78B2D0BF1A8325BE0537A784E0AFBA9/DATAFILE/test.2327.1078504131 ONLINE
+DATA/TESTADG/C78B8200443B919DE0537A784E0A0B8B/DATAFILE/system.2328.1078504131 SYSTEM
+DATA/TESTADG/C78B8200443B919DE0537A784E0A0B8B/DATAFILE/sysaux.2329.1078504133 ONLINE
+DATA/TESTADG/C78B8200443B919DE0537A784E0A0B8B/DATAFILE/undotbs1.2330.1078504133 ONLINE
+DATA/TESTADG/C78B8200443B919DE0537A784E0A0B8B/DATAFILE/undo_2.2331.1078504135 ONLINE
+DATA/TESTADG/C78B8200443B919DE0537A784E0A0B8B/DATAFILE/test.2332.1078504137 ONLINE
+DATA/TESTADG/C79DB29FC82DE5C3E0537A784E0A8D6B/DATAFILE/system.2333.1078504137 SYSTEM
+DATA/TESTADG/C79DB29FC82DE5C3E0537A784E0A8D6B/DATAFILE/sysaux.2334.1078504141 ONLINE
+DATA/TESTADG/C79DB29FC82DE5C3E0537A784E0A8D6B/DATAFILE/undotbs1.2335.1078504143 ONLINE
+DATA/TESTADG/C79DB29FC82DE5C3E0537A784E0A8D6B/DATAFILE/undotbs2.2336.1078504147 ONLINE
+DATA/TESTADG/C7AE82446A6A4783E0537A784E0A8A93/DATAFILE/system.2368.1078573721 SYSTEM
+DATA/TESTADG/C7AE82446A6A4783E0537A784E0A8A93/DATAFILE/sysaux.2369.1078573737 ONLINE
+DATA/TESTADG/C7AE82446A6A4783E0537A784E0A8A93/DATAFILE/undotbs1.2370.1078573753 ONLINE
+DATA/TESTADG/C7AE82446A6A4783E0537A784E0A8A93/DATAFILE/undotbs2.2371.1078573759 ONLINE
/u01/app/oracle/product/19.3.0/db_1/dbs/UNNAMED00091 SYSOFF
/u01/app/oracle/product/19.3.0/db_1/dbs/UNNAMED00092 RECOVER
/u01/app/oracle/product/19.3.0/db_1/dbs/UNNAMED00093 RECOVER
/u01/app/oracle/product/19.3.0/db_1/dbs/UNNAMED00094 RECOVER
30 rows selected.
SQL> select name, recovery_status from v$pdbs;
NAME RECOVERY
---------------------------------------------------------------------------------------------------- --------
PDB$SEED ENABLED
PDB01 ENABLED
PDB04 DISABLED
6 rows selected.
SQL>
2、关闭ADG日志应用
DGMGRL> edit database testadg set status='apply-off';
3、修改PDB reovery_stats状态
--重启数据库到mount状态
--切换到PDB
SQL> alter session set container=pdb04;
Session altered.
SQL> alter pluggable database enable recovery;
Pluggable database altered.
4、修改PDB数据文件状态
SQL> @online_files.sql
Database altered.
Database altered.
Database altered.
Database altered.
5、开启备库应用日志
DGMGRL> edit database testadg set status='apply-on';
6、PDB数据库OPEN
alter pluggable database XXX open instances=all;
最后修改时间：2021-09-26 17:11:19
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
