UNDO表空间Offline处理过程

合集下载

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

sqlplus /nolog

SQL>connect / as sysdba;

SQL>startup mount pfile='d:\oracle\ora92\database\pfileorcl.ora'

结果如何？

还没完呢，告诉我结果！！

SQL> select segment_name,status from dba_rollback_segs;

SQL> create undo tablespace undo datafile 'Q:\ORACLE\ORADATA\ORCL\UNDO01.DBF' size 500M reuse autoextend on;

shutdown immediate;

*.undo_tablespace=undo

startup pfile='d:\oracle\ora92\database\pfileorcl.ora'

SQL>alter tablespace undotbs1 offline normal;

SQL> drop tablespace undotbs1 including contents and datafiles;

SQL>select * from v$recover_file;

SQL>shutdown immediate;

startup pfile='d:\oracle\ora92\database\pfileorcl.ora'

重新命名d:\oracle\ora92\database\spfileorcl.ora为spfileorcl.ora.bak

SQL>create spfile='d:\oracle\ora92\database\spfileorcl.ora' from pfile='d:\oracle\ora92\database\pfileorcl.ora'

SQL>shutdown immediate;

SQL>startup

SQL>connect sys/XXXXXX as sysdba;
d:/oracle>orapwd file='PWDORCL.ORA' password=XXXXX entries=50

orapwd file='d:\oracle\ora92\database\PWDORCL.ORA' passwor=vioadmin entries=50 中的passwor 为password

alter system set log_archive_start=TRUE scope=both;

emca -reconfig ports -dbcontrol_http_port 1160

emca -config dbcontrol db ports -dbcontrol_http_port 5500

emca -reconfig dbcontrol db ports -dbcontrol_http_port 5500

create tablespace rmants datafile '/rman/rman/rman01.ora' size 100M;

create user rman identified by rman default tablespace rmants temporary tablespace temp quota unlimited on rmants;