CDB搭建ADG，PDB会同步吗？

清疚 2022-09-07 01:21 184阅读 0赞

主库创建DGPDB  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70]  
备库也可以查看到DGPBD  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 1]  
主库将DGPDB置于open状态  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 2]  
备库DGPDB仍未`mounted`  
![在这里插入图片描述][63f0cf9488d443638dcb34aedecd76d1.png]  
![在这里插入图片描述][eb6aa97eb09746ff929540f4f9cb84f7.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 3]  
![在这里插入图片描述][b57354d2a4664a84a9170b11cd72d40e.png]

ORA-01111: name for data file 22 is unknown - rename to correct file

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 4]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 5]

ORA-01156: recovery or flashback in progress may need access to files

![在这里插入图片描述][18011fde2bea497eaf29302a82a4c6c8.png]

ORA-01516: nonexistent log file, data file, or temporary file "/opt/oracle/products/dbs/UNNAMED00022" in the current container

![在这里插入图片描述][95102f0290ca4a3d95da61564f450b9f.png]  
![在这里插入图片描述][be2c6a27c5a04519bb5576ee64c5b847.png]

ORA-65040: operation not allowed from within a pluggable database

![在这里插入图片描述][6a75be4465d24afc8f32db8c8d182f41.png]

ORA-01147: SYSTEM tablespace file 22 is offline

![在这里插入图片描述][257974e5f4ca42e8ba17f73f7bfae3dd.png]  
![在这里插入图片描述][e2c3e010d08e43faa1fb5476cc12ee4f.png]  
![在这里插入图片描述][2f574a2e91d54f4c9f20cccd8e0df0b0.png]

alter database create datafile '/opt/oracle/products/dbs/UNNAMED00022' as '/data/BACKUP/datafile/UNNAMED00022.dbf';
    alter database create datafile '/opt/oracle/products/dbs/UNNAMED00023' as '/data/BACKUP/datafile/UNNAMED00023.dbf';
    alter database create datafile '/opt/oracle/products/dbs/UNNAMED00024' as '/data/BACKUP/datafile/UNNAMED00024.dbf';
    alter database create datafile '/opt/oracle/products/dbs/UNNAMED00025' as '/data/BACKUP/datafile/UNNAMED00025.dbf';

![在这里插入图片描述][42d6bb89b24444b08603beeaab25725d.png]

![在这里插入图片描述][85dd131c1eab4455badf65fe62a1401e.png]  
![在这里插入图片描述][3f3fa97732bf45adbcfe7080b5cb5965.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 6]  
![在这里插入图片描述][6d74beda89b747469e7406feff6573bf.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 7]

![在这里插入图片描述][faa1b15bfe29467190856d7f93091b69.png]

ORA-65054: Cannot open a pluggable database in the desired mode.

![在这里插入图片描述][53f1387e3bcb4d40a6e0f4e72a5ec25d.png]  
![在这里插入图片描述][e5b0be50e06e44c88e899dc322adead8.png]

