-
编辑 删除
oracle 启动关闭数据库
关于启动关闭数据库的一些常用操作[@more@]sqlplus "/as sysdba"sqlplus /nologconn username/password as sysdbastartup pfile='/adf/adf/adf/init.ora';startupstartup nomountstartup mountalter database open;alter database mount;startup restrict;alter system disable restricted session;alter system enable restricted session;alter database open read only;alter database open read write;alter system quiesce restricted;alter system unquiesce;startup force;startup open recover;alter system suspend;al
-
编辑 删除
ORA-01548: 已找到活动回退段'_SYSSMU1$'，终止删除表空间 解决办法
ORA-01548: 已找到活动回退段'_SYSSMU1$'，终止删除表空间 解决办法[@more@]验证过程：1 查看所有回滚段信息：select segment_name,status,tablespace_name from dba_rollback_segs;SEGMENT_NAME STATUS TABLESPACE_NAME------------------------------ ---------------- ------------------------------SYSTEM ONLINE SYSTEM_SYSSMU1$ NEEDS RECOVERY UNDOTBS1_SYSSMU2$ NEEDS RECOVERY UNDOTBS1_SYSSMU3$ NEEDS RECOVERY UNDOTBS1_SYSSMU4$ NEEDS RECOVERY UNDOTBS1_SYSSMU5$ NEEDS RECOVERY UNDOTBS1_SYSSMU6$ NEEDS RECOVERY UNDOTBS1
