oracle 重建数据库实例

删除实例

停止监听及数据库

[oracle@POC-ORACLE ~]$ lsnrctl stop
[oracle@POC-ORACLE ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jan 5 10:44:43 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> shutdown

查找实例相关的安装信息

[oracle@POC-ORACLE u01]$ find ./ -name $ORACLE_SID
./app/oracle/diag/rdbms/upbs
./app/oracle/diag/rdbms/upbs/upbs
./app/oracle/cfgtoollogs/dbca/upbs
./app/oracle/admin/upbs
./app/oracle/audit/upbs
./database/cfgtoollogs/dbca/upbs
./database/admin/upbs

查找实例相关的数据信息

[oracle@POC-ORACLE u02]$ find ./ -name $ORACLE_SID*
./oradata/temp/upbs_temp.dbf
./oradata/upbs.dbf

删除实例相关的信息

rm -rf ./app/oracle/diag/rdbms/upbs
rm -rf ./app/oracle/diag/rdbms/upbs/upbs
rm -rf ./app/oracle/cfgtoollogs/dbca/upbs
rm -rf ./app/oracle/admin/upbs
rm -rf ./app/oracle/audit/upbs
rm -rf ./database/cfgtoollogs/dbca/upbs
rm -rf ./database/admin/upbs

rm -rf ./oradata/upbs.dbf
rm -rf ./oradata/temp/upbs_temp.dbf

删除实例配置项

vi /etc/oratab 

#upbs:/u01/database:N

重建数据库实例

静默安装数据库实例

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname upbs -sid upbs -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL

修改环境变量

[oracle@POC-ORACLE ~]$ vi .bash_profile

ORACLE_SID=upbs
ORACLE_UNQNAME=upbs

重建完成后查看监听

[oracle@POC-ORACLE ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 05-JAN-2021 10:48:03

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=POC-ORACLE)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                04-JAN-2021 21:35:13
Uptime                    0 days 13 hr. 12 min. 50 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/database/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/POC-ORACLE/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=POC-ORACLE)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "upbs" has 1 instance(s).
  Instance "upbs", status READY, has 1 handler(s) for this service...
Service "upbsXDB" has 1 instance(s).
  Instance "upbs", status READY, has 1 handler(s) for this service...
The command completed successfully

问题记录

1、创建实例后startup数据库时报错

LRM-00109: could not open parameter file '/u01/database/dbs/initorcl��

这个在网上查询，只需要将对应的 pfile中的初始化ora复制到对应目录就可以了，但尝试了并不管用。

[oracle@POC-ORACLE pfile]$ pwd
/u01/app/oracle/admin/upbs/pfile

-rw-r----- 1 oracle dba 2055 1月   4 21:30 init.ora.042021213745

另外尝试了修改sid 及重建，对应报错中一直存在乱码。