ORA-01552: 非系统表空间 '' 不能使用系统回退段 ORA-01552 and ORA-00942 Rollback Segments Offline Received During Installation

Posted by PDSERVICE on May 28, 2016 In

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

ORA-01552: 非系统表空间 '' 不能使用系统回退段

oerr ora 1552

01552, 00000, "cannot use system rollback segment for non-system tablespace '%s'"

// *Cause: Tried to use the system rollback segment for operations involving

// non-system tablespace. If this is a clone database then this will

// happen when attempting any data modification outside of the system

// tablespace. Only the system rollback segment can be online in a

// clone database.

// *Action: Create one or more private/public segment(s), shutdown and then

// startup again. May need to modify the INIT.ORA parameter

// rollback_segments to acquire private rollback segment. If this is

// a clone database being used for tablspace point in time recovery

// then this operation is not allowed. If the non-system tablespace

// has AUTO segment space management, then create an undo tablespace.

ORA-00942: 表或视图不存在

oerr ora 942

00942, 00000, "table or view does not exist"

// *Cause:

// *Action:

症状

这是安装ASAP时可能发生的一个致命错误。

出现此错误是因为，当创建ASAP的Oracle数据库时，其回滚段默认是离线的。Oracle系统账户要求这些回滚段必须是在线的。

ASAP安装将不得不重新进行。

这些错误是在ASAP安装文件 CreateDatabase.log中发现的:

…<cut>…

Convert ‘SARM’ DB index tablespace to [SARM_INDEX]
Populating static database definitions …
Populating database definition for CTRL (control.sql)

Sequence created.

‘Loading tables/IDENTITY.i’
CHECK (opt5_type = null or opt5_type like ‘-_’),
*
ERROR at line 18:
ORA-01552: cannot use system rollback segment for non-system tablespace ‘ASAP_DATA’

‘Loading tables/alrm_cent.i’
CREATE TABLE tbl_alarm_log (
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace ‘ASAP_DATA’

…<cut>…

‘Loading tables/server_info.i’
CREATE UNIQUE INDEX idx1_alarm_center ON tbl_alarm_center
*
ERROR at line 1:
ORA-00942: table or view does not exist

CREATE UNIQUE INDEX idx1_appl_proc ON tbl_appl_proc
*
ERROR at line 1:
ORA-00942: table or view does not exist

…<cut>…

原因

原因:对于操作涉及非系统表空间的，尝试使用系统回滚段。如果这是一个克隆数据库，则当在系统表空间外尝试任何数据修改时，会出现这种情况。在克隆数据库中只有系统回滚段可以联机。

01552, 00000, “cannot use system rollback segment for non-system tablespace ‘%s'”

解决方案

创建一个或多个公用/私有段，关机然后重启。你可能需要修改INIT.ORA参数回滚段来获得一个私有回滚段。如果这是一个用于表空间时间点恢复的克隆数据库，则该操作不被允许。

You are here

ORA-01552: 非系统表空间 '' 不能使用系统回退段 ORA-01552 and ORA-00942 Rollback Segments Offline Received During Installation