Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to solve the problem of Warning: ORA-16824 after building DG". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Error report: switchover to 'SBDB1' ORA-16824: multiple warnings, including fast-start failover-related warnings, detected for the database

Reason: after the DG is built, it feels that the parameter DB_FILE_NAME_CONVERT='PROD1','SBDB1' is useless, so it is cleared.

Test:

The main database creates a tablespace, and the standby database takes effect immediately. It is proved that it is not affected by this parameter.

Switchover to 'SBDB1', error: ORA-16824: multiple warnings, including fast-start failover-related warnings, detected for the database. The mistake did not point out the problem in detail.

Show configuration error: ORA-16824: multiple warnings, including fast-start failover-related warnings, detected for the database. This error did not point out the problem in detail.

Show database verbose 'SBDB1' error: Warning: ORA-16714: the value of property DbFileNameConvert is inconsistent with the database setting (warning: ORA-16714: the value of the property DbFileNameConvert is not consistent with the database setting) explicitly stated.

Prove that this command is easy to use. Remember.

Clear the DB_FILE_NAME_CONVERT parameter in db_broker

EDIT DATABASE 'PROD1' set PROPERTY DbFileNameConvert=''

EDIT DATABASE 'SBDB1' set PROPERTY DbFileNameConvert=''

Restart the master and slave libraries and execute switchover to 'SBDB1'. The master and slave libraries are switched successfully.

This is the end of the content of "how to solve the problem of Warning: ORA-16824 after DG is built". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.