在单-单的adg环境中，主库添加数据文件，备库会提示没有加密的警告

№ེུ

2022-04-07

adg添加数据问题提示未加密

主库添加数据文件后，备库会抛出一个警告，日志如下

Recovery created file /u02/oradata/sid/xxxx01.dbf

WARNING：This file /u02/oradata/sid/xxxx01.dbf is created as unencrypted. Please consider encrypting this file!

Successfully added datafile 15 to media recovery

4条回答

默认

Description

Rediscovery Notes

Encryption is enabled

We will see below message in standby alert log for the newly added datafile on primary

---------
Recovery created file <file name>
WARNING: This file <file name> is created
as unencrypted.Please consider encrypting this file! 
Successfully added datafile <datafile number> to media recovery

Patch 28194151 in place

Workaround

=========
set db_create_file_dest

有用 0

cqiwen

we had a situation like yours. We didn’t use the TDE before on this environment. Our Database Version is 12.1.0.2 (APRIL 2017). Single instance with DataGuard.

The warning started on the Standby side after we added a new datafile into another Diskgroup to an existing Tablespace. The warning was generated after this point in time always, doesn’t matter which Diskgroup we used (original one or the new one) to increase a Tablespace.

We found out, that the db_file_create_dest was not configured on the Standby side. We configured it and increased one tablespace with a new datafile, the warning was not generated again. We are monitoring the system.

检查standby端的db_file_create_dest是否配置或是否配置正确。

有用 0