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

This article introduces the knowledge of "error reporting in the startup process after Oracle database storage migration: how to solve ORA-00210 ORA-00202 ORA-17503 ORA-15173". 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!

After storage migration, an error is reported when the database is started through the cluster

SUCCESS: diskgroup NEWDATA was mounted

ORA-00210: cannot open the specified control file

ORA-00202: controlfile:'+ NEWDATA/test/controlfile/control02.ctl'

ORA-17503: ksfdopn:2 Failed to open file + NEWDATA/test/controlfile/control02.ctl

ORA-15173: entry 'control02.ctl' does not exist in directory' controlfile'

ORA-00210: cannot open the specified control file

ORA-00202: controlfile:'+ NEWDATA/test/controlfile/control01.ctl'

ORA-17503: ksfdopn:2 Failed to open file + NEWDATA/test/controlfile/control01.ctl

ORA-15173: entry 'control01.ctl' does not exist in directory' controlfile'

ORA-205 signalled during: ALTER DATABASE MOUNT...

But there is no problem with starting manually.

Starting up ORACLE RDBMS Version: 11.1.0.7.0.

Using parameter settings in server-side pfile / oracle/product/11/db/dbs/inittest1.ora

System parameters with non-default values:

....

Check the database alarm log and find that the spfile file is used when the cluster is started:

Starting up ORACLE RDBMS Version: 11.1.0.7.0.

Using parameter settings in server-side spfile + GROUP1/test/spfiletest.ora

System parameters with non-default values:

However, the controlfile parameter of the old spfile parameter file does not point to the correct controlfile file location:

Control_files = "+ NEWDATA/test/controlfile/control01.ctl"

Control_files = "+ NEWDATA/test/controlfile/control02.ctl"

Correct:

Control_files = "+ NEWDATA/test/controlfile/control01.ctl.399.1000116879"

Control_files = "+ NEWDATA/test/controlfile/control02.ctl.400.1000116887"

Solution:

Srvctl modify database-d test-p + NEWDATA/test/spfilespfiletest.ora

Modify the spfile registered in OCR. In fact, this step should be completed during the storage migration, but this step was ignored during the migration.

This is the end of the content of "start-up process error after Oracle database storage migration: how to solve ORA-00210 ORA-00202 ORA-17503 ORA-15173". 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.