ORACLE还原恢复启动时数据库报ORA-00704, ORA-00604, ORA-00904 - ToB企服应用市场:ToB评测及商务社交产业平台

SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00603: ORACLE server session terminated by fatal error ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-00904: "I"."UNUSABLEBEGINNING#": invalid identifier Process ID: 19288 Session ID: 2 Serial number: 4441

复制代码

#xxx:/opt/oracle19c/product/19.3.0/db_1:N xxx:/opt/oracle11g/product/11.2:N

复制代码

ORACLE_SID = [xxx] ? xxx Oracle SID = xxx Oracle BASE = /opt/oracle11g Oracle HOME = /opt/oracle11g/product/11.2 SQL*Net TNS = /etc ORA_NLS10 = /opt/oracle11g/product/11.2/nls/data

复制代码

>echo $ORACLE_BASE /opt/oracle19c >echo $ORACLE_HOME /opt/oracle19c/product/19.3.0/db_1

复制代码

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.4 and later Information in this document applies to any platform. SYMPTOMS SQL> alter database open; alter database open * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00904: "I"."UNUSABLEBEGINNING#": invalid identifier Process ID: 23346 Session ID: 680 Serial number: 51933 CHANGES After restoring the database to another server by RMAN, it is failed to startup. After upgrade or post upgrade CAUSE >>>>>ORA-00904: "I"."UNUSABLEBEGINNING#": invalid identifier This error appears due to using the incorrect sqlplus environment. For example., By default SQLPLUS will connect to the default ORACLE_HOME, say 12C Home but if you are duplicating the 11g database on same host the it must be Oracle 11g Environment in order to complete the process. 1 - This issue happens when we have installed multiple Oracle Homes in a single system. 2 - We need to make sure that we are in the right environment when we are restoring it. SOLUTION You need to set all the required Environment Variables first as per your need like ORACLE_SID, ORACLE_BASE, ORACLE_HOME, TNS_ADMIN, PATH with proper values (OR) Simply work by going to the bin directory of your required ORACLE_HOME SET ORACLE_HOME=Your_Oracle_Home CD ORACLE_HOME\bin Even if you set all the environment parameter properly, then need to investigate further to verify the rman backup set which used to restore or verify the upgrade logs, component, dba_registry etc. Provide the details requested in below Notes based on the post restore or post upgrade Note 1905616.1 SRDC - Startup Issues: Checklist of Evidence to Supply (Doc ID 1905616.1) Note 1906468.1 SRDC - Startup Shutdown - Oracle Binary and OS Resources: Checklist of Evidence to Supply (Doc ID 1906468.1) Note:1672387.1 SRDC - Data Collection for Upgrade Issues Note 753041.1 How to Diagnose Components with NON VALID Status in DBA_REGISTRY after an Upgrade (Doc ID 753041.1) Note 1965956.1 SRDC - Data Collection for Datapatch issues (Doc ID 1965956.1) Note 1671416.1 SRDC - Required diagnostic data collection for RMAN Restore and Recover Using TFA Collector (Recommended) or Manual Steps (Doc ID 1671416.1)

复制代码