数据库安装及数据库问题解决（七）

-----------------------------------------------------------------------------------------
看执行计划http://www.itpub.net/forum.php?mod=viewthread&tid=48185
改oracle@/opt/oracle$提示符：export PS1='$(whoami)@$PWD$'

添加重做日志组
ALTER DATABASE
ADD LOGFILE GROUP 6 '/home/oracle/app/oradata/mdspdbdz/redo06.log' SIZE 100M ,
            GROUP 7 '/home/oracle/app/oradata/mdspdbdz/redo07.log' SIZE 100M ,
            GROUP 8 '/home/oracle/app/oradata/mdspdbdz/redo08.log' SIZE 100M ,
            GROUP 9 '/home/oracle/app/oradata/mdspdbdz/redo09.log' SIZE 100M ,
            GROUP 10 '/home/oracle/app/oradata/mdspdbdz/redo10.log' SIZE 100M
;

创建回滚段表空间
清空回滚段操作
1、创建备份回滚段表空间：create undo tablespace undotbs3 datafile '/home/oracle/oradata/mdspdb/undotbs03.dbf' size 200M reuse autoextend on
 extent management local autoallocate; 
2、修改系统参数：alter system set undo_tablespace=undotbs3; 
 
2、删除主回滚段表空间drop tablespace  UNDOTBS1 including contents;
 
3、创建主回滚段表空间create undo tablespace undotbs1 datafile '/home/oracle/app/oradata/mdspdbdz/undotbs01.dbf' size 3072M reuse autoextend on
 extent management local autoallocate;
4、修改系统参数回去