11G RAC+单机DG

最新推荐文章于 2021-11-28 09:14:28 发布

转载最新推荐文章于 2021-11-28 09:14:28 发布 · 233 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/ss-33/p/11514479.html

文章标签：

#数据库

本文详细记录了Oracle数据库在启动过程中遇到的多种错误，包括文件识别错误、权限问题及主备库密码文件不一致等问题，并提供了具体的解决步骤。通过调整文件权限、修改所有者以及同步主备库密码文件，成功解决了数据库启动失败的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

--报错

一、

15:30:45 > startup nomount;
ORA-01565: error in identifying file '+DATA/test/spfilekjdg.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/test/spfilekjdg.ora
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete

---解决办法
[root@test ~]# ll /u01/app/oracle/product/11.2.0/db_1/bin/oracle
-rwsr-s--x 1 oracle oinstall 239501456 Sep 12 10:36 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@test ~]#
[root@test ~]#
[root@test ~]# chown oracle:asmadmin /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@test ~]#
[root@test ~]# ll /u01/app/oracle/product/11.2.0/db_1/bin/oracle
-rwxr-x--x 1 oracle asmadmin 239501456 Sep 12 10:36 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@test ~]#
[root@test ~]# chmod 6751 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@test ~]#
[root@test ~]# ll /u01/app/oracle/product/11.2.0/db_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 239501456 Sep 12 10:36 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@test ~]#

15:32:52 > startup nomount;
ORACLE instance started.

Total System Global Area 2.8862E+11 bytes
Fixed Size 2271480 bytes
Variable Size 2.0938E+10 bytes
Database Buffers 2.6736E+11 bytes
Redo Buffers 314085376 bytes
15:33:08 >
15:33:15 >
15:33:15 >
15:33:15 >
15:33:16 >
15:33:16 > show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/test/spfilekjdg.ora
15:35:44 >
15:35:44 >

二、

--主库报错
Thu Sep 12 17:15:49 2019
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
PING[ARC1]: Heartbeat failed to connect to standby 'kjdg'. Error is 16191.

----原因是主库两个节点密码文件通过 md5sum 查看不一样；把节点1的密码文件传递给节点2后恢复！

[oracle@test2 dbs]$ md5sum orapwtest2
11a33a9aca85269874826rr53ba18fef orapwtest2

[oracle@test1 dbs]$ md5sum orapwtest1
80a333a3a699f08fcaaa3fdc1c176aab orapwtest1

[oracle@kjdg dbs]$ md5sum orapwkjdg
11a33a9aca85269874826rr53ba18fef orapwtestdg

三、

---实操

17:37:39 SYS@testdg(testdg)> select file_name from dba_temp_files;
ERROR:
ORA-01157: cannot identify/lock data file 5502 - see DBWR trace file
ORA-01110: data file 5502: '+DATA/testdg/tempfile/temp_01.dbf'

no rows selected

17:46:03 SYS@testdg(testdg)>
17:46:34 SYS@testdg(testdg)>
17:46:34 SYS@testdg(testdg)>
17:46:35 SYS@testdg(testdg)> alter tablespace temp drop tempfile '+DATA/testdg/tempfile/temp_01.dbf' ;

Tablespace altered.

17:47:32 SYS@testdg(testdg)> select file_name from dba_temp_files;
17:47:35 SYS@testdg(testdg)>

FILE_NAME
--------------------------------------------------------------------------------
+DATA/testdg/tempfile/temp.309.1007744663

17:47:39 SYS@testdg(testdg)> alter tablespace temp add tempfile '+DATA' size 30g autoextend off;

Tablespace altered.

17:47:55 SYS@testdg(testdg)> select file_name from dba_temp_files;

FILE_NAME
--------------------------------------------------------------------------------
+DATA/testdg/tempfile/temp.309.1007744663
+DATA/testdg/tempfile/temp.310.1007747273

转载于:https://www.cnblogs.com/ss-33/p/11514479.html