Oracle数据库在线P2V迁移后，无法启动，故障处理！-优快云博客

在这里插入图片描述

问题现象:

oracle执行open，几秒后自动宕机

前台报错:

ORA-03135: connection lost contact

后台报错:经典的 4194 错误

Errors in file /u01/app/oracle/diag/rdbms/cjc/cjc/trace/cjc_m001_58727.trc  (incident=301489):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/cjc/cjc/incident/incdir_301489/cjc_m001_58727_i301489.trc

问题原因:

Oracle数据库在打开的情况下进行的P2V，导致UNDO文件损坏，正常应该先停库，再进行迁移，否则很大概率会出现文件损坏、数据不一致等问题。

环境说明:

OS:Redhat 6.5
DB:Oracle 11.2.4.0

解决方案:

重建UNDO。

1.生成pfile

SQL> create pfile from spfile;
File created.

2.修改UNDO参数

[oracle@cjc dbs]$ vi initcjc.ora 
......
#*.undo_tablespace='UNDOTBS1'
*.undo_management='MANUAL'
*.undo_tablespace='SYSTEM'

3.重命名spfile

[oracle@cjc dbs]$ mv spfilecjc.ora spfilecjc.ora.bak

4.启动数据库

SQL> startup 
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2260088 bytes
Variable Size            1325400968 bytes
Database Buffers         2936012800 bytes
Redo Buffers               12107776 bytes
Database mounted.
Database opened.

5.重建UNDO

SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      MANUAL
undo_retention                       integer     900
undo_tablespace                      string      SYSTEM

SQL> SELECT TABLESPACE_NAME FROM DBA_TABLESPACES;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
CJC

9 rows selected.

SQL> CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/cjc/oradata/cjc/undotbs02.dbf' size 100M autoextend on;
Tablespace created

SQL> drop tablespace UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;
Tablespace dropped.

6.生成spfile，启动数据库

SQL> CREATE SPFILE FROM PFILE;
File created.

SQL> shutdown immediate;
SQL> startup
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size                  2260088 bytes
Variable Size            1325400968 bytes
Database Buffers         2936012800 bytes
Redo Buffers               12107776 bytes
Database mounted.
Database opened.