ORA-01552 做实验时，修改了undo段的管理模式

undo 段为手动管理模式，是因为做实验时，修改了undo段的管理模式。1.查看undo段状态
SQL> col segment_name for a20
SQL> col owner for a10
SQL> col tablespace_name for a20
SQL> col status for a10
SQL> select SEGMENT_NAME,OWNER,TABLESPACE_NAME,STATUS from dba_rollback_segs;SEGMENT_NAME OWNER TABLESPACE_NAME STATUS
-------------------- ---------- -------------------- ----------
SYSTEM SYS SYSTEM ONLINE
_SYSSMU1_592353410$ PUBLIC UNDOTBS1 OFFLINE
_SYSSMU2_967517682$ PUBLIC UNDOTBS1 OFFLINE
_SYSSMU3_1204390606$ PUBLIC UNDOTBS1 OFFLINE
_SYSSMU4_1003442803$ PUBLIC UNDOTBS1 OFFLINE
_SYSSMU5_538557934$ PUBLIC UNDOTBS1 OFFLINE
_SYSSMU6_2897970769$ PUBLIC UNDOTBS1 OFFLINE
_SYSSMU7_3517345427$ PUBLIC UNDOTBS1 OFFLINE
_SYSSMU8_3901294357$ PUBLIC UNDOTBS1 OFFLINE
_SYSSMU9_1735643689$ PUBLIC UNDOTBS1 OFFLINE
_SYSSMU10_4131489474 PUBLIC UNDOTBS1 OFFLINESEGMENT_NAME OWNER TABLESPACE_NAME STATUS
-------------------- ---------- -------------------- ----------
$
2.查看当前的undo段是哪一个？
SQL> select * from v$rollname; USN NAME
---------- ------------------------------
0 SYSTEM
发现undo段为系统表空间
3.查看undo段的管理模式
SQL> show parameter undoNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL>
SQL>
为手动管理模式，是因为做实验时，修改了undo段的管理模式。4.切换管理模式为自动
SQL> alter system set undo_management=auto scope=spfile;System altered.SQL> show parameter undoNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
undo_retention integer 900
undo_tablespace string UNDOTBS15.重新启动数据库后，查看状态，已改为AUTO模式。问题解决。
SQL> help shutdown SHUTDOWN
-------- Shuts down a currently running Oracle Database instance, optionally
closing and dismounting a database. SHUTDOWN [ABORT|IMMEDIATE|NORMAL|TRANSACTIONAL [LOCAL]]
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup
ORACLE instance started.Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 314575232 bytes
Database Buffers 100663296 bytes
Redo Buffers 6094848 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter undoNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL>
SQL>
SQL> col owner for a10
SQL> col tablespace_name for a20
SQL> col status for a10
SQL> select SEGMENT_NAME,OWNER,TABLESPACE_NAME,STATUS from dba_rollback_segs;SEGMENT_NAME OWNER TABLESPACE_NAME STATUS
-------------------- ---------- -------------------- ----------
SYSTEM SYS SYSTEM ONLINE
_SYSSMU1_592353410$ PUBLIC UNDOTBS1 ONLINE
_SYSSMU2_967517682$ PUBLIC UNDOTBS1 ONLINE
_SYSSMU3_1204390606$ PUBLIC UNDOTBS1 ONLINE
_SYSSMU4_1003442803$ PUBLIC UNDOTBS1 ONLINE
_SYSSMU5_538557934$ PUBLIC UNDOTBS1 ONLINE
_SYSSMU6_2897970769$ PUBLIC UNDOTBS1 ONLINE
_SYSSMU7_3517345427$ PUBLIC UNDOTBS1 ONLINE
_SYSSMU8_3901294357$ PUBLIC UNDOTBS1 ONLINE
_SYSSMU9_1735643689$ PUBLIC UNDOTBS1 ONLINE
_SYSSMU10_4131489474 PUBLIC UNDOTBS1 ONLINESEGMENT_NAME OWNER TABLESPACE_NAME STATUS
-------------------- ---------- -------------------- ----------
$
11 rows selected.SQL> conn scott/tiger
Connected.
SQL> create table t1 as select * from emp;Table created.SQL>更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12配置和自动启动Oracle的监听（lsnrctl）ORA-01102: cannot mount database in EXCLUSIVE mode相关资讯 undo ORA-01552

Oracle 11g undo_retention 以及（05月28日）
undo表空间使用率（07/23/2015 16:29:56）
undo表空间概述（02/24/2015 20:32:43）

Oracle中利用undo进行数据的恢复操（11/27/2015 09:31:30）
undo表空间修复小结（07/08/2015 08:43:13）
Oracle 11gR2 Database UNDO表空间（01/29/2015 11:30:59）

本文评论查看全部评论（0）