报ORA-01665错误;求助

发布网友发布时间：2022-05-06 03:53

共2个回答

热心网友时间：2022-05-06 05:22

解决办法
把主节点的standby.ctl copy 到stanby节点过去

修改pfile参数

*.control_files='/datas/apps/oracle/oradata/rac2/standby.ctl'

SQL> shutdown
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> create spfile from pfile;

File created.

SQL> create pfile from spfile;

File created.

SQL> create spfile from pfile;

File created.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 281018368 bytes
Fixed Size 1218968 bytes
Variable Size 88082024 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
SQL> alter database mount standby database;

Database altered.

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com