Errors in file /opt/oracle/diag/rdbms/backup/bpxtest_1/trace/bpxtest_1_ora_20926.trc:
    ORA-10879: error signaled in parallel recovery slave 
    ORA-10562: Error occurred while applying redo to data block (file# 22, block# 19257)
    ORA-10564: tablespace SYSTEM
    ORA-01110: data file 22: '/data/BACKUP/datafile/UNNAMED00022.dbf'
    ORA-10560: block type '0'
    ORA-00600: internal error code, arguments: [4552], [1], [0], [], [], [], [], [], [], [], [], []

![在这里插入图片描述][6ee9651f3f124f63b96f8abadd858b73.png]

ORA-01155: the database is being opened, closed, mounted or dismounted

![在这里插入图片描述][bc3039f0eaf14a69aaf93724056e2318.png]  
![在这里插入图片描述][b0bff5499ce945638672dcc6b10c3c23.png]  
![在这里插入图片描述][4f9f6080d858449e9df0788a4b8fb2f9.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70]: /images/20220829/60754f04abea4f018a2a441cb6a3d53b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 1]: /images/20220829/1ea219db54f548b0a95f5ceda3179d3c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 2]: /images/20220829/6f4744c823d744a785abf1e6d97fbf96.png
[63f0cf9488d443638dcb34aedecd76d1.png]: /images/20220829/0c945fa146ad40ea8f690bb447611d60.png
[eb6aa97eb09746ff929540f4f9cb84f7.png]: /images/20220829/f069cb60d38b43fdbaa1d87ac70d384f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 3]: /images/20220829/f859d8578d244022864bc2ec3b42615e.png
[b57354d2a4664a84a9170b11cd72d40e.png]: /images/20220829/089a616d37604cb99d6eeeef859d91c8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 4]: /images/20220829/680cd4e7534c40f4abb41816ab6e8e84.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 5]: /images/20220829/6aa9039998dd4d509dfb037295544162.png
[18011fde2bea497eaf29302a82a4c6c8.png]: /images/20220829/18b3bb84235541a5975c1fbc3c2e35df.png
[95102f0290ca4a3d95da61564f450b9f.png]: /images/20220829/17b32bf16e234bb8b7bb199a95090bc3.png
[be2c6a27c5a04519bb5576ee64c5b847.png]: /images/20220829/df93981bf7d040f2bdb14549565827e5.png
[6a75be4465d24afc8f32db8c8d182f41.png]: /images/20220829/b5dc472692384856aaa61d6a46826fe8.png
[257974e5f4ca42e8ba17f73f7bfae3dd.png]: /images/20220829/04179efd6b80474db9079e7c0ececf6b.png
[e2c3e010d08e43faa1fb5476cc12ee4f.png]: /images/20220829/edaede6e42644961a46f1403cb1d149d.png
[2f574a2e91d54f4c9f20cccd8e0df0b0.png]: /images/20220829/e3cdda5c5f0145128cae3cd3e5294854.png
[42d6bb89b24444b08603beeaab25725d.png]: /images/20220829/0f9f110e24544517a916f53af2568948.png
[85dd131c1eab4455badf65fe62a1401e.png]: /images/20220829/78354225de6742c9971ef334026cf99d.png
[3f3fa97732bf45adbcfe7080b5cb5965.png]: /images/20220829/4065a2be66aa402faafee744c9325c9b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 6]: /images/20220829/3e5b4b4b3eb242faa52d7b414cfc2fc4.png
[6d74beda89b747469e7406feff6573bf.png]: /images/20220829/fdef8a5f511341afb740b824954e6f58.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hlenVpaml1ZGV4aWFvYmFp_size_16_color_FFFFFF_t_70 7]: /images/20220829/bacdf5cf420e4ec0a52451f00be1a880.png
[faa1b15bfe29467190856d7f93091b69.png]: /images/20220829/38c6ed8324564d51bc8ffc9bba47b3a7.png
[53f1387e3bcb4d40a6e0f4e72a5ec25d.png]: /images/20220829/eb35fb3a569d470a95ef08d89e800817.png
[e5b0be50e06e44c88e899dc322adead8.png]: /images/20220829/e783c42f8e5d4a86a8efbfaf8d7eb290.png
[6ee9651f3f124f63b96f8abadd858b73.png]: /images/20220829/8278b070e2c04e28b80dd5147ebcc74e.png
[bc3039f0eaf14a69aaf93724056e2318.png]: /images/20220829/41c2c3a8290e42daa8c67b89cae57db2.png
[b0bff5499ce945638672dcc6b10c3c23.png]: /images/20220829/92ff5849b10b4d1892eb4d148a757870.png
[4f9f6080d858449e9df0788a4b8fb2f9.png]: /images/20220829/35568f7160b645efbdae39953719b8eb.png