Shulou(Shulou.com)06/01 Report--

Today, when checking the automatic backup, I found that many databases were reported wrong, so go and check them quickly.

I had been reporting a mistake all the time, and I didn't know what was going on.

First check the contents of the error report

ORA-39097 ora-39065 ora-12805, these three errors.

Went to Google, Baidu, official explanation, it all means that it is because of parallelism, but the backed-up files are not placed on shared storage.

I checked and found that no parallel parameter was added to enable parallelism, and my backup is a single node backup, which must be placed locally rather than on shared storage. Then according to the official, add a parameter.

Cluster=no roughly means that the cluster is forced to shut down during backup.

Then I added a parameter backup, and there was an error, but the backup was completed. If I reported an error before, I stopped the backup immediately.

Just have a backup. Specific errors need to be studied.

If this doesn't work,

Use the sysdba user to log in to the database to execute the command:

Execute utl_recomp.recomp_serial ()

This command seems to be used to solve some bug of this 12.1.0.1 version of expdp. There is no problem with backup after execution.

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